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

📄 hrdb.sql

📁 金华门禁系统数据库脚本,涵盖了门禁,售饭,人力资源管理等
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[bh] [int] NOT NULL ,
	[rq1] [datetime] NULL ,
	[rq2] [datetime] NULL ,
	[char1] [char] (50) NULL ,
	[char2] [char] (50) NULL ,
	[num1] [decimal](20, 0) NULL ,
	[num2] [decimal](20, 0) NULL ,
	[char3] [char] (50) NULL ,
	[jlh] [int] NOT NULL ,
	[zmr] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hlipei] (
	[bh] [decimal](20, 0) NOT NULL ,
	[jlh] [decimal](20, 0) NOT NULL ,
	[bxdh] [decimal](20, 0) NULL ,
	[bxxm] [char] (20) NULL ,
	[sqrq] [datetime] NULL ,
	[sqje] [numeric](20, 2) NULL ,
	[lprq] [datetime] NULL ,
	[sjje] [numeric](20, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hpxjl] (
	[bh] [int] NOT NULL ,
	[jlh] [int] NOT NULL ,
	[xmbh] [int] NULL ,
	[ksrq] [datetime] NULL ,
	[jcrq] [datetime] NULL ,
	[tgf] [char] (4) NULL ,
	[cj] [char] (10) NULL ,
	[bxsj] [datetime] NULL ,
	[sm] [char] (60) NULL ,
	[pxxx] [char] (60) NULL ,
	[pxdz] [char] (60) NULL ,
	[pxqx] [char] (20) NULL ,
	[zs] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hpxsq] (
	[sqbh] [decimal](20, 0) NOT NULL ,
	[sqrqy] [datetime] NULL ,
	[sqrqz] [datetime] NULL ,
	[skdd] [char] (30) NULL ,
	[lxdh] [char] (15) NULL ,
	[xmbh] [int] NULL ,
	[pxfy] [numeric](20, 2) NULL ,
	[qtfy] [numeric](20, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hpxxm] (
	[xmbh] [int] NOT NULL ,
	[xmmc] [char] (40) NULL ,
	[dsxm] [char] (8) NULL ,
	[pxmd] [char] (240) NULL ,
	[pxdx] [char] (240) NULL ,
	[kcgy] [char] (240) NULL ,
	[txap] [char] (120) NULL ,
	[kss] [decimal](20, 0) NULL ,
	[xmfl] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hr_card] (
	[rid] [varchar] (50) NOT NULL ,
	[rsyntax] [image] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[hshgx] (
	[bh] [int] NOT NULL ,
	[jlh] [int] NOT NULL ,
	[xm] [char] (8) NULL ,
	[gx] [char] (40) NULL ,
	[xb] [char] (2) NULL ,
	[csrq] [datetime] NULL ,
	[gzdw] [char] (40) NULL ,
	[zw] [char] (40) NULL ,
	[lxdz] [char] (40) NULL ,
	[lxdh] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[htjjl] (
	[bh] [int] NOT NULL ,
	[jlh] [int] NOT NULL ,
	[rq] [datetime] NULL ,
	[yy] [char] (40) NULL ,
	[jgsm] [char] (240) NULL ,
	[jnr] [char] (8) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hxueli] (
	[bh] [int] NOT NULL ,
	[rq1] [datetime] NULL ,
	[rq2] [datetime] NULL ,
	[char1] [char] (50) NULL ,
	[jlh] [int] NOT NULL ,
	[char2] [char] (20) NULL ,
	[char3] [char] (20) NULL ,
	[char4] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hygdtb] (
	[bh] [decimal](20, 0) NOT NULL ,
	[jlh] [decimal](20, 0) NOT NULL ,
	[shijian] [datetime] NULL ,
	[bhxm] [char] (10) NULL ,
	[bhq] [varchar] (80) NULL ,
	[bhh] [varchar] (80) NULL ,
	[dykq] [decimal](20, 0) NULL ,
	[sxrq] [datetime] NULL ,
	[empname] [char] (16) NULL ,
	[bdyy] [char] (50) NULL ,
	[bdlx] [char] (12) NULL ,
	[txr] [datetime] NULL ,
	[rcrq] [datetime] NULL ,
	[czy] [char] (16) NULL ,
	[bz] [char] (30) NULL ,
	[zt] [char] (2) NULL ,
	[dh] [varchar] (30) NULL ,
	[tbjl] [varchar] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hylfy] (
	[bh] [int] NOT NULL ,
	[jlh] [int] NOT NULL ,
	[rq] [datetime] NULL ,
	[xm] [char] (40) NULL ,
	[dj] [numeric](8, 2) NULL ,
	[sl] [int] NULL ,
	[je] [numeric](20, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hzhichen] (
	[bh] [int] NOT NULL ,
	[rq1] [datetime] NULL ,
	[char1] [char] (40) NULL ,
	[jlh] [int] NOT NULL ,
	[char2] [char] (20) NULL ,
	[char3] [char] (20) NULL ,
	[char4] [char] (50) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hzpjhjz] (
	[bh] [decimal](20, 0) NOT NULL ,
	[sqdh] [decimal](20, 0) NULL ,
	[zprs] [decimal](20, 0) NULL ,
	[sm] [char] (240) NULL ,
	[yprs] [decimal](20, 0) NULL ,
	[msrs] [decimal](20, 0) NULL ,
	[lyrs] [decimal](20, 0) NULL ,
	[dwrs] [decimal](20, 0) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hzpjlpg] (
	[jlh] [decimal](20, 0) NOT NULL ,
	[dyzpjh] [decimal](20, 0) NULL ,
	[zpdd] [char] (60) NULL ,
	[zpsjy] [datetime] NULL ,
	[zpshz] [datetime] NULL ,
	[zpqdff] [char] (120) NULL ,
	[zyxcnr] [char] (120) NULL ,
	[yprs] [decimal](20, 0) NULL ,
	[lydwrs] [decimal](20, 0) NULL ,
	[rjzpfy] [numeric](20, 2) NULL ,
	[dwrymycd] [char] (120) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hzpsq] (
	[bh] [decimal](20, 0) NOT NULL ,
	[bmbh] [int] NULL ,
	[zbh] [int] NULL ,
	[yqdwrq] [datetime] NULL ,
	[zprs] [decimal](20, 0) NULL ,
	[sy] [char] (10) NULL ,
	[bgryxm] [char] (8) NULL ,
	[zw] [char] (10) NULL ,
	[sxrq] [datetime] NULL ,
	[ly] [decimal](20, 0) NULL ,
	[xszwly] [char] (60) NULL ,
	[gzbgcx] [char] (30) NULL ,
	[xszzw] [char] (30) NULL ,
	[zzms] [char] (80) NULL ,
	[sqr] [char] (8) NULL ,
	[sqrqzrq] [datetime] NULL ,
	[hr] [char] (8) NULL ,
	[hqrq] [datetime] NULL ,
	[bmjl] [char] (8) NULL ,
	[bmjlqzrq] [datetime] NULL ,
	[zjl] [char] (8) NULL ,
	[zjlqzrq] [datetime] NULL ,
	[zt] [char] (10) NULL ,
	[xbyq] [char] (2) NULL ,
	[lnyq] [decimal](20, 0) NULL ,
	[whyq] [char] (20) NULL ,
	[jlyq] [char] (40) NULL ,
	[jsjnyq] [char] (60) NULL ,
	[qtyq] [char] (60) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[hzpzwsq] (
	[bdh] [decimal](20, 0) NOT NULL ,
	[sqzw] [char] (10) NULL ,
	[yqyx] [decimal](20, 0) NULL ,
	[ksbrq] [datetime] NULL ,
	[tzqx] [datetime] NULL ,
	[yprbh] [decimal](20, 0) NULL ,
	[wynl] [char] (20) NULL ,
	[jsjcz] [char] (20) NULL ,
	[js] [char] (20) NULL ,
	[jszz] [char] (15) NULL ,
	[msrq] [datetime] NULL ,
	[msg] [char] (8) NULL ,
	[pzr] [char] (8) NULL ,
	[jg] [char] (8) NULL ,
	[zw] [char] (10) NULL ,
	[jb] [char] (10) NULL ,
	[gz] [numeric](8, 2) NULL ,
	[bm] [char] (20) NULL ,
	[qtsm] [char] (120) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jb] (
	[bh] [int] NOT NULL ,
	[xm] [char] (8) NULL ,
	[qjlb] [char] (10) NOT NULL ,
	[qjrq] [datetime] NOT NULL ,
	[qjsj] [datetime] NOT NULL ,
	[qssj] [datetime] NULL ,
	[jssj] [datetime] NULL ,
	[xzbl] [decimal](20, 0) NULL ,
	[pzr] [char] (10) NULL ,
	[bm] [char] (40) NULL ,
	[bmbh] [int] NULL ,
	[bmdm] [char] (50) NULL ,
	[zw] [char] (30) NULL ,
	[xh] [int] NULL ,
	[cby1] [char] (10) NULL ,
	[cby2] [char] (20) NULL ,
	[cby3] [char] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jb_anomaly] (
	[bh] [int] NOT NULL ,
	[xm] [char] (8) NULL ,
	[bmbh] [int] NULL ,
	[bmdm] [char] (50) NULL ,
	[bm] [char] (40) NULL ,
	[zw] [char] (30) NULL ,
	[rq] [datetime] NOT NULL ,
	[bc] [char] (10) NULL ,
	[xh] [int] NOT NULL ,
	[jbsj1] [datetime] NULL ,
	[jbsj2] [datetime] NULL ,
	[jbsj3] [datetime] NULL ,
	[sksj1] [datetime] NULL ,
	[sksj2] [datetime] NULL ,
	[sksj3] [datetime] NULL ,
	[sksj4] [datetime] NULL ,
	[sksj5] [datetime] NULL ,
	[sksj6] [datetime] NULL ,
	[sksj7] [datetime] NULL ,
	[sksj8] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jb_xzlist] (
	[jb] [char] (30) NOT NULL ,
	[ruser1] [money] NULL ,
	[ruser2] [money] NULL ,
	[ruser3] [money] NULL ,
	[ruser4] [money] NULL ,
	[ruser5] [money] NULL ,
	[ruser6] [money] NULL ,
	[by1] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jbhzb] (
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NOT NULL ,
	[bmbh] [int] NOT NULL ,
	[bm] [char] (20) NULL ,
	[jb1_qs] [decimal](10, 2) NULL ,
	[jb1_sj] [decimal](10, 2) NULL ,
	[jb2_qs] [decimal](10, 2) NULL ,
	[jb2_sj] [decimal](10, 2) NULL ,
	[jb3_qs] [decimal](10, 2) NULL ,
	[jb3_sj] [decimal](10, 2) NULL ,
	[jb4_qs] [decimal](10, 2) NULL ,
	[jb4_sj] [decimal](10, 2) NULL ,
	[jb5_qs] [decimal](10, 2) NULL ,
	[jb5_sj] [decimal](10, 2) NULL ,
	[jb6_qs] [decimal](10, 2) NULL ,
	[jb6_sj] [decimal](10, 2) NULL ,
	[jb7_qs] [decimal](10, 2) NULL ,
	[jb7_sj] [decimal](10, 2) NULL ,
	[jb8_qs] [decimal](10, 2) NULL ,
	[jb8_sj] [decimal](10, 2) NULL ,
	[jb9_qs] [decimal](10, 2) NULL ,
	[jb9_sj] [decimal](10, 2) NULL ,
	[jb10_qs] [decimal](10, 2) NULL ,
	[jb10_sj] [decimal](10, 2) NULL ,
	[jb11_qs] [decimal](10, 2) NULL ,
	[jb11_sj] [decimal](10, 2) NULL ,
	[jb12_qs] [decimal](10, 2) NULL ,
	[jb12_sj] [decimal](10, 2) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jblb] (
	[lbdm] [int] NOT NULL ,
	[lbmc] [char] (30) NULL ,
	[jbsj] [datetime] NULL ,
	[kssj] [datetime] NULL ,
	[jssj] [datetime] NULL ,
	[bz] [char] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jblb_mq] (
	[jblb] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jblist] (
	[jbmc] [char] (30) NOT NULL ,
	[bh] [char] (10) NULL ,
	[beizhu] [char] (50) NULL ,
	[user1] [char] (60) NULL ,
	[user2] [char] (60) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jbtj] (
	[rq] [datetime] NOT NULL ,
	[bh] [int] NOT NULL ,
	[xm] [char] (8) NULL ,
	[bm] [char] (50) NULL ,
	[jblb] [char] (20) NULL ,
	[kssj] [datetime] NOT NULL ,
	[jssj] [datetime] NOT NULL ,
	[jbsj] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jc_base] (
	[jc_no] [char] (10) NOT NULL ,
	[jcmc] [char] (50) NULL ,
	[jclb] [int] NULL ,
	[jcje] [numeric](8, 2) NULL ,
	[jcday] [numeric](8, 2) NULL ,
	[user1] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jc_bmcs] (
	[rq] [datetime] NOT NULL ,
	[c1] [int] NULL ,
	[c2] [int] NULL ,
	[c3] [int] NULL ,
	[c4] [int] NULL ,
	[c5] [int] NULL ,
	[c6] [int] NULL ,
	[z1] [int] NULL ,
	[z2] [int] NULL ,
	[z3] [int] NULL ,
	[z4] [int] NULL ,
	[z5] [int] NULL ,
	[z6] [int] NULL ,
	[w1] [int] NULL ,
	[w2] [int] NULL ,
	[w3] [int] NULL ,
	[w4] [int] NULL ,
	[w5] [int] NULL ,
	[w6] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jc_empst_report] (
	[rq] [datetime] NOT NULL ,
	[xac] [int] NULL ,
	[xam] [money] NULL ,
	[xbc] [int] NULL ,
	[xbm] [money] NULL ,
	[xcc] [int] NULL ,
	[xcm] [money] NULL ,
	[xdc] [int] NULL ,
	[xdm] [money] NULL ,
	[xec] [int] NULL ,
	[xem] [money] NULL ,
	[yac] [int] NULL ,
	[yam] [money] NULL ,
	[ybc] [int] NULL ,
	[ybm] [money] NULL ,
	[ycc] [int] NULL ,
	[ycm] [money] NULL ,
	[ydc] [int] NULL ,
	[ydm] [money] NULL ,
	[yec] [int] NULL ,
	[yem] [money] NULL ,
	[bh] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jc_input] (
	[jc_date] [smalldatetime] NOT NULL ,
	[jc_employee] [char] (10) NOT NULL ,
	[jc_kh] [int] NULL ,
	[jc_xm] [char] (10) NULL ,
	[jc_bm] [char] (10) NULL ,
	[jc_c1] [char] (1) NULL ,
	[jc_c2] [char] (1) NULL ,
	[jc_c3] [char] (1) NULL ,
	[jc_c4] [char] (1) NULL ,
	[jc_c5] [char] (1) NULL ,
	[jc_c6] [char] (1) NULL ,
	[jc_price] [smallmoney] NULL ,
	[jc_flag] [char] (20) NULL ,
	[jc_jh] [char] (10) NULL ,
	[jc_bz] [varchar] (30) NULL ,
	[p1] [smallmoney] NULL ,
	[p2] [smallmoney] NULL ,
	[p3] [smallmoney] NULL ,
	[p4] [smallmoney] NULL ,
	[p5] [smallmoney] NULL ,
	[p6] [smallmoney] NULL ,
	[x1] [smallmoney] NULL ,
	[x2] [smallmoney] NULL ,
	[x3] [smallmoney] NULL ,
	[x4] [smallmoney] NULL ,
	[x5] [smallmoney] NULL ,
	[x6] [smallmoney] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jc_input_yb] (
	[jc_month] [char] (7) NOT NULL ,
	[jc_bh] [int] NOT NULL ,
	[jc_xm] [char] (10) NULL ,
	[jc_kh] [varchar] (50) NULL ,
	[jc_bm] [varchar] (50) NULL ,
	[p1] [smallmoney] NULL ,
	[p2] [smallmoney] NULL ,
	[p3] [smallmoney] NULL ,
	[p4] [smallmoney] NULL ,
	[x1] [smallmoney] NULL ,
	[x2] [smallmoney] NULL ,
	[x3] [smallmoney] NULL ,
	[x4] [smallmoney] NULL ,
	[sump] [smallmoney] NULL ,
	[sumx] [smallmoney] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jc_rb_dxj] (
	[jc_date] [datetime] NOT NULL ,
	[jc_bm] [char] (10) NULL ,
	[d1] [smallmoney] NULL ,
	[d2] [smallmoney] NULL ,
	[d3] [smallmoney] NULL ,
	[d4] [smallmoney] NULL ,
	[x1] [smallmoney] NULL ,
	[x2] [smallmoney] NULL ,
	[x3] [smallmoney] NULL ,
	[x4] [smallmoney] NULL ,
	[j1] [smallmoney] NULL ,
	[j2] [smallmoney] NULL ,
	[j3] [smallmoney] NULL ,
	[j4] [smallmoney] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jc_st_report] (
	[rq] [datetime] NOT NULL ,
	[xac] [int] NULL ,
	[xam] [money] NULL ,
	[xbc] [int] NULL ,
	[xbm] [money] NULL ,
	[xcc] [int] NULL ,
	[xcm] [money] NULL ,
	[xdc] [int] NULL ,
	[xdm] [money] NULL ,
	[xec] [int] NULL ,
	[xem] [money] NULL ,
	[yac] [int] NULL ,
	[yam] [money] NULL ,
	[ybc] [int] NULL ,
	[ybm] [money] NULL ,
	[ycc] [int] NULL ,
	[ycm] [money] NULL ,
	[ydc] [int] NULL ,
	[ydm] [money] NULL ,
	[yec] [int] NULL ,
	[yem] [money] NULL ,
	[stname] [varchar] (20) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[jc_yb_dxj] (
	[jc_month] [char] (7) NOT NULL ,
	[jc_bm] [char] (10) NULL ,
	[d1] [char] (10) NULL ,
12345

⌨️ 快捷键说明

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