1201232063751.sql

来自「基于J2EE的办公自动化系统。实现流程定义流程办理等。运用了hibernate+」· SQL 代码 · 共 59 行

create table ACCOUNT  (
   ACC_ID               VARCHAR(8)                      not null,
   ACC_NAME             VARCHAR2(20),
   ACC_PWD              VARCHAR2(20),
   ACC_DEAL_STYLE       VARCHAR2(20),
   ACC_BALLANCE         NUMBER(15,2),
   ACC_REMARK           VARCHAR2(200),
   constraint PK_ACCOUNT primary key (ACC_ID)
);

create sequence ACCOUNT_ID_SEQ increment by 1 start with 100005 maxvalue 999999 nocycle;


create table STOCKINFO  (
   STOCKCODE          VARCHAR2(20),
   STOCKTYPE          VARCHAR2(20),
   STOCKABBREVIATE    VARCHAR2(20),
   PROCEDURE          NUMBER(10,3),
   LEASTPROCEDURE     NUMBER(10,2),
   TRANSFER           NUMBER(10,3),
   LEASTTRANSFER      NUMBER(10,2),
   STAMPTAX           NUMBER(10,3),
   TRUST              NUMBER(10,2)
);


create table DEAL_HISTORY  (
   DEAL_ID            VARCHAR(20)                     not null,
   DEAL_STYTLE        VARCHAR(10),
   ACC_ID             VARCHAR(8),
   STOCK_CODE         VARCHAR(8),
   STOCK_NAME         VARCHAR(20),
   MARK_TYPE          VARCHAR(8),                             
   DEAL_DATE          DATE,
   DEAL_PRICE         NUMBER(15,2),
   DEAL_AMOUNT        INTEGER,
   DEAL_PROCEDURE     NUMBER(15,2),
   DEAL_REMARK        VARCHAR(200),    
   constraint PK_DEAL_HISTORY primary key (DEAL_ID)
);

create table SUMMARYLIST  (
   SLIST_ID           VARCHAR(20)                     not null,
   ACC_ID             VARCHAR(8),
   MARK_TYPE          VARCHAR(8),
   STOCK_CODE         VARCHAR2(10),
   STOCK_NAME         VARCHAR2(20),
   CURR_PRICE         NUMBER(15,2),
   STOCK_AMOUNT       INTEGER,
   LESSCOST_PRICE         NUMBER(15,2),
   FLOAT_GAIN_LOSS    NUMBER(15,2),
   constraint PK_SUMMARYLIST primary key (SLIST_ID)
);