调度数据库 SQL 建表语句
create sequence jd_number;
1.领料单
create table jd_rough_material
(product_type varchar2(12) not null,partno varchar2(14) not null,
taskno varchar2(12) not null, part_name varchar2(12),
number1 number(10),material varchar2(20) ,
material_type varchar2(10) ,material_size varchar2(20),
material_num number(10),start_date date ,
end_date date,storehouse varchar2(14),
send_place varchar2(14),receive_num number(10),
date1 date not null,sender varchar2(10),
receiver varchar2(10),dessigner varchar2(10),
primary key(product_type, partno, taskno, date1));
2.加工路线单
create table jd_processing_routes
(billno number(8) not null,date1 date not null,
workshop varchar2(14) ,worksection varchar2(14) ,
product_type varchar2(14) not null, partno varchar2(14) not null, part_name varchar2(14) ,
taskno varchar2(12) not null, number1 number(10) not null,
material_size varchar2(14) ,receive_number number(8),
checker varchar2(10), date2 date not null,send_number number(8) ,
inspecter varchar2(10),keeper varchar2(10),
primary key(date1,product_type, partno, taskno));
3.工票
create table jd_processing_bill
(date1 date ,workshop varchar2(14),
worksection varchar2(14) ,taskno varchar2(12) ,
product_type varchar2(30) ,partno varchar2(30) ,
part_name varchar2(12),procedure_no varchar2(10) ,
procedure_rate number(8),procedure_code varchar2(10),
task_number number(8) ,prepare_hour number(20,2) ,
part_hour number(20,2), task_hour number(20,2),
this_capacity_no varchar2(30),last_capacity_no varchar2(14),
next_capacity_no varchar2(14) ,startworking_date date,
endworking_date date,
working_hour number(8,2),assigner varchar2(10),
rationer varchar2(10) );
4.分票
create table jd_detached_bill
(billno number(8) , date1 date ,
workshop varchar2(14),worksection varchar2(14) not null,
taskno varchar2(12) not null, product_type varchar2(30) not null,
partno varchar2(30) not null,procedure_no varchar2(10) not null,