tb_gl_job_mstr.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 15 行

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

Create table GL_JOB_Mstr
(
  JOB_ID	int not null identity(100,1) primary key,
  JOB_Title     varchar(120) not null, 
  context       Varchar(800) not null,
  Sender	varchar(15)   not null,
  Received      varchar(15) not null,
  creation_dt   datetime not null default getdate(),
  Status	CHAR(1) NOT NULL,
  Req_Reply     bit not null default 0
)