CREATE TABLE tbaccount (CARDNUM CHAR(18) NOT NULL, USERNAME CHAR(10) NOT NULL, PASSWORD CHAR(6) NOT NULL, REMAINS CHAR(9) NOT NULL, RECOUP CHAR(9) NOT NULL, STATE CHAR(1) NOT NULL, CHECKSTR CHAR(18) NOT NULL,  CHECK (CARDNUM IS NOT NULL),  CHECK (USERNAME IS NOT NULL),  CHECK (PASSWORD IS NOT NULL),  CHECK (REMAINS IS NOT NULL),  CHECK (RECOUP IS NOT NULL),  CHECK (STATE IS NOT NULL),  CHECK (CHECKSTR IS NOT NULL),  UNIQUE  (CARDNUM),  PRIMARY KEY (CARDNUM))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 10K NEXT 10K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50) TABLESPACE "USER_DATA";



CREATE TABLE tblog (CARDNUM CHAR(18) NOT NULL, TRADEDATE DATE DEFAULT sysdate  NOT NULL, TRADENUM NUMBER NOT NULL, TRADESUM CHAR(9) NOT NULL,  CHECK (CARDNUM IS NOT NULL),  CHECK (TRADEDATE IS NOT NULL),  CHECK (TRADENUM IS NOT NULL),  CHECK (TRADESUM IS NOT NULL),  UNIQUE  (TRADENUM),  PRIMARY KEY (TRADENUM))  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 10K NEXT 10K MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50) TABLESPACE "USER_DATA";



CREATE SEQUENCE trade_id start with 1000 INCREMENT BY 1;