L ,
[Alias] [varchar] (10) COLLATE
Chinese_PRC_CI_AS NULL ,
[outid] [varchar] (20) COLLATE
Chinese_PRC_CI_AS NULL ,
[UpdateID] [tinyint] NOT NULL ,
[Pwd]
[char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[QuChargFare] [smallmoney]
NULL ,
[HasTaken] [tinyint] NULL ,
[DragonCardNo] [char] (19)
COLLATE Chinese_PRC_CI_AS NULL ,
[ApplyCharg] [smallmoney] NULL
,
[ChargPer] [smallmoney] NULL ,
[MingZu] [varchar] (20)
COLLATE Chinese_PRC_CI_AS NULL ,
[Sex] [char] (2) COLLATE
Chinese_PRC_CI_AS NULL ,
[Memo] [varchar] (100) COLLATE
Chinese_PRC_CI_AS NULL ,
[WeiPeiDW] [varchar] (10) COLLATE
Chinese_PRC_CI_AS NULL ,
[CardConsumeType] [tinyint] NULL
,
[LeaveSchoolDT] [datetime] NULL ,
[UseValidDT] [tinyint] NOT
NULL ,
[NoUseDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[T_Department] ( --单位帐本,三级单位制,树型结构
[DpCode1]
[char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DpCode2] [char] (2)
COLLATE Chinese_PRC_CI_AS NULL ,
[DpCode3] [char] (3) COLLATE
Chinese_PRC_CI_AS NULL ,
[DpName1] [varchar] (30) COLLATE
Chinese_PRC_CI_AS NULL ,
[DpName2] [varchar] (30) COLLATE
Chinese_PRC_CI_AS NULL ,
[DpName3] [varchar] (30) COLLATE
Chinese_PRC_CI_AS NULL ,
[N_SR] [int] NOT NULL ,
[BatNum]
[smallint] NULL
) ON [PRIMARY]
GO
上一页 [1] [2] |
