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]

GO


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]

GO

CREATE TABLE [dbo].[sclass](
	[classid] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[className] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[mid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_sclass] PRIMARY KEY CLUSTERED 
(
	[classid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[Major](
	[mid] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[majorname] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[collid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[deptid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[univerid] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_belong] PRIMARY KEY CLUSTERED 
(
	[mid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO

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]

GO


CREATE TABLE [dbo].[student](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[sid] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[sname] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[mid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[sgrade] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[classid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[ssex] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
	[stel] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[semail] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[collid] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[User_Group] [smallint] NULL,
	[pwd] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[bir] [datetime] NULL,
	[INGRADE] [int] NULL,
	[sdate] [smalldatetime] NULL,
	[EXCEL] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[PaperName] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
	[score] [decimal](11, 2) NULL,
	[Tea] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[ban] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[PYtea] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[DBzc] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[Sstatus] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[NF] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[XDS_BZ] [nvarchar](510) COLLATE Chinese_PRC_CI_AS NULL,
	[deptid] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
	[paperLX] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,
	[paperXZ] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL,
	[paperDL] [nvarchar](350) COLLATE Chinese_PRC_CI_AS NULL,
	[DBtea8] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_student_2] PRIMARY KEY CLUSTERED 
(
	[sid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]