16 lines
726 B
Transact-SQL
Executable File
16 lines
726 B
Transact-SQL
Executable File
-- 生产交付表:维护子项物料的线边仓库存数(按物料编码唯一,导入时覆盖更新)
|
|
IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE object_id=OBJECT_ID('Production_Delivery') AND type='U')
|
|
BEGIN
|
|
CREATE TABLE Production_Delivery (
|
|
Id INT IDENTITY(1,1) PRIMARY KEY,
|
|
MaterialCode NVARCHAR(100) NOT NULL,
|
|
MaterialName NVARCHAR(200) NOT NULL DEFAULT N'',
|
|
LineSideStock DECIMAL(18,2) NOT NULL DEFAULT 0,
|
|
StockDate DATE NULL,
|
|
CreateTime DATETIME NOT NULL DEFAULT GETDATE(),
|
|
UpdateTime DATETIME NOT NULL DEFAULT GETDATE()
|
|
)
|
|
CREATE UNIQUE INDEX UX_Production_Delivery_MaterialCode ON Production_Delivery(MaterialCode)
|
|
END
|
|
GO
|