【SQL开源代码栏目提醒】:本文主要为网学会员提供AssetsRepair.sql,希望对需要AssetsRepair.sql网友有所帮助,学习一下!
USE Mis
GO
CREATE TABLE [AssetsRepair] (
[RepId] [int] IDENTITY (1, 1) NOT NULL ,
[Aid] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[RepairDate] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Reason] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Status] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Cost] [decimal](15, 2) NULL ,
[Result] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[PostDate] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_AssetsRepair] PRIMARY KEY CLUSTERED
(
[RepId]
) ON [PRIMARY]
) ON [PRIMARY]
GO