sql.sql

java超市项目的项目源码,这是非常好的,写的很规范的源码呀.

drop table table_user;

create table Table_user(
name varchar2(20),
password varchar2(20),
quanxian varchar2(5),
constraint name primary key(name)
);

insert into table_user values('jingli','jingli','1');
insert into table_user values('caiwu','caiwu','2');
insert into table_user values('beifen','beifen','3');

drop table table_income;

create table Table_income(
Income_ID number(10),
Dept_id number(10),
Daily_income number(20),
Business_Date date,
Lst_mod_timestemp date,
constraint Income_ID primary key(Income_ID)
);

drop table table_dept;

create table Table_dept(
Dept_ID number(5),
Dept_name varchar2(20),
Dept_descreption varchar2(40),
constraint Dept_ID primary key(Dept_ID)
);

create table Table_Vendor(
Vendor_ID number(10),
Vendor_name varchar2(20),
Vendor_address varchar2(20),
Vendor_phone number(20),
Vendor_fax number(20),
Vendor_contact_person varchar2(15),
constraint Vendor_ID primary key(Vendor_ID)
);