tb_po_signature_log.sql

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

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

create table PO_Signature_log
(
 Item int identity(1,1) not null primary key,
 Order_number varchar(30) not null,
 Version      numeric(3,1)  not null default 1.0,
 Signatured_By varchar(15) not null,
 Signatured_dt datetime not null default getdate()
)
go