tb_gl_job_mstr ver2.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

if object_id('dbo.GL_JOB_Mstr') is not null
drop table dbo.GL_JOB_Mstr
go

Create table GL_JOB_Mstr
(
 JOB_ID   varchar(15) not null constraint job_mstr_pk primary key,
 Version  numeric(4,2) not null default 1.0,
 JOB_Type  CHAR(3) not null,
 JOB_Title varchar(80) not null,
 Priority  CHAR(1) NOT NULL default 'L',
 TO_Rcv    varchar(15) not null,
 From_By   varchar(15) not null,
 CC_To     varchar(15) not null,
 Status    CHAR(1)   not null default 'N',--completed or no
 Ask_Context    varchar(800) not null,
 Reply_Context  varchar(800) null,
 Reply_by       varchar(15) null,
 Reply_dt       datetime not null default getdate(),
 Creation_dt datetime not null default getdate(),
 Created_by varchar(15) not null,
 update_dt datetime not null default getdate(),
 Updated_by varchar(12) not null,
)
go

if object_id('dbo.PO_JOB_Number') is not null
drop table dbo.PO_JOB_Number
go

create table PO_Job_Number
(flag CHAR(3) NOT NULL DEFAULT 'JOB',
 Number int not null default 1,
 Last_Number varchar(15) not null
)
go
insert into PO_JOB_Number values('JOB',1,'JOB20050307-001')