【SQL开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了SQL开源代码-finance.sql的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
CREATE TABLE USR(
USER_ID INTEGER NOT NULL,
USER_NAME VARCHAR(16) NOT NULL,
PASSWORD VARCHAR(16) NOT NULL
);
ALTER TABLE USR ADD PRIMARY KEY (USER_ID);
CREATE TABLE ACC(
USER_ID INTEGER NOT NULL,
ACC_ID INTEGER NOT NULL,
ACC_NAME VARCHAR(30) NOT NULL
);
ALTER TABLE ACC ADD PRIMARY KEY (USER_ID, ACC_ID);
CREATE TABLE CAT(
USER_ID INTEGER NOT NULL,
CAT_ID INTEGER NOT NULL,
CAT_NAME VARCHAR(50) NOT NULL
);
ALTER TABLE CAT ADD PRIMARY KEY (USER_ID, CAT_ID);
ALTER TABLE ACC ADD FOREIGN KEY (USER_ID) REFERENCES USR (USER_ID);
ALTER TABLE CAT ADD FOREIGN KEY (USER_ID) REFERENCES USR (USER_ID);
CREATE TABLE TX(
USER_ID INTEGER NOT NULL,
ACC_ID INTEGER NOT NULL,
TX_ID INTEGER NOT NULL,
CAT_ID INTEGER NOT NULL,
TX_DATE DateTime NOT NULL,
PAYEE VARCHAR(50) NOT NULL,
AMT varchar(20) NOT NULL,
TRANSFER_ID INTEGER ,
REF VARCHAR(10) ,
DESCRIPTION VARCHAR(50) ,
CLR VARCHAR(30)
);
ALTER TABLE TX ADD PRIMARY KEY (USER_ID, ACC_ID, TX_ID);
CREATE TABLE COUNTER(
USER_ID INTEGER NOT NULL,
TABLE_NAME VARCHAR(20) NOT NULL,
NEXT_VALUE INTEGER NOT NULL
);
ALTER TABLE COUNTER ADD PRIMARY KEY (USER_ID, TABLE_NAME);