1201232063751.sql
资源名称:(J2EE)oa.rar [点击查看]
上传用户:lm2018
上传日期:2015-12-12
资源大小:30449k
文件大小:2k
源码类别:
Jsp/Servlet
开发平台:
Java
- 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)
- );