CREATE TABLE [dbo].[teacher](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[tid] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[tname] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[collid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_teacher_collid_1]  DEFAULT ('07'),
	[tsex] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
	[ttel] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[temail] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[deptid] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[thonor] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[taddress] [varchar](350) COLLATE Chinese_PRC_CI_AS NULL,
	[tdire] [varchar](300) COLLATE Chinese_PRC_CI_AS NULL,
	[User_Group] [smallint] NULL CONSTRAINT [DF_teacher_User_Group_1]  DEFAULT ((5)),
	[User_sign] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[pwd] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_teacher_pwd_1]  DEFAULT ('123456'),
	[USE_YES] [int] NULL CONSTRAINT [DF_teacher_USE_YES_1]  DEFAULT ((1)),
	[zy1] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_teacher_zy1_1]  DEFAULT ('0000'),
	[zy2] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_teacher_zy2_1]  DEFAULT ('0000'),
	[zy3] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_teacher_zy3_1]  DEFAULT ('0000'),
	[bz] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[BIR] [datetime] NULL,
 CONSTRAINT [PK_teacher_1] PRIMARY KEY CLUSTERED 
(
	[tid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]



CREATE TABLE [dbo].[department](
	[deptid] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[dept] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[COLLid] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[univerid] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[id] [bigint] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_department_1] PRIMARY KEY CLUSTERED 
(
	[deptid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


CREATE TABLE [dbo].[coll](
	[collid] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[coll] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_coll] PRIMARY KEY CLUSTERED 
(
	[collid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]