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]