account.sql

一个简单的银行系统

create table jdbc_account
(	 id						number(7) 		primary key,
	cardId					varchar(15)		not null,
	password				varchar(6)		not null,
	name					varchar(20)		not null,
	personId				varchar(18)		not null,
	balance					number(7,2)	default 0.0,
	accountType				number
);

create sequence jdbc_account_seq minvalue 1000000 maxvalue 9999999 start with 1000000 increment by 1 nocache;