首页 > 代码库 > power designer 水电费缴纳系统的设计

power designer 水电费缴纳系统的设计

技术分享

 

技术分享

技术分享

技术分享

技术分享

alter table POWER
   drop constraint FK_POWER_REFERENCE_USERS;

drop table POWER cascade constraints;

/*==============================================================*/
/* Table: POWER                                                 */
/*==============================================================*/
create table POWER 
(
   POWER_NUM            NUMBER               not null,
   USERS_ID             VARCHAR2(12)         not null,
   POWER_YESORNO        VARCHAR2(3)          not null,
   POWER_TIME           DATE,
   POWER_ACCOUNT        NUMBER(9,2)          not null,
   TODAYPOWER           NUMBER(9,2)          not null,
   POWER_MONEY          NUMBER(9,2)          not null,
   POWER_SUM            NUMBER(9,2)          not null,
   constraint PK_POWER primary key (POWER_NUM)
);

comment on table POWER is
电费缴纳信息表;

comment on column POWER.POWER_NUM is
缴费编号;

comment on column POWER.USERS_ID is
用户id;

comment on column POWER.POWER_YESORNO is
是否缴费;

comment on column POWER.POWER_TIME is
缴费时间;

comment on column POWER.POWER_ACCOUNT is
本月用电量;

comment on column POWER.TODAYPOWER is
当前水费标准;

comment on column POWER.POWER_MONEY is
本月应缴费用;

comment on column POWER.POWER_SUM is
截至上月共计电费金额;

alter table POWER
   add constraint FK_POWER_REFERENCE_USERS foreign key (USERS_ID)
      references USERS (USERS_ID);

技术分享

alter table WATER
   drop constraint FK_WATER_REFERENCE_USERS;

drop table WATER cascade constraints;

/*==============================================================*/
/* Table: WATER                                                 */
/*==============================================================*/
create table WATER 
(
   WATER_NUM            NUMBER               not null,
   USERS_ID             VARCHAR(12),
   WATER_YESORNO        VARCHAR2(3)          not null,
   WATER_TIME           DATE,
   WATER_ACCOUNT        NUMBER(9,2)          not null,
   TODAYWATER           NUMBER(9,2)          not null,
   WATER_MONEY          NUMBER(9,2)          not null,
   WATER_SUM            NUMBER               not null,
   constraint PK_WATER primary key (WATER_NUM)
);

comment on table WATER is
水费缴纳信息表;

comment on column WATER.WATER_NUM is
缴费编号;

comment on column WATER.USERS_ID is
用户id;

comment on column WATER.WATER_YESORNO is
是否缴费;

comment on column WATER.WATER_TIME is
缴费时间;

comment on column WATER.WATER_ACCOUNT is
本月用水量;

comment on column WATER.TODAYWATER is
当前水费标准;

comment on column WATER.WATER_MONEY is
本月应缴费用;

comment on column WATER.WATER_SUM is
截至上月共计水费金额;

alter table WATER
   add constraint FK_WATER_REFERENCE_USERS foreign key (USERS_ID)
      references USERS (USERS_ID);

技术分享

技术分享

技术分享

 

power designer 水电费缴纳系统的设计