⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 hrdb.sql

📁 金华门禁系统数据库脚本,涵盖了门禁,售饭,人力资源管理等
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[d26c] [decimal](4, 2) NULL ,
	[d26d] [decimal](4, 2) NULL ,
	[d27a] [decimal](4, 2) NULL ,
	[d27b] [decimal](4, 2) NULL ,
	[d27c] [decimal](4, 2) NULL ,
	[d27d] [decimal](4, 2) NULL ,
	[d28a] [decimal](4, 2) NULL ,
	[d28b] [decimal](4, 2) NULL ,
	[d28c] [decimal](4, 2) NULL ,
	[d28d] [decimal](4, 2) NULL ,
	[d29a] [decimal](4, 2) NULL ,
	[d29b] [decimal](4, 2) NULL ,
	[d29c] [decimal](4, 2) NULL ,
	[d29d] [decimal](4, 2) NULL ,
	[d30a] [decimal](4, 2) NULL ,
	[d30b] [decimal](4, 2) NULL ,
	[d30c] [decimal](4, 2) NULL ,
	[d30d] [decimal](4, 2) NULL ,
	[d31a] [decimal](4, 2) NULL ,
	[d31b] [decimal](4, 2) NULL ,
	[d31c] [decimal](4, 2) NULL ,
	[d31d] [decimal](4, 2) NULL ,
	[M1] [decimal](6, 2) NULL ,
	[M2] [decimal](6, 2) NULL ,
	[M3] [decimal](6, 2) NULL ,
	[M4] [decimal](6, 2) NULL ,
	[M5] [decimal](6, 2) NULL ,
	[M6] [decimal](6, 2) NULL ,
	[M7] [decimal](6, 2) NULL ,
	[M8] [decimal](6, 2) NULL ,
	[M9] [decimal](6, 2) NULL ,
	[M10] [decimal](6, 2) NULL ,
	[M11] [decimal](6, 2) NULL ,
	[M12] [decimal](6, 2) NULL ,
	[M13] [decimal](6, 2) NULL ,
	[M14] [decimal](6, 2) NULL ,
	[M15] [decimal](6, 2) NULL ,
	[M16] [decimal](6, 2) NULL ,
	[M17] [decimal](6, 2) NULL ,
	[M18] [decimal](6, 2) NULL ,
	[M19] [decimal](6, 2) NULL ,
	[M20] [decimal](6, 2) NULL ,
	[M21] [decimal](6, 2) NULL ,
	[M22] [decimal](6, 2) NULL ,
	[M23] [decimal](6, 2) NULL ,
	[M24] [decimal](6, 2) NULL ,
	[M25] [decimal](6, 2) NULL ,
	[M26] [decimal](6, 2) NULL ,
	[M27] [decimal](6, 2) NULL ,
	[M28] [decimal](6, 2) NULL ,
	[M29] [decimal](6, 2) NULL ,
	[M30] [decimal](6, 2) NULL ,
	[M31] [decimal](6, 2) NULL ,
	[bmbh] [int] NULL ,
	[gshj] [decimal](10, 2) NULL ,
	[jehj] [decimal](10, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cqqkrbb] (
	[rq] [datetime] NOT NULL ,
	[bm] [varchar] (30) NOT NULL ,
	[subbm] [varchar] (30) NOT NULL ,
	[yd] [varchar] (10) NULL ,
	[sd] [varchar] (10) NULL ,
	[cql] [varchar] (10) NULL ,
	[zrsbfb] [varchar] (10) NULL ,
	[qj] [varchar] (10) NULL ,
	[cf] [varchar] (10) NULL ,
	[kg] [varchar] (10) NULL ,
	[gs] [varchar] (10) NULL ,
	[ct] [varchar] (10) NULL ,
	[zl] [varchar] (10) NULL ,
	[bz] [varchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cqqktj] (
	[rq] [datetime] NOT NULL ,
	[zc] [char] (20) NOT NULL ,
	[cqrs] [int] NULL ,
	[wskrs] [int] NULL ,
	[user1] [int] NULL ,
	[user2] [int] NULL ,
	[user3] [char] (40) NULL ,
	[user4] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dataread] (
	[reportname] [char] (20) NOT NULL ,
	[isreadonly] [char] (1) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dchzb] (
	[bh] [int] NOT NULL ,
	[xm] [varchar] (10) NULL ,
	[bm] [varchar] (10) NULL ,
	[c1] [smallint] NULL ,
	[c2] [smallint] NULL ,
	[c3] [smallint] NULL ,
	[c4] [smallint] NULL ,
	[c5] [smallint] NULL ,
	[start_date] [datetime] NOT NULL ,
	[end_date] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dcsjb] (
	[cb] [char] (2) NOT NULL ,
	[cm] [varchar] (10) NULL ,
	[begin_time] [datetime] NULL ,
	[end_time] [datetime] NULL ,
	[fy] [smallmoney] NULL ,
	[bt] [smallmoney] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ddgx] (
	[ddbh] [char] (60) NOT NULL ,
	[cpbh] [char] (60) NOT NULL ,
	[cpmc] [char] (60) NULL ,
	[xh] [int] NULL ,
	[gxbh] [char] (60) NOT NULL ,
	[gxmc] [char] (60) NULL ,
	[dj] [decimal](12, 6) NULL ,
	[gxsl] [int] NULL ,
	[ddycl] [int] NULL ,
	[gxycl] [int] NULL ,
	[by1] [char] (60) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dep_salary_lb] (
	[month] [char] (7) NOT NULL ,
	[bmmc] [char] (40) NOT NULL ,
	[lb] [char] (20) NOT NULL ,
	[empcount] [int] NULL ,
	[yfhj] [money] NULL ,
	[pjgz] [money] NULL ,
	[btjb] [decimal](15, 2) NULL ,
	[xrjb] [decimal](15, 2) NULL ,
	[pjxs] [decimal](15, 2) NULL ,
	[jbf] [money] NULL ,
	[pjjbf] [money] NULL ,
	[glf] [money] NULL ,
	[pjglf] [money] NULL ,
	[zsf] [money] NULL ,
	[pjzsf] [money] NULL ,
	[xh] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dep_salary_zb] (
	[month] [char] (7) NOT NULL ,
	[bmmc] [char] (20) NOT NULL ,
	[zb] [char] (20) NOT NULL ,
	[yfhj] [decimal](20, 0) NULL ,
	[gz] [decimal](20, 0) NULL ,
	[ptjb] [decimal](20, 0) NULL ,
	[xrjb] [decimal](20, 0) NULL ,
	[pjxs] [decimal](20, 0) NULL ,
	[jbf] [decimal](20, 0) NULL ,
	[pjjbf] [decimal](20, 0) NULL ,
	[empcount] [int] NULL ,
	[pjgz] [decimal](20, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dep_year] (
	[month] [char] (7) NOT NULL ,
	[bm] [char] (30) NOT NULL ,
	[zb] [char] (30) NOT NULL ,
	[rs] [char] (10) NULL ,
	[rs_x] [int] NULL ,
	[flag] [char] (2) NOT NULL ,
	[flag_x] [char] (30) NULL ,
	[page] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[depart_fun] (
	[department] [varchar] (50) NOT NULL ,
	[func] [char] (3) NOT NULL ,
	[func_name] [varchar] (50) NULL ,
	[need_num] [int] NULL ,
	[have_num] [int] NULL ,
	[descr] [varchar] (80) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[department] (
	[bmbh] [int] NOT NULL ,
	[bmmc] [char] (40) NULL ,
	[fzr] [char] (8) NULL ,
	[rs] [int] NULL ,
	[hjsx] [decimal](20, 0) NULL ,
	[hjjbsx] [decimal](20, 0) NULL ,
	[bmzz] [char] (120) NULL ,
	[sjbm] [int] NULL ,
	[tbdz] [char] (50) NULL ,
	[bmh] [char] (9) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dictcomplace] (
	[self_code] [char] (3) NOT NULL ,
	[parent_code] [char] (3) NULL ,
	[self_name] [varchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dictfun] (
	[fcode] [char] (3) NOT NULL ,
	[fname] [varchar] (30) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dictgds] (
	[self_code] [char] (10) NOT NULL ,
	[parent_code] [char] (10) NOT NULL ,
	[gds_kind] [varchar] (30) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dictget] (
	[pcode] [char] (2) NOT NULL ,
	[pname] [char] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dictpay] (
	[pcode] [char] (2) NOT NULL ,
	[pname] [char] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dictrqpriority] (
	[prt_code] [char] (2) NOT NULL ,
	[prt_name] [char] (10) NOT NULL ,
	[prt_time] [smallint] NOT NULL ,
	[pri_time_unit] [char] (2) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dictunit] (
	[unit_code] [char] (2) NOT NULL ,
	[unit_name] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[doorcase] (
	[boardid] [char] (4) NOT NULL ,
	[address] [char] (4) NOT NULL ,
	[controlname] [char] (16) NULL ,
	[d0name] [char] (20) NULL ,
	[d1name] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dooryskq] (
	[bh] [int] NOT NULL ,
	[kh] [char] (9) NOT NULL ,
	[xm] [char] (10) NULL ,
	[rq] [datetime] NOT NULL ,
	[sj] [datetime] NOT NULL ,
	[address] [char] (4) NOT NULL ,
	[bm] [char] (20) NULL ,
	[crmh] [char] (6) NOT NULL ,
	[crmmc] [char] (20) NULL ,
	[crmzt] [char] (4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[dooryskq1] (
	[bh] [int] NOT NULL ,
	[kh] [char] (9) NOT NULL ,
	[xm] [char] (10) NULL ,
	[rq] [datetime] NOT NULL ,
	[sj] [datetime] NOT NULL ,
	[address] [char] (4) NOT NULL ,
	[bm] [char] (20) NULL ,
	[crmh] [char] (6) NOT NULL ,
	[crmmc] [char] (20) NULL ,
	[crmzt] [char] (4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[duizao] (
	[tablename] [char] (30) NOT NULL ,
	[colname] [char] (30) NOT NULL ,
	[colval] [char] (40) NOT NULL ,
	[reval] [char] (30) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[edu_book] (
	[booknumber] [char] (10) NOT NULL ,
	[bookname] [char] (34) NULL ,
	[learntime] [money] NULL ,
	[outdep] [char] (14) NULL ,
	[outdate] [datetime] NULL ,
	[range] [char] (46) NULL ,
	[version] [char] (6) NULL ,
	[author] [char] (12) NULL ,
	[bz] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[edu_exp] (
	[edu_exp] [char] (50) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[edu_lesson] (
	[lessonbh] [char] (10) NOT NULL ,
	[lessonname] [char] (80) NULL ,
	[teacher] [char] (12) NULL ,
	[comedep] [char] (12) NULL ,
	[trainmode] [char] (8) NULL ,
	[cost] [money] NULL ,
	[startday] [datetime] NULL ,
	[endday] [datetime] NULL ,
	[traintime] [money] NULL ,
	[lessonaim1] [char] (46) NULL ,
	[lessonaim2] [char] (46) NULL ,
	[lessonaim3] [char] (46) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[edu_outrecord] (
	[lessonbh] [char] (10) NOT NULL ,
	[empbh] [int] NOT NULL ,
	[empname] [char] (12) NULL ,
	[result] [char] (12) NULL ,
	[quali] [char] (50) NULL ,
	[lessonname] [char] (80) NULL ,
	[jlh] [int] NULL ,
	[bmbh] [int] NULL ,
	[bmmc] [char] (40) NULL ,
	[jcrq] [datetime] NULL ,
	[ksrq] [datetime] NULL ,
	[jsrq] [datetime] NULL ,
	[sxks] [money] NULL ,
	[kclr] [char] (40) NULL ,
	[teacher] [char] (20) NULL ,
	[xlfs] [char] (20) NULL ,
	[bz] [char] (40) NULL ,
	[user1] [char] (40) NULL ,
	[user2] [char] (40) NULL ,
	[kh] [char] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[edu_result] (
	[result] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[edu_teacher] (
	[bh] [char] (10) NOT NULL ,
	[name] [char] (12) NULL ,
	[funct] [char] (16) NULL ,
	[term] [char] (10) NULL ,
	[workdep] [char] (28) NULL ,
	[phone] [char] (15) NULL ,
	[lesson1] [char] (34) NULL ,
	[lesson2] [char] (34) NULL ,
	[lesson3] [char] (34) NULL ,
	[lesson4] [char] (34) NULL ,
	[lesson5] [char] (34) NULL ,
	[lesson6] [char] (34) NULL ,
	[lesson7] [char] (34) NULL ,
	[lesson8] [char] (34) NULL ,
	[lesson9] [char] (34) NULL ,
	[lesson10] [char] (34) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[empMonthReport] (
	[genYear] [char] (4) NOT NULL ,
	[department] [varchar] (50) NOT NULL ,
	[subDepart] [varchar] (50) NOT NULL ,
	[post] [varchar] (50) NOT NULL ,
	[m01] [int] NULL ,
	[m02] [int] NULL ,
	[m03] [int] NULL ,
	[m04] [int] NULL ,
	[m05] [int] NULL ,
	[m06] [int] NULL ,
	[m07] [int] NULL ,
	[m08] [int] NULL ,
	[m09] [int] NULL ,
	[m10] [int] NULL ,
	[m11] [int] NULL ,
	[m12] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_age] (
	[bm] [char] (30) NOT NULL ,
	[zb] [char] (30) NOT NULL ,
	[rs] [char] (10) NULL ,
	[rs_x] [int] NULL ,
	[flag] [char] (2) NOT NULL ,
	[flag_x] [char] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_chuchai] (
	[rq] [datetime] NOT NULL ,
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NOT NULL ,
	[bm] [int] NULL ,
	[bmmc] [varchar] (20) NULL ,
	[cclx] [varchar] (39) NULL ,
	[xxsy] [varchar] (30) NULL ,
	[qssj] [datetime] NULL ,
	[jssj] [datetime] NULL ,
	[fy1] [smallmoney] NULL ,
	[fy2] [smallmoney] NULL ,
	[fy3] [smallmoney] NULL ,
	[bksj1] [datetime] NULL ,
	[bksj2] [datetime] NULL ,
	[bksj3] [datetime] NULL ,
	[bksj4] [datetime] NULL ,
	[bz] [varchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_chuchaihzb] (
	[cc_month] [char] (7) NOT NULL ,
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NULL ,
	[bmbh] [int] NULL ,
	[bmmc] [varchar] (20) NOT NULL ,
	[fy1] [smallmoney] NULL ,
	[fy2] [smallmoney] NULL ,
	[fy3] [smallmoney] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_cxjgl] (
	[bh] [bigint] NOT NULL ,
	[empname] [char] (12) NULL ,
	[month_id] [char] (7) NOT NULL ,
	[xxtime] [char] (6) NULL ,
	[pstime] [char] (6) NULL ,
	[yxjtime] [char] (6) NULL ,
	[cxjtime] [char] (6) NULL ,
	[xxtime1] [char] (6) NULL ,
	[pstime1] [char] (6) NULL ,
	[yxjtime1] [char] (6) NULL ,
	[xxtime2] [char] (6) NULL ,
	[pstime2] [char] (6) NULL ,
	[yxjtime2] [char] (6) NULL ,
	[cxjtime2] [char] (6) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_flp] (
	[flpmc] [char] (40) NOT NULL ,
	[flpdj] [money] NULL ,
	[bz] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_flp_rec] (
	[empbh] [decimal](20, 0) NOT NULL ,
	[empname] [char] (16) NULL ,
	[depbh] [decimal](20, 0) NULL ,
	[department] [char] (40) NULL ,
	[flpmc] [char] (40) NOT NULL ,
	[flpgg] [char] (40) NOT NULL ,
	[ffsl] [int] NULL ,
	[dj] [numeric](8, 2) NULL ,
	[hj] [numeric](8, 2) NULL ,
	[ffrq] [datetime] NOT NULL ,
	[jijie] [char] (4) NULL ,
	[bz] [char] (40) NULL ,
	[jlh] [int] NULL ,
	[kh] [char] (50) NULL ,
	[user1] [char] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_gxgz] (
	[zb] [char] (20) NULL ,
	[bb] [char] (20) NULL ,
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NULL ,
	[kh] [char] (50) NULL ,
	[gx] [char] (80) NULL ,
	[sx] [char] (80) NULL ,
	[user1] [char] (50) NULL ,
	[user2] [char] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_ht] (
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NOT NULL ,
	[xb] [char] (2) NULL ,
	[nl] [int] NULL ,
	[sfzh] [char] (20) NULL ,
	[dz] [char] (50) NULL ,
	[nx] [int] NULL ,
	[rq] [datetime] NULL ,
	[nr] [text] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_in_out] (
	[bm] [char] (30) NOT NULL ,
	[zb] [char] (30) NOT NULL ,
	[rs] [char] (10) NULL ,
	[rs_x] [int] NULL ,
	[flag] [char] (1) NOT NULL ,
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -