if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__DepartmentInform__20C1E124]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[DepartmentInformation] DROP CONSTRAINT FK__DepartmentInform__20C1E124
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__EmployeeI__E_Nam__21B6055D]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[EmployeeInformation] DROP CONSTRAINT FK__EmployeeI__E_Nam__21B6055D
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__EmployeeI__E_Nam__22AA2996]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[EmployeeInformation] DROP CONSTRAINT FK__EmployeeI__E_Nam__22AA2996
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__EmployeeI__E_Nam__239E4DCF]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[EmployeeInformation] DROP CONSTRAINT FK__EmployeeI__E_Nam__239E4DCF
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK__EmployeeI__E_Nam__24927208]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[EmployeeInformation] DROP CONSTRAINT FK__EmployeeI__E_Nam__24927208
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DepartmentInformation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DepartmentInformation]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EmployeeInformation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[EmployeeInformation]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EncouragementPunishInformation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[EncouragementPunishInformation]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TrainInformation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TrainInformation]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserInformation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserInformation]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WageInformation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[WageInformation]
GO
CREATE TABLE [dbo].[DepartmentInformation] (
[E_Number] [int] IDENTITY (1, 1) NOT NULL ,
[E_Department] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[D_Count] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[EmployeeInformation] (
[E_Number] [int] IDENTITY (1, 1) NOT NULL ,
[E_Name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_Sex] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_BornDate] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_Marriage] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_PoliticsVisage] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_SchoolAge] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_EnterDate] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_InDueFormDate] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_Department] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_Headship] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_Estate] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[E_Remark] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[EncouragementPunishInformation] (
[EP_Number] [int] IDENTITY (1, 1) NOT NULL ,
[E_Name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[EP_Date] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[EP_Address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[EP_Causation] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[EP_Remark] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TrainInformation] (
[T_Number] [varchar�
使用JAVA语言编写,SQL server 教师信息管理系统
版权申诉
5星 · 超过95%的资源 3 浏览量
2022-06-30
16:58:34
上传
评论 1
收藏 275KB ZIP 举报
处处清欢
- 粉丝: 158
- 资源: 2511
最新资源
- 基于Java的网上订餐系统设计源码 - online ordering system
- 基于Javascript的超级美眉网络资源管理应用模块设计源码
- 基于Typescript和PHP的编程知识储备库设计源码 - study-php
- Screenshot_2024-05-28-11-40-58-177_com.tencent.mm.jpg
- 基于Dart的Flutter小提琴调音器APP设计源码 - violinhelper
- 基于JavaScript和CSS的随寻订购网页设计源码 - web-order
- 基于MATLAB的声纹识别系统设计源码 - VoiceprintRecognition
- 基于Java的微服务插件集合设计源码 - wsy-plugins
- 基于Vue和微信小程序的监理日志系统设计源码 - supervisionLog
- 基于Java和LCN分布式事务框架的设计源码 - tx-lcn
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈