create table s_dept_relation ( dept_id numeric not null, dept_name varchar(30), pre_dept_id numeric, permission_id numeric, primary key (dept_id) ); insert into s_dept_relation values (1,"董事办公室",0,1); insert into s_dept_relation values (2,"营业",1,2); insert into s_dept_relation values (3,"资财",1,2); insert into s_dept_relation values (4,"式样",1,2); create table s_permission ( permission_id numeric not null, permission_style char(1), permission_info varchar(30), primary key (permission_id) ); insert into s_permission values (1,'A',"所有权限"); insert into s_permission values (2,'B',"限制权限"); create table s_login ( login_id varchar(20) not null, login_pwd varchar(20), login_status char(1), primary key (login_id) ); insert into s_login values ("admin","admin",'N'); insert into s_login values ("user","user",'N'); insert into s_login values ("li","li",'N'); insert into s_login values ("su","su",'N'); create table s_staff ( staff_id numeric not null, staff_name varchar(10), staff_post varchar(20), satff_age numeric, staff_sex varchar(10), staff_birthday date, staff_workphone numeric(15), staff_mophone numeric(15), staff_email varchar(50), staff_dept_id numeric, staff_login_id varchar(20), staff_msn varchar(30), staff_qq numeric(10), staff_skype varchar(30), staff_wangwang varchar(30), staff_permission_id numeric, primary key (staff_id) ); insert into s_staff values (1,"马1","老总",1,"","1980-01-01",4,2," ",1,"admin"," ",375734390," "," ",1); insert into s_staff values (2,"李1","职员",1,"女","1982-01-01",4,2," ",1,"admin"," ",135369100," "," ",2); insert into s_staff values (3,"苏1","职员",1,"女","1984-01-01",4,2," ",1,"admin"," ",123456789," "," ",2); insert into s_staff values (4,"马2","老总",1,"","1980-01-01",4,2," ",1,"admin"," ",375734390," "," ",1); insert into s_staff values (5,"李2","职员",1,"女","1982-01-01",4,2," ",1,"admin"," ",135369100," "," ",2); insert into s_staff values (6,"苏2","职员",1,"女","1984-01-01",4,2," ",1,"admin"," ",123456789," "," ",2); insert into s_staff values (7,"马3","老总",1,"","1980-01-01",4,2," ",1,"admin"," ",375734390," "," ",1); insert into s_staff values (8,"李3","职员",1,"女","1982-01-01",4,2," ",1,"admin"," ",135369100," "," ",2); insert into s_staff values (9,"苏3","职员",1,"女","1984-01-01",4,2," ",1,"admin"," ",123456789," "," ",2); update s_staff set staff_login_id="li" where staff_id=2; update s_staff set staff_login_id="su" where staff_id=3; create table s_business ( business_id numeric not null, business_style char, business_company varchar(50), employer_addr varchar(50), business_get_time date, employer_name varchar(10), employer_phone numeric(15), business_cost int, operation_name varchar(10), check_name varchar(10), business_comment varchar(100), business_file char(10), check_status char, assign_status char, business_tax double, agent_name varchar(10), agent_phone numeric(15), primary key (business_id) ); insert into s_business values ('100','A',"","","2011-03-03","张三",13850268952,50000,"李","苏","",'','','',500,"",13658635456); insert into s_business values ('101','B',"","","2011-03-04","李四",13850212952,60000,"李","苏","",'','','',500,"",13655635456); insert into s_business values ('102','A',"","","2011-03-04","王八",13851268952,12000,"李","苏","",'','','',500,"",13678635456); insert into s_business values ('103','B',"","","2011-03-05","赵五",13850265652,78000,"苏","苏","",'','','',500,"",13658678456); insert into s_business values ('104','A',"","","2011-03-07","老七",13823468952,54000,"李","苏","",'','','',500,"",13651235456); create table s_business_percentage ( business_style char not null, business_name varchar(20), business_percentage double, primary key (business_style) ); insert into s_business_percentage values ('A',"登记",10); insert into s_business_percentage values ('B',"报告",20); 部门关系表 s_dept_relation 权限类型 s_permission 登陆表 s_login 职工表 s_staff 业务表 s_business 业务提成 s_business_percentage
