rangjie数据库

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