tb_po_signature_log.sql

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

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