tb_po_rfq_hdr.sql

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

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

create table PO_RFQ_Hdr
(
 RFQ_Number varchar(10) NOT NULL constraint RFQ_PK primary key,
 RFQ_TYPE   CHAR(4) NOT NULL DEFAULT 'STD',
 Version    int not null,
 Vendor_ID  CHAR(10) NULL,
 Vendor_NM  VARCHAR(120) NULL,
 DeadLine   Datetime not null default getdate(),
 RFQ_Date   Datetime not null default getdate(),
 Customer_ID varchar(5) null,
 Customer_nm varchar(120) null,
 Model_Number varchar(30) null,
 Model_nm     varchar(120) null,
 Remark       varchar(120) null,
 Creation_dt datetime not null default getdate(),
 Created_by  varchar(15) not null,
 Update_dt   Datetime not null default getdate(),
 Updated_by  varchar(15) not null
)
go