tb_po_vndcontact_mstr.sql

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

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

Create table PO_VndContact_Mstr
(
 Vendor_id char(8) not null constraint fk_Vndcontract_mstr references PO_Vendor_Mstr(vendor_id),
 Item	   int not null,
 Last_nm   varchar(15)  null ,
 First_nm  varchar(15)  null,
 Title     char(4) not null,
 Nickname  varchar(30) not null,
 Country  varchar(15)  null,
 Language varchar(30) null,
 Telephone varchar(22) null,
 Extension1  varchar(10) null,  
 Fax       varchar(22) null,
 Extension2  varchar(10) null,    
 Mobile1    varchar(11) null,
 Mobile2    varchar(11) null,
 Email1      varchar(30) null,
 Email2      varchar(30) null,
 Priority    int not null default 1,
 Status     Char(1) not null default ('A'),
 Follow_Buyer varchar(30) null,
 Created_By   varchar(15) not null,
 Creation_dt  datetime not null default getdate(),
 Updated_By   varchar(15) not null,
 Update_dt    datetime not null default getdate()
)
go