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

📄 hrdb.sql

📁 金华门禁系统数据库脚本,涵盖了门禁,售饭,人力资源管理等
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[ruser3] [money] NULL ,
	[ruser4] [money] NULL ,
	[ruser5] [money] NULL ,
	[ruser6] [money] NULL ,
	[ruser7] [money] NULL ,
	[ruser8] [money] NULL ,
	[ruser9] [money] NULL ,
	[ruser10] [money] NULL ,
	[ruser11] [money] NULL ,
	[ruser12] [money] NULL ,
	[ruser13] [money] NULL ,
	[ruser14] [money] NULL ,
	[ruser15] [money] NULL ,
	[ruser16] [money] NULL ,
	[ruser17] [money] NULL ,
	[ruser18] [money] NULL ,
	[ruser19] [money] NULL ,
	[ruser20] [money] NULL ,
	[ruser21] [money] NULL ,
	[ruser22] [money] NULL ,
	[ruser23] [money] NULL ,
	[ruser24] [money] NULL ,
	[ruser25] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[employee_lz] (
	[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] [numeric](19, 4) NULL ,
	[ruser2] [numeric](19, 4) NULL ,
	[ruser3] [numeric](19, 4) NULL ,
	[ruser4] [numeric](19, 4) NULL ,
	[ruser5] [numeric](19, 4) NULL ,
	[ruser6] [numeric](19, 4) NULL ,
	[ruser7] [numeric](19, 4) NULL ,
	[ruser8] [numeric](19, 4) NULL ,
	[ruser9] [numeric](19, 4) NULL ,
	[ruser10] [numeric](19, 4) NULL ,
	[ruser11] [numeric](19, 4) NULL ,
	[ruser12] [numeric](19, 4) NULL ,
	[ruser13] [numeric](19, 4) NULL ,
	[ruser14] [numeric](19, 4) NULL ,
	[ruser15] [numeric](19, 4) NULL ,
	[ruser16] [numeric](19, 4) NULL ,
	[ruser17] [numeric](19, 4) NULL ,
	[ruser18] [numeric](19, 4) NULL ,
	[ruser19] [numeric](19, 4) NULL ,
	[ruser20] [numeric](19, 4) NULL ,
	[ruser21] [numeric](19, 4) NULL ,
	[ruser22] [numeric](19, 4) NULL ,
	[ruser23] [numeric](19, 4) NULL ,
	[ruser24] [numeric](19, 4) NULL ,
	[ruser25] [numeric](19, 4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[empweekworks] (
	[week] [varchar] (10) NOT NULL ,
	[begin_date] [datetime] NOT NULL ,
	[end_date] [datetime] NOT NULL ,
	[bm] [varchar] (10) NOT NULL ,
	[bmmc] [varchar] (30) NULL ,
	[bmdm] [varchar] (10) NULL ,
	[bmnum] [int] NULL ,
	[n1] [int] NULL ,
	[n2] [int] NULL ,
	[n3] [int] NULL ,
	[n4] [int] NULL ,
	[n5] [int] NULL ,
	[n6] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[fk_jl] (
	[xh] [int] IDENTITY (1, 1) NOT NULL ,
	[rq] [datetime] NOT NULL ,
	[bh] [int] NULL ,
	[xm] [char] (10) NULL ,
	[bmbh] [int] NULL ,
	[bmdm] [char] (30) NULL ,
	[bmmc] [char] (40) NULL ,
	[old_byb] [int] NULL ,
	[old_ickh] [int] NULL ,
	[new_byb] [int] NULL ,
	[new_ickh] [int] NULL ,
	[lx] [char] (30) NULL ,
	[user1] [char] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[fk_tj] (
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NOT NULL ,
	[bmbh] [int] NOT NULL ,
	[bmdm] [char] (30) NULL ,
	[bmmc] [char] (40) NULL ,
	[lx1] [int] NULL ,
	[lx2] [int] NULL ,
	[lx3] [int] NULL ,
	[lx4] [int] NULL ,
	[lx5] [int] NULL ,
	[lx6] [int] NULL ,
	[lx7] [int] NULL ,
	[lx8] [int] NULL ,
	[lx9] [int] NULL ,
	[lx10] [int] NULL ,
	[total] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[fk_type] (
	[bh] [char] (10) NOT NULL ,
	[lx] [char] (30) NOT NULL ,
	[bz] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[flp_da] (
	[mc] [char] (20) NOT NULL ,
	[xh] [char] (40) NOT NULL ,
	[dj] [money] NOT NULL ,
	[dw] [char] (10) NULL ,
	[bz] [char] (40) NULL ,
	[zksl] [int] NULL ,
	[cksl] [int] NULL ,
	[kc] [int] NULL ,
	[bya] [int] NULL ,
	[byb] [char] (10) NULL ,
	[bh] [char] (15) NOT NULL ,
	[jbyl] [int] NULL ,
	[byc] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[flp_gg] (
	[flpgg] [char] (40) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[flp_hzb] (
	[id] [int] NOT NULL ,
	[wpbh] [char] (20) NULL ,
	[mc] [char] (30) NULL ,
	[xh] [char] (40) NULL ,
	[dw] [char] (6) NULL ,
	[sl] [int] NULL ,
	[hj] [money] NULL ,
	[slbz] [real] NULL ,
	[jebz] [real] NULL ,
	[bmsl] [int] NULL ,
	[bh] [int] NULL ,
	[xm] [char] (12) NULL ,
	[bm] [char] (16) NULL ,
	[lb] [char] (1) NOT NULL ,
	[bya] [char] (20) NULL ,
	[byb] [char] (10) NULL ,
	[tjdate] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[flp_in] (
	[id] [int] NOT NULL ,
	[rq] [datetime] NOT NULL ,
	[mc] [char] (20) NOT NULL ,
	[xh] [char] (40) NOT NULL ,
	[dj] [money] NOT NULL ,
	[sl] [int] NOT NULL ,
	[hj] [money] NOT NULL ,
	[zksllj] [int] NOT NULL ,
	[bh] [int] NULL ,
	[xm] [char] (20) NOT NULL ,
	[bm] [char] (20) NULL ,
	[dw] [char] (10) NULL ,
	[wpbh] [char] (20) NOT NULL ,
	[lbs] [int] NULL ,
	[xzsl] [int] NULL ,
	[xzr_id] [int] NULL ,
	[xzr_name] [char] (12) NULL ,
	[xz_date] [datetime] NULL ,
	[bz] [char] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[flp_out] (
	[id] [int] NOT NULL ,
	[rq] [datetime] NOT NULL ,
	[mc] [char] (20) NOT NULL ,
	[xh] [char] (40) NOT NULL ,
	[dj] [money] NOT NULL ,
	[sl] [int] NOT NULL ,
	[hj] [money] NOT NULL ,
	[zksllj] [int] NOT NULL ,
	[bh] [int] NULL ,
	[xm] [char] (20) NOT NULL ,
	[bm] [char] (20) NULL ,
	[dw] [char] (10) NULL ,
	[wpbh] [char] (20) NOT NULL ,
	[lb] [char] (10) NULL ,
	[lbs] [int] NULL ,
	[djr] [char] (12) NULL ,
	[bya] [char] (12) NULL ,
	[byb] [int] NULL ,
	[bz] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[gertgoods] (
	[get_no] [char] (12) NOT NULL ,
	[gds_no] [char] (12) NOT NULL ,
	[sub_no] [char] (12) NULL ,
	[gds_name] [varchar] (50) NOT NULL ,
	[gds_unit] [char] (2) NULL ,
	[gds_num] [decimal](10, 4) NOT NULL ,
	[gds_price] [decimal](12, 4) NOT NULL ,
	[bk1] [char] (10) NULL ,
	[bk2] [char] (10) NULL ,
	[bk3] [int] NULL ,
	[bk4] [decimal](10, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[getpaper] (
	[get_no] [char] (12) NOT NULL ,
	[sub_no] [char] (12) NOT NULL ,
	[get_date] [smalldatetime] NOT NULL ,
	[get_employee] [char] (10) NOT NULL ,
	[send_person] [char] (10) NULL ,
	[status] [char] (2) NULL ,
	[bk2] [decimal](10, 4) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[goods] (
	[gds_no] [char] (10) NOT NULL ,
	[gds_name] [varchar] (50) NOT NULL ,
	[gds_unit] [char] (2) NULL ,
	[gds_mode] [char] (20) NULL ,
	[gds_kind] [char] (3) NOT NULL ,
	[memo] [varchar] (40) NULL ,
	[bk1] [decimal](10, 4) NULL ,
	[bk2] [char] (10) NULL ,
	[bk3] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[grjjb] (
	[dd_no] [char] (20) NOT NULL ,
	[rq] [datetime] NOT NULL ,
	[empbh] [int] NOT NULL ,
	[empname] [char] (12) NULL ,
	[bmbh] [int] NULL ,
	[bmmc] [char] (40) NULL ,
	[dj1] [numeric](11, 6) NULL ,
	[sl1] [int] NULL ,
	[dj2] [numeric](11, 6) NULL ,
	[sl2] [int] NULL ,
	[dj3] [numeric](11, 6) NULL ,
	[sl3] [int] NULL ,
	[dj4] [decimal](11, 6) NULL ,
	[sl4] [int] NULL ,
	[dj5] [decimal](11, 6) NULL ,
	[sl5] [int] NULL ,
	[dj6] [decimal](11, 6) NULL ,
	[sl6] [int] NULL ,
	[dj7] [decimal](11, 6) NULL ,
	[sl7] [int] NULL ,
	[dj8] [decimal](11, 6) NULL ,
	[sl8] [int] NULL ,
	[dj9] [decimal](11, 6) NULL ,
	[sl9] [int] NULL ,
	[dj10] [decimal](11, 6) NULL ,
	[sl10] [int] NULL ,
	[dj11] [decimal](11, 6) NULL ,
	[sl11] [int] NULL ,
	[dj12] [decimal](11, 6) NULL ,
	[sl12] [int] NULL ,
	[dj13] [decimal](11, 6) NULL ,
	[sl13] [int] NULL ,
	[dj14] [decimal](11, 6) NULL ,
	[sl14] [int] NULL ,
	[dj15] [decimal](11, 6) NULL ,
	[sl15] [int] NULL ,
	[dj16] [decimal](11, 6) NULL ,
	[sl16] [int] NULL ,
	[dj17] [decimal](11, 6) NULL ,
	[sl17] [int] NULL ,
	[dj18] [decimal](11, 6) NULL ,
	[sl18] [int] NULL ,
	[dj19] [decimal](11, 6) NULL ,
	[sl19] [int] NULL ,
	[dj20] [decimal](11, 6) NULL ,
	[sl20] [int] NULL ,
	[dj21] [decimal](11, 6) NULL ,
	[sl21] [int] NULL ,
	[dj22] [decimal](11, 6) NULL ,
	[sl22] [int] NULL ,
	[dj23] [decimal](11, 6) NULL ,
	[sl23] [int] NULL ,
	[dj24] [decimal](11, 6) NULL ,
	[sl24] [int] NULL ,
	[dj25] [decimal](11, 6) NULL ,
	[sl25] [int] NULL ,
	[dj26] [decimal](11, 6) NULL ,
	[sl26] [int] NULL ,
	[dj27] [decimal](11, 6) NULL ,
	[sl27] [int] NULL ,
	[dj28] [decimal](11, 6) NULL ,
	[sl28] [int] NULL ,
	[dj29] [decimal](11, 6) NULL ,
	[sl29] [int] NULL ,
	[dj30] [decimal](11, 6) NULL ,
	[sl30] [int] NULL ,
	[dj31] [decimal](11, 6) NULL ,
	[sl31] [int] NULL ,
	[dj32] [decimal](11, 6) NULL ,
	[sl32] [int] NULL ,
	[dj33] [decimal](11, 6) NULL ,
	[sl33] [int] NULL ,
	[dj34] [decimal](11, 6) NULL ,
	[sl34] [int] NULL ,
	[dj35] [decimal](11, 6) NULL ,
	[sl35] [int] NULL ,
	[dj36] [decimal](11, 6) NULL ,
	[sl36] [int] NULL ,
	[dj37] [decimal](11, 6) NULL ,
	[sl37] [int] NULL ,
	[dj38] [decimal](11, 6) NULL ,
	[sl38] [int] NULL ,
	[dj39] [decimal](11, 6) NULL ,
	[sl39] [int] NULL ,
	[dj40] [decimal](11, 6) NULL ,
	[sl40] [int] NULL ,
	[dj41] [decimal](11, 6) NULL ,
	[sl41] [int] NULL ,
	[dj42] [decimal](11, 6) NULL ,
	[sl42] [int] NULL ,
	[dj43] [decimal](11, 6) NULL ,
	[sl43] [int] NULL ,
	[dj44] [decimal](11, 6) NULL ,
	[sl44] [int] NULL ,
	[dj45] [decimal](11, 6) NULL ,
	[sl45] [int] NULL ,
	[dj46] [decimal](11, 6) NULL ,
	[sl46] [int] NULL ,
	[dj47] [decimal](11, 6) NULL ,
	[sl47] [int] NULL ,
	[dj48] [decimal](11, 6) NULL ,
	[sl48] [int] NULL ,
	[dj49] [decimal](11, 6) NULL ,
	[sl49] [int] NULL ,
	[dj50] [decimal](11, 6) NULL ,
	[sl50] [int] NULL ,
	[dj51] [decimal](11, 6) NULL ,
	[sl51] [int] NULL ,
	[dj52] [decimal](11, 6) NULL ,
	[sl52] [int] NULL ,
	[dj53] [decimal](11, 6) NULL ,
	[sl53] [int] NULL ,
	[dj54] [decimal](11, 6) NULL ,
	[sl54] [int] NULL ,
	[dj55] [decimal](11, 6) NULL ,
	[sl55] [int] NULL ,
	[dj56] [decimal](11, 6) NULL ,
	[sl56] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[group_timetable] (
	[bmbh] [int] NOT NULL ,
	[bzmc] [char] (10) NOT NULL ,
	[kqbm] [char] (8) NOT NULL ,
	[bc] [char] (2) NOT NULL ,
	[bzbh] [int] NULL ,
	[YXJ] [char] (2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[gztzb] (
	[tzrq] [datetime] NOT NULL ,
	[sxrq] [datetime] NOT NULL ,
	[bmbh] [int] NOT NULL ,
	[bmmc] [char] (30) NOT NULL ,
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NOT NULL ,
	[gzxm] [char] (20) NOT NULL ,
	[old_je] [money] NULL ,
	[new_je] [money] NULL ,
	[reason] [char] (40) NULL ,
	[sjzg] [char] (10) NULL ,
	[operator] [char] (10) NULL ,
	[user1] [char] (40) NULL ,
	[user2] [char] (40) NULL ,
	[user3] [char] (40) NULL ,
	[xh] [int] NULL ,
	[zw] [char] (30) NULL ,
	[bdr] [datetime] NULL ,
	[tzje] [money] NULL ,
	[bmdm] [char] (50) NULL ,
	[cby1] [char] (10) NULL ,
	[cby2] [char] (20) NULL ,
	[cby3] [char] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hbaoxian] (
	[bh] [decimal](20, 0) NOT NULL ,
	[jlh] [decimal](20, 0) NOT NULL ,
	[tbf] [char] (10) NULL ,
	[bxxm] [char] (20) NULL ,
	[bxrq] [datetime] NULL ,
	[tbfs] [decimal](20, 0) NULL ,
	[bxdh] [decimal](20, 0) NULL ,
	[tbje] [numeric](20, 2) NULL ,
	[ybf] [numeric](20, 2) NULL ,
	[bxgs] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hguoshi] (
	[bh] [int] NOT NULL ,
	[jlh] [int] NOT NULL ,
	[rq] [datetime] NULL ,
	[sjsm] [char] (240) NULL ,
	[sjzg] [char] (8) NULL ,
	[bryj] [char] (240) NULL ,
	[cljg] [char] (40) NULL ,
	[pzr] [char] (8) NULL ,
	[jc] [char] (4) NULL ,
	[xm] [char] (12) NULL ,
	[bm] [char] (40) NULL ,
	[by1] [char] (50) NULL ,
	[by2] [char] (50) NULL ,
	[kh] [char] (50) NULL ,
	[by3] [char] (1) NULL ,
	[xh] [int] 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].[hjianli] (
12345

⌨️ 快捷键说明

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