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.
|
|
CREATE TABLE OTB_SYS_Organization([OrganizationID] [Varchar](36 )NOT NULL,--��´�s�� [OrganizationName] [NVarchar](200)NOT NULL,--��´�W�� [OwnerName] [NVarchar](50 ) NULL,--�t�d�H�m�W [Email] [NVarchar](200) NULL,--�ϥΪ�E-Mail[ContectTEL] [Varchar](50 ) NULL,--�p���q�� [ContectExt] [Varchar](20 ) NULL,--�p������ [ContectFax] [Varchar](50 ) NULL,--�p���ǯu [ContectCell] [Varchar](50 ) NULL,--�p������ [Address] [NVarchar](500) NULL,--���} [Files] [Varchar](36 ) NULL,--���� [EffectiveSD] [DateTime] NULL,--�ͮĶ}�l����[EffectiveED] [DateTime] NULL,--�ͮĵ�������[Effective] [Char](1 ) NULL,--�O�_���� [Memo] [Text] NULL,--�Ƶ� [CreateUser] [Varchar](50 ) NULL,--�إߤH���b��[CreateDate] [DateTime] NULL,--�إߤ��� [ModifyUser] [Varchar](50 ) NULL,--�ק��H���b��[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]
|
