/*==============================================================*/
/* Table: MANAGE_PAYIN                                          */
/*==============================================================*/
create table MANAGE_PAYIN  (
   PAYIN_ID             varchar2(100)                   not null,
   USER_ID              varchar2(100),
   PAYIN_NAME           varchar2(100),
   PAYIN_MONEY          number(10,2),
   PAYIN_DATE           varchar2(100),
   constraint PK_MANAGE_PAYIN primary key (PAYIN_ID)
);

comment on column MANAGE_PAYIN.PAYIN_ID is
'收入主键';

comment on column MANAGE_PAYIN.USER_ID is
'用户id';

comment on column MANAGE_PAYIN.PAYIN_NAME is
'收入名称';

comment on column MANAGE_PAYIN.PAYIN_MONEY is
'收入金额';

comment on column MANAGE_PAYIN.PAYIN_DATE is
'收入时间';

/*==============================================================*/
/* Table: MANAGE_PAYOUT                                         */
/*==============================================================*/
create table MANAGE_PAYOUT  (
   PAYOUT_ID            varchar2(100)                   not null,
   USER_ID              varchar2(100),
   PAYOUT_NAME          varchar2(100),
   PAYOUT_MONEY         number(10,2),
   PAYOUT_DATE          varchar2(100),
   constraint PK_MANAGE_PAYOUT primary key (PAYOUT_ID)
);

comment on column MANAGE_PAYOUT.PAYOUT_ID is
'支出信息id';

comment on column MANAGE_PAYOUT.USER_ID is
'用户id';

comment on column MANAGE_PAYOUT.PAYOUT_NAME is
'支出名称';

comment on column MANAGE_PAYOUT.PAYOUT_MONEY is
'支出金额';

comment on column MANAGE_PAYOUT.PAYOUT_DATE is
'支出日期';

/*==============================================================*/
/* Table: MANAGE_USER                                           */
/*==============================================================*/
create table MANAGE_USER  (
   USER_ID              varchar2(100)                   not null,
   USER_NAME            varchar2(100),
   USER_PWD             varchar2(100),
   USER_QX              varchar2(10),
   USER_BALANCE         number(10,2),
   constraint PK_MANAGE_USER primary key (USER_ID)
);

comment on column MANAGE_USER.USER_ID is
'用户id';

comment on column MANAGE_USER.USER_NAME is
'用户名';

comment on column MANAGE_USER.USER_PWD is
'用户密码';

comment on column MANAGE_USER.USER_QX is
'用户权限';

comment on column MANAGE_USER.USER_BALANCE is
'个人余额';

/*==============================================================*/
/* constraint                                                   */
/*==============================================================*/

alter table MANAGE_PAYIN
   add constraint payIn foreign key (USER_ID)
      references MANAGE_USER (USER_ID);

alter table MANAGE_PAYOUT
   add constraint payOut foreign key (USER_ID)
      references MANAGE_USER (USER_ID);

/*==============================================================*/
/* test data                                                    */
/*==============================================================*/

Insert into SCOTT.MANAGE_USER (USER_ID,USER_NAME,USER_PWD,USER_QX,USER_BALANCE) values ('1','jahen','jahen',null,null);

Insert into SCOTT.MANAGE_PAYOUT (PAYOUT_ID,USER_ID,PAYOUT_NAME,PAYOUT_MONEY,PAYOUT_DATE) values ('1','1','午饭',9,'2017-3-18');

Insert into SCOTT.MANAGE_PAYIN (PAYIN_ID,USER_ID,PAYIN_NAME,PAYIN_MONEY,PAYIN_DATE) values ('1','1','捡钱',10,'2017-3-18');