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

📄 hrdb.sql

📁 金华门禁系统数据库脚本,涵盖了门禁,售饭,人力资源管理等
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[flag_x] [char] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_inout] (
	[bh] [int] NOT NULL ,
	[rq] [datetime] NOT NULL ,
	[jlh] [int] NOT NULL ,
	[bm] [char] (40) NULL ,
	[in1] [datetime] NULL ,
	[out1] [datetime] NULL ,
	[in2] [datetime] NULL ,
	[out2] [datetime] NULL ,
	[in3] [datetime] NULL ,
	[out3] [datetime] NULL ,
	[in4] [datetime] NULL ,
	[out4] [datetime] NULL ,
	[in5] [datetime] NULL ,
	[out5] [datetime] NULL ,
	[in6] [datetime] NULL ,
	[out6] [datetime] NULL ,
	[xm] [char] (10) NULL ,
	[stauts] [char] (10) NULL ,
	[user1] [char] (40) NULL ,
	[user2] [char] (40) NULL ,
	[kh] [char] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_jg] (
	[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_jxd] (
	[bh] [int] NOT NULL ,
	[xh] [varchar] (20) NOT NULL ,
	[rq] [datetime] NULL ,
	[ctr_type] [varchar] (10) NULL ,
	[pzr1] [char] (10) NULL ,
	[pzr2] [char] (10) NULL ,
	[pzr3] [char] (10) NULL ,
	[pzr4] [char] (10) NULL ,
	[pzr5] [char] (10) NULL ,
	[pzr6] [char] (10) NULL ,
	[cbzxh] [varchar] (30) NULL ,
	[bm] [varchar] (30) NULL ,
	[cwqm] [varchar] (30) NULL ,
	[csort] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_kf] (
	[id] [int] NOT NULL ,
	[bh] [int] NOT NULL ,
	[xm] [varchar] (8) NULL ,
	[bdrq] [datetime] NULL ,
	[bm] [varchar] (40) NULL ,
	[gx] [varchar] (50) NULL ,
	[zw] [varchar] (30) NULL ,
	[jb] [varchar] (30) NULL ,
	[salary] [decimal](8, 2) NULL ,
	[bm1] [varchar] (40) NULL ,
	[gx1] [varchar] (50) NULL ,
	[jb1] [varchar] (30) NULL ,
	[zw1] [varchar] (30) NULL ,
	[salary1] [decimal](8, 2) NULL ,
	[sxrq] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_khbh] (
	[ickh] [int] NOT NULL ,
	[empbh] [int] NULL ,
	[bmmc] [char] (20) NULL ,
	[lb] [char] (4) NULL ,
	[bya] [char] (20) NULL ,
	[byb] [int] NULL ,
	[xm] [char] (12) NULL ,
	[hbh] [char] (10) NULL ,
	[code1] [char] (40) NULL ,
	[code2] [char] (40) NULL ,
	[code3] [char] (40) NULL ,
	[code4] [char] (40) NULL ,
	[code5] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_kkhj] (
	[empbh] [int] NOT NULL ,
	[empname] [char] (10) NULL ,
	[kh] [char] (50) NULL ,
	[kkhj] [money] NULL ,
	[bz] [char] (120) NULL ,
	[user1] [char] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_kkjl] (
	[xh] [int] NOT NULL ,
	[empbh] [decimal](20, 0) NOT NULL ,
	[empname] [char] (12) NULL ,
	[kksj] [datetime] NOT NULL ,
	[kkbh] [char] (10) NULL ,
	[kkje] [money] NULL ,
	[kknr] [char] (50) NOT NULL ,
	[kkyy] [char] (50) NULL ,
	[kh] [char] (50) NULL ,
	[ljds] [money] NULL ,
	[beizhu] [char] (60) NULL ,
	[user1] [char] (60) NULL ,
	[bm] [char] (40) NULL ,
	[bmbh] [int] NULL ,
	[bmdm] [char] (50) NULL ,
	[zw] [char] (30) NULL ,
	[cby1] [char] (10) NULL ,
	[cby2] [char] (20) NULL ,
	[cby3] [char] (30) NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[emp_lfgl] (
	[xh] [int] NOT NULL ,
	[xm] [char] (10) NOT NULL ,
	[bm] [char] (20) NOT NULL ,
	[zw] [char] (20) NULL ,
	[sq_date] [datetime] NULL ,
	[lfr] [char] (10) NULL ,
	[gx] [char] (20) NULL ,
	[zs_flag] [char] (1) NULL ,
	[zsts] [decimal](5, 1) NULL ,
	[lc_date] [datetime] NULL ,
	[lf_indate] [datetime] NULL ,
	[lf_outdate] [datetime] NULL ,
	[qm1] [char] (10) NULL ,
	[qm2] [char] (10) NULL ,
	[bh] [int] NULL ,
	[by1] [char] (16) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_lzbl] (
	[lb] [char] (50) NOT NULL ,
	[rs] [int] NULL ,
	[bl] [char] (8) NULL ,
	[rshj] [int] NULL 
) ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[emp_pxxm] (
	[xmbh] [int] NOT NULL ,
	[xmmc] [char] (100) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_report] (
	[rq] [datetime] NOT NULL ,
	[dh] [char] (21) NOT NULL ,
	[bm1] [char] (21) NOT NULL ,
	[bm2] [char] (21) NOT NULL ,
	[hj] [int] NOT NULL ,
	[m] [int] NOT NULL ,
	[w] [int] NOT NULL ,
	[n1] [int] NOT NULL ,
	[n2] [int] NOT NULL ,
	[n3] [int] NOT NULL ,
	[n4] [int] NOT NULL ,
	[n5] [int] NOT NULL ,
	[a1] [int] NOT NULL ,
	[a2] [int] NOT NULL ,
	[a3] [int] NOT NULL ,
	[a4] [int] NOT NULL ,
	[z1] [int] NOT NULL ,
	[z2] [int] NOT NULL ,
	[z3] [int] NOT NULL ,
	[z4] [int] NOT NULL ,
	[z5] [int] NOT NULL ,
	[avg1] [numeric](10, 1) NULL ,
	[avg2] [numeric](10, 1) NULL ,
	[avg3] [numeric](10, 1) NULL ,
	[avg4] [numeric](10, 1) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_salary] (
	[no_month] [char] (7) NOT NULL ,
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NULL ,
	[bmmc] [char] (40) NULL ,
	[gzsj] [char] (6) NULL ,
	[qqsj] [char] (6) NULL ,
	[sxgz] [numeric](8, 2) NULL ,
	[gx] [numeric](8, 2) NULL ,
	[jx] [numeric](8, 2) NULL ,
	[lz] [numeric](8, 2) NULL ,
	[xlgz] [numeric](8, 2) NULL ,
	[jb] [numeric](8, 2) NULL ,
	[ycf] [numeric](8, 2) NULL ,
	[bt] [numeric](8, 2) NULL ,
	[qwwbt] [numeric](8, 2) NULL ,
	[jl] [numeric](8, 2) NULL ,
	[qt2] [numeric](8, 2) NULL ,
	[yfgz] [numeric](8, 2) NULL ,
	[ylj] [numeric](8, 2) NULL ,
	[gjj] [numeric](8, 2) NULL ,
	[bsj] [numeric](8, 2) NULL ,
	[dk] [numeric](8, 2) NULL ,
	[sds] [numeric](8, 2) NULL ,
	[fk] [numeric](8, 2) NULL ,
	[fzsd] [numeric](8, 2) NULL ,
	[qtyk] [numeric](8, 2) NULL ,
	[kkhj] [numeric](8, 2) NULL ,
	[sfgz] [numeric](8, 2) NULL ,
	[qm] [numeric](8, 2) NULL ,
	[qxbz] [char] (1) NULL ,
	[user1] [numeric](8, 2) NULL ,
	[user2] [numeric](8, 2) NULL ,
	[user3] [numeric](8, 2) NULL ,
	[user4] [numeric](8, 2) NULL ,
	[user5] [numeric](8, 2) NULL ,
	[user6] [numeric](8, 2) NULL ,
	[user7] [numeric](8, 2) NULL ,
	[user8] [numeric](8, 2) NULL ,
	[user9] [numeric](8, 2) NULL ,
	[user10] [numeric](8, 2) NULL ,
	[user11] [numeric](8, 2) NULL ,
	[user12] [numeric](8, 2) NULL ,
	[user13] [numeric](8, 2) NULL ,
	[user14] [numeric](8, 2) NULL ,
	[user15] [numeric](8, 2) NULL ,
	[user16] [numeric](10, 4) NULL ,
	[user17] [numeric](8, 2) NULL ,
	[user18] [numeric](8, 2) NULL ,
	[user19] [numeric](8, 2) NULL ,
	[user20] [numeric](8, 2) NULL ,
	[user21] [numeric](8, 2) NULL ,
	[user22] [numeric](8, 2) NULL ,
	[user23] [numeric](8, 2) NULL ,
	[user24] [numeric](8, 2) NULL ,
	[user25] [numeric](8, 2) NULL ,
	[user26] [numeric](8, 2) NULL ,
	[user27] [numeric](8, 2) NULL ,
	[user28] [numeric](8, 2) NULL ,
	[user29] [numeric](8, 2) NULL ,
	[user30] [numeric](8, 2) NULL ,
	[cuser1] [char] (20) NULL ,
	[cuser2] [char] (20) NULL ,
	[cuser3] [char] (20) NULL ,
	[cuser4] [char] (20) NULL ,
	[cuser5] [char] (20) NULL ,
	[cuser6] [char] (20) NULL ,
	[cuser7] [char] (20) NULL ,
	[cuser8] [char] (20) NULL ,
	[cuser9] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_timetable] (
	[bh] [int] NOT NULL ,
	[bmbh] [int] NOT NULL ,
	[bzbh] [int] NULL ,
	[qsrq] [datetime] NULL ,
	[dbgl] [char] (60) NULL ,
	[d01] [char] (2) NULL ,
	[d02] [char] (2) NULL ,
	[d03] [char] (2) NULL ,
	[d04] [char] (2) NULL ,
	[d05] [char] (2) NULL ,
	[d06] [char] (2) NULL ,
	[d07] [char] (2) NULL ,
	[d08] [char] (2) NULL ,
	[d09] [char] (2) NULL ,
	[d10] [char] (2) NULL ,
	[d11] [char] (2) NULL ,
	[d12] [char] (2) NULL ,
	[d13] [char] (2) NULL ,
	[d14] [char] (2) NULL ,
	[d15] [char] (2) NULL ,
	[d16] [char] (2) NULL ,
	[d17] [char] (2) NULL ,
	[d18] [char] (2) NULL ,
	[d19] [char] (2) NULL ,
	[d20] [char] (2) NULL ,
	[d21] [char] (2) NULL ,
	[d22] [char] (2) NULL ,
	[d23] [char] (2) NULL ,
	[d24] [char] (2) NULL ,
	[d25] [char] (2) NULL ,
	[d26] [char] (2) NULL ,
	[d27] [char] (2) NULL ,
	[d28] [char] (2) NULL ,
	[d29] [char] (2) NULL ,
	[d30] [char] (2) NULL ,
	[d31] [char] (2) NULL ,
	[xm] [char] (10) NULL ,
	[bzmc] [char] (10) NULL ,
	[bm] [char] (40) NULL ,
	[bmdm] [char] (50) NULL ,
	[zw] [char] (30) NULL ,
	[cby1] [char] (10) NULL ,
	[cby2] [char] (20) NULL ,
	[cby3] [char] (30) NULL ,
	[month] [char] (7) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_tx] (
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NULL ,
	[bmbh] [int] NULL ,
	[bmmc] [varchar] (20) NULL ,
	[rq1] [datetime] NOT NULL ,
	[rq2] [datetime] NOT NULL ,
	[txlx] [char] (10) NULL ,
	[txfs] [char] (10) NULL ,
	[txsj] [datetime] NULL ,
	[bz] [varchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_xb] (
	[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_xjbb] (
	[bh] [int] NOT NULL ,
	[xm] [varchar] (8) NULL ,
	[xb] [char] (2) NULL ,
	[bm] [varchar] (40) NULL ,
	[jb] [varchar] (30) NULL ,
	[monthxj] [decimal](10, 2) NULL ,
	[sumxj] [decimal](10, 2) NULL ,
	[yearxj] [decimal](10, 2) NULL ,
	[jsdate] [datetime] NULL ,
	[dayxj] [decimal](10, 2) NULL ,
	[by1] [varchar] (40) NULL ,
	[modxj] [decimal](10, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_xjgl] (
	[xh] [int] NOT NULL ,
	[gzns] [int] NOT NULL ,
	[yxts] [decimal](8, 2) NOT NULL ,
	[by1] [char] (20) NULL ,
	[by2] [varchar] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_xl] (
	[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_year_change] (
	[bh] [int] NOT NULL ,
	[empname] [char] (12) NULL ,
	[year] [char] (10) NOT NULL ,
	[zj] [decimal](10, 2) NULL ,
	[jj] [decimal](10, 2) NULL ,
	[rest_day] [decimal](10, 2) NULL ,
	[user1] [decimal](10, 2) NULL ,
	[user2] [char] (10) NULL ,
	[beizhu] [char] (20) NULL ,
	[hj] [decimal](10, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[emp_ylzlist] (
	[bh] [int] NOT NULL ,
	[xm] [char] (12) NULL ,
	[bmbh] [int] NULL ,
	[bmmc] [char] (40) NULL ,
	[rcrq] [datetime] NULL ,
	[zw] [char] (50) NULL ,
	[lzrq] [datetime] NULL ,
	[lzyy] [char] (50) NULL ,
	[qpr] [char] (12) NULL ,
	[zxqk] [char] (1) NULL ,
	[beizhu] [char] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[empdeptzw] (
	[bmbh] [int] NULL ,
	[rqfw] [char] (21) NULL ,
	[rq] [smalldatetime] NOT NULL ,
	[bmmc] [varchar] (20) NOT NULL ,
	[subbm] [varchar] (20) NOT NULL ,
	[z1] [int] NULL ,
	[z2] [int] NULL ,
	[z3] [int] NULL ,
	[z4] [int] NULL ,
	[z5] [int] NULL ,
	[z6] [int] NULL ,
	[z7] [int] NULL ,
	[z8] [int] NULL ,
	[z9] [int] NULL ,
	[sumnum] [int] NULL ,
	[plannum] [int] NULL ,
	[needin] [int] NULL ,
	[memo] [varchar] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[employee] (
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NULL ,
	[bmbh] [int] NULL ,
	[xb] [char] (2) NULL ,
	[csrq] [datetime] NULL ,
	[zw] [char] (30) NULL ,
	[dh] [char] (14) NULL ,
	[stdh] [char] (14) NULL ,
	[dz] [char] (100) NULL ,
	[sx] [numeric](8, 2) NULL ,
	[jbsx] [numeric](8, 2) NULL ,
	[bc] [char] (2) NULL ,
	[xxr] [char] (7) NULL ,
	[bdr] [datetime] NULL ,
	[bm] [char] (40) NULL ,
	[byyx] [char] (50) NULL ,
	[zy] [char] (16) NULL ,
	[xl] [char] (16) NULL ,
	[bysj] [datetime] NULL ,
	[zzmm] [char] (20) NULL ,
	[jg] [char] (8) NULL ,
	[hkszd] [char] (50) NULL ,
	[dw] [char] (50) NULL ,
	[mz] [char] (50) NULL ,
	[hf] [char] (4) NULL ,
	[zc] [char] (30) NULL ,
	[gw] [char] (30) NULL ,
	[lb] [char] (30) NULL ,
	[jb] [char] (30) NULL ,
	[jn] [char] (30) NULL ,
	[htqdr] [datetime] NULL ,
	[htzzr] [datetime] NULL ,
	[sfzgg] [char] (30) NULL ,
	[ddr] [datetime] NULL ,
	[ybm] [char] (50) NULL ,
	[lzr] [datetime] NULL ,
	[lxr] [char] (50) NULL ,
	[bc2] [char] (10) NULL ,
	[gzsj] [datetime] NULL ,
	[gj] [char] (50) NULL ,
	[lianlin] [numeric](8, 2) NULL ,
	[csdd] [char] (50) NULL ,
	[biemin] [char] (50) NULL ,
	[sengao] [numeric](8, 2) NULL ,
	[tizong] [numeric](8, 2) NULL ,
	[jkzk] [char] (50) NULL ,
	[ywdz] [char] (50) NULL ,
	[gsdh] [numeric](15, 0) NULL ,
	[bp] [numeric](15, 0) NULL ,
	[youbian] [numeric](7, 0) NULL ,
	[pouxm] [char] (50) NULL ,
	[boy] [char] (50) NULL ,
	[girl] [char] (50) NULL ,
	[zxhzsr] [datetime] NULL ,
	[photo] [char] (50) NULL ,
	[danszd] [char] (400) NULL ,
	[xingqu] [char] (50) NULL ,
	[yuyan] [char] (50) NULL ,
	[dianlao] [char] (50) NULL ,
	[jianzhao] [char] (400) NULL ,
	[tbjl] [char] (50) NULL ,
	[xsfzh] [char] (50) NULL ,
	[sfzh] [char] (50) NULL ,
	[duser1] [datetime] NULL ,
	[duser2] [datetime] NULL ,
	[duser3] [datetime] NULL ,
	[duser4] [datetime] NULL ,
	[duser5] [datetime] NULL ,
	[duser6] [datetime] NULL ,
	[cuser1] [char] (50) NULL ,
	[cuser2] [char] (50) NULL ,
	[cuser3] [char] (50) NULL ,
	[cuser4] [char] (50) NULL ,
	[cuser5] [char] (50) NULL ,
	[cuser6] [char] (50) NULL ,
	[ruser1] [money] NULL ,
	[ruser2] [money] NULL ,
12345

⌨️ 快捷键说明

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