You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
28 lines
1.2 KiB
28 lines
1.2 KiB
|
|
CREATE TABLE OTB_SYS_Organization(
|
|
[OrganizationID] [Varchar](36 )NOT NULL,--組織編號
|
|
[OrganizationName] [NVarchar](200)NOT NULL,--組織名稱
|
|
[OwnerName] [NVarchar](50 ) NULL,--負責人姓名
|
|
[Email] [NVarchar](200) NULL,--使用者E-Mail
|
|
[ContectTEL] [Varchar](50 ) NULL,--聯絡電話
|
|
[ContectExt] [Varchar](20 ) NULL,--聯絡分機
|
|
[ContectFax] [Varchar](50 ) NULL,--聯絡傳真
|
|
[ContectCell] [Varchar](50 ) NULL,--聯絡手機
|
|
[Address] [NVarchar](500) NULL,--住址
|
|
[Files] [Varchar](36 ) NULL,--附件
|
|
[EffectiveSD] [DateTime] NULL,--生效開始日期
|
|
[EffectiveED] [DateTime] NULL,--生效結束日期
|
|
[Effective] [Char](1 ) NULL,--是否有效
|
|
[Memo] [Text] NULL,--備註
|
|
[CreateUser] [Varchar](50 ) NULL,--建立人員帳號
|
|
[CreateDate] [DateTime] NULL,--建立日期
|
|
[ModifyUser] [Varchar](50 ) NULL,--修改人員帳號
|
|
[ModifyDate] [DateTime] NULL,--修改日期
|
|
|
|
CONSTRAINT [PK_OTB_SYS_Organization] PRIMARY KEY CLUSTERED
|
|
(
|
|
[OrganizationID] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
|