【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了AssetsInfo.sql提供大家参考,希望对大家有所帮助!
USE Mis
GO
CREATE TABLE [AssetsInfo] (
[AId] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[AName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[TypeId] [int] NULL ,
[Model] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[Producer] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[UseDate] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[UsedYear] [int] NULL ,
[OrgPrice] [decimal](15, 2) NULL ,
[Ratio] [decimal](7, 5) NULL ,
[RepEmpId] [int] NULL ,
[Flag] [tinyint] NULL ,
[AddWayId] [int] NULL ,
[PostDate] [varchar] (20) NULL ,
[IsDiscount] [tinyint] NULL ,
CONSTRAINT [PK_AssetsInfo] PRIMARY KEY CLUSTERED
(
[AId]
) ON [PRIMARY]
) ON [PRIMARY]
GO