人事信息管理系統(tǒng)后臺數(shù)據(jù)庫設(shè)計(已改無錯字)
2023-05-09 07:49:43 本頁面
【正文】 LLATE Chinese_PRC_CI_AS NOT NULL, [缺勤] [int] NULL, [遲到] [int] NULL, [早退] [int] NULL, [日期] [datetime] NOT NULL) ON [PRIMARY]GOUSE [rs]GOCREATE TABLE [dbo].[員工調(diào)動信息表]( [員工編號] [char](9) COLLATE Chinese_PRC_CI_AS NOT NULL, [姓名] [char](8) COLLATE Chinese_PRC_CI_AS NOT NULL, [原部門編號] [char](4) COLLATE Chinese_PRC_CI_AS NULL, [新部門編號] [char](4) COLLATE Chinese_PRC_CI_AS NULL, [調(diào)離時間] [datetime] NULL, [調(diào)入時間] [datetime] NULL) ON [PRIMARY]GOUSE [rs]GOCREATE VIEW [dbo].[部門員工工作信息]ASSELECT TOP (100) PERCENT 部門的編號, 部門的名稱, , , , FROM JOIN = JOIN = ORDER BY GOUSE [rs]GOCREATE VIEW [dbo].[員工工資信息]ASSELECT TOP (100) PERCENT , , , , FROM JOIN = ORDER BY GOUSE [rs]GOCREATE VIEW [dbo].[員工工作信息]ASSELECT , , , , , FROM JOIN = JOIN = GOUSE [rs]GOCREATE VIEW [dbo].[員工考勤信息]ASSELECT , , , , , FROM JOIN = GOUSE [rs]GOCREATE VIEW [dbo].[員工信息]ASSELECT , , , , , , , , , , FROM JOIN = GOUSE [rs]GOCREATE VIEW [dbo].[各部門員工調(diào)動信息]ASSELECT TOP (100) PERCENT 新部門名稱, , , , , 原部門名稱, 原部門編號, FROM JOIN = JOIN 部門信息表_1 ON = ORDER BY 原部門編號GO部門編號唯一索引USE [rs]GOCREATE UNIQUE NONCLUSTERED INDEX [部門編號] ON [dbo].[部門信息表] ( [部門編號] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]部門名稱唯一索引USE [rs]GOCREATE UNIQUE NONCLUSTERED INDEX [部門名稱] ON [dbo].[部門信息表] ( [部門名稱] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]扣款不唯一索引USE [rs]GOCREATE NONCLUSTERED INDEX [扣款] ON [dbo].[工資信息表] ( [扣款] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]實發(fā)工資不唯一索引USE [rs]GOCREATE NONCLUSTERED INDEX [實發(fā)工資] ON [dbo].[工資信息表] ( [實發(fā)工資] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]遲到不唯一索引USE [rs]GOCREATE NONCLUSTERED INDEX [遲到] ON [dbo].[考勤信息表] ( [遲到] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]早退不唯一索引USE [rs]GOCREATE NONCLUSTERED INDEX [早退] ON [dbo].[考勤信息表] ( [早退] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]原部門編號不唯一索引USE [rs]GOCREATE NONCLUSTERED INDEX [原部門編號] ON [dbo].[員工調(diào)動信息表] ( [原部門編號] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]新部門編號不唯一索引USE [rs]GOCREATE NONCLUSTERED INDEX [新部門編號] ON [dbo].[員工調(diào)動信息表] ( [新部門編號] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]工齡不唯一索引USE [rs]GOCREATE NONCLUSTERED INDEX [工齡] ON [dbo].[員工工作信息表] ( [工齡] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]職稱不唯一索引USE [rs]GOCREATE NONCLUSTERED INDEX [職稱] ON [dbo].[員工工作信息表] ( [職稱] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]員工編號唯一索引USE [rs]GOCREATE UNIQUE NONCLUSTERED INDEX [員工編號] ON [dbo].[員工信息表] ( [員工編號] ASC)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNO
公司管理相關(guān)推薦
鄂ICP備17016276號-1