drop table "USER" cascade constraints; /*==============================================================*/
/* Table: "USER" */
/*==============================================================*/
create table "USER"
(
USER_ID NUMBER(4) not null,
USER_NAME VARCHAR2(15) not null,
USER_PASSWORD VARCHAR2(8) not null,
USER_SFJE NUMBER(8,2) not null,
USER_DFJE NUMBER(8,2) not null,
USER_SUM NUMBER(8,2) not null,
USER_DATE DATE not null,
constraint PK_USER primary key (USER_ID)
); comment on table "USER" is
'用户表'; comment on column "USER".USER_ID is
'用户id'; comment on column "USER".USER_NAME is
'用户名称';
alter table WATER
drop constraint FK_WATER_REFERENCE_USER; drop table WATER cascade constraints; /*==============================================================*/
/* Table: WATER */
/*==============================================================*/
create table WATER
(
USER_ID NUMERIC(4),
W_MONTH CHAR(6),
W_YL NUMBER(8,2),
W_SFJE NUMBER(8,2),
W_SFJF CHAR(6)
); alter table WATER
add constraint FK_WATER_REFERENCE_USER foreign key (USER_ID)
references "USER" (USER_ID);
alter table POWER
drop constraint FK_POWER_REFERENCE_USER; drop table POWER cascade constraints; /*==============================================================*/
/* Table: POWER */
/*==============================================================*/
create table POWER
(
USER_ID NUMBER(4) not null,
P_MONTH CHAR(5) not null,
P_YL NUMERIC(8, 2) not null,
P_DFJE NUMERIC(8, 2) not null,
P_SFJF CHAR(6)
); alter table POWER
add constraint FK_POWER_REFERENCE_USER foreign key (USER_ID)
references "USER" (USER_ID);
drop table MONEY cascade constraints; /*==============================================================*/
/* Table: MONEY */
/*==============================================================*/
create table MONEY
(
M_MONTH CHAR(5) not null,
M_SF NUMBER(8,2) not null,
M_DF NUMBER(8,2) not null
);
drop table ADMIN cascade constraints; /*==============================================================*/
/* Table: ADMIN */
/*==============================================================*/
create table ADMIN
(
ADMIN_ID NUMBER(10) not null,
ADMIN_NAME VARCHAR2(20) not null,
ADMIN_PW VARCHAR2(10) not null,
CREAD_TIME DATE,
constraint PK_ADMIN primary key (ADMIN_ID)
); comment on table ADMIN is
'管理员表'; comment on column ADMIN.ADMIN_ID is
'管理员id'; comment on column ADMIN.ADMIN_NAME is
'管理员名称'; comment on column ADMIN.ADMIN_PW is
'密码'; comment on column ADMIN.CREAD_TIME is
'创建时间';