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

📄 hrdb.sql

📁 金华门禁系统数据库脚本,涵盖了门禁,售饭,人力资源管理等
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
CREATE TABLE [dbo].[SysLink] (
	[FORptID] [varchar] (40) NOT NULL ,
	[FTRptID] [varchar] (6) NOT NULL ,
	[FMName] [varchar] (8) NOT NULL ,
	[FMText] [varchar] (60) NULL ,
	[FLinkClms] [varchar] (80) NULL ,
	[FLinkMode] [char] (1) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[SysRpt] (
	[FRptID] [varchar] (6) NOT NULL ,
	[FRptEName] [varchar] (128) NULL ,
	[FRptCName] [varchar] (80) NULL ,
	[FPaper] [varchar] (30) NULL ,
	[FLevel] [char] (1) NULL ,
	[FType] [char] (1) NULL ,
	[FRptSyntax] [image] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[bed_detail] (
	[build_id] [char] (10) NOT NULL ,
	[room_id] [char] (10) NOT NULL ,
	[bed_id] [char] (10) NOT NULL ,
	[empbh] [int] NULL ,
	[empxm] [char] (10) NULL ,
	[rzrq] [datetime] NULL ,
	[statues] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[blp_jjbz] (
	[xh] [int] NOT NULL ,
	[bmbh] [int] NULL ,
	[bmdm] [char] (20) NULL ,
	[bmmc] [char] (40) NULL ,
	[m_min] [decimal](10, 6) NULL ,
	[m_max] [decimal](10, 6) NULL ,
	[je] [decimal](15, 4) NULL ,
	[bz] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[bmcqqk] (
	[rq] [datetime] NOT NULL ,
	[bm] [char] (40) NOT NULL ,
	[cqrs] [int] NULL ,
	[wskrs] [int] NULL ,
	[bmbh] [int] NULL ,
	[user1] [int] NULL ,
	[user2] [int] NULL ,
	[user3] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[bmcqrbb] (
	[RQ] [datetime] NOT NULL ,
	[bmmc] [varchar] (20) NOT NULL ,
	[c11] [int] NULL ,
	[c12] [int] NULL ,
	[c13] [int] NULL ,
	[c21] [int] NULL ,
	[c22] [int] NULL ,
	[c23] [int] NULL ,
	[c31] [int] NULL ,
	[c32] [int] NULL ,
	[c33] [int] NULL ,
	[c41] [int] NULL ,
	[c42] [int] NULL ,
	[c43] [int] NULL ,
	[c51] [int] NULL ,
	[c52] [int] NULL ,
	[c53] [int] NULL ,
	[zrs] [int] NULL ,
	[ycqrs] [int] NULL ,
	[sjcqrs] [int] NULL ,
	[cql] [numeric](18, 0) NULL ,
	[bz] [varchar] (80) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[bmqkb] (
	[rq] [datetime] NOT NULL ,
	[bmmc] [int] NOT NULL ,
	[rs] [int] NULL ,
	[nan] [int] NULL ,
	[nv] [int] NULL ,
	[bs] [int] NULL ,
	[ss] [int] NULL ,
	[bk] [int] NULL ,
	[dz] [int] NULL ,
	[zz] [int] NULL ,
	[gz] [int] NULL ,
	[yx] [int] NULL ,
	[user1] [int] NULL ,
	[user2] [int] NULL ,
	[user3] [int] NULL ,
	[user4] [int] NULL ,
	[user5] [int] NULL ,
	[user6] [int] NULL ,
	[user7] [int] NULL ,
	[user8] [int] NULL ,
	[user9] [int] NULL ,
	[user10] [int] NULL ,
	[bm] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[change_count] (
	[rq] [datetime] NOT NULL ,
	[xm] [char] (20) NOT NULL ,
	[male] [int] NULL ,
	[female] [int] NULL ,
	[total] [int] NULL ,
	[u_1] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[change_mx] (
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NOT NULL ,
	[kh] [char] (50) NULL ,
	[xb] [char] (2) NULL ,
	[rq] [datetime] NOT NULL ,
	[bm] [char] (40) NULL ,
	[zw] [char] (30) NULL ,
	[xl] [char] (16) NULL ,
	[jg] [char] (10) NULL ,
	[zc] [char] (30) NULL ,
	[jb] [char] (30) NULL ,
	[lx] [char] (30) NULL ,
	[lxbh] [char] (1) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[change_print] (
	[xh_type] [char] (20) NOT NULL ,
	[t_font] [char] (30) NULL ,
	[t_font_height] [char] (2) NULL ,
	[t_color] [char] (20) NULL ,
	[c_font] [char] (30) NULL ,
	[c_font_height] [varchar] (2) NULL ,
	[c_color] [char] (20) NULL ,
	[e_font] [char] (30) NULL ,
	[e_font_height] [char] (2) NULL ,
	[e_color] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[comprice] (
	[prc_no] [char] (12) NOT NULL ,
	[com_no] [char] (10) NOT NULL ,
	[comname] [varchar] (80) NULL ,
	[money] [decimal](12, 4) NULL ,
	[pay_mode] [char] (2) NULL ,
	[p_type] [char] (2) NULL ,
	[p_date] [smalldatetime] NULL ,
	[p_address] [varchar] (80) NULL ,
	[result] [char] (2) NULL ,
	[memo] [varchar] (100) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[consumecount] (
	[bh] [int] NOT NULL ,
	[xm] [char] (10) NOT NULL ,
	[bm] [char] (40) NOT NULL ,
	[times1] [int] NULL ,
	[consume1] [decimal](20, 0) NULL ,
	[times2] [int] NULL ,
	[consume2] [decimal](20, 0) NULL ,
	[times3] [int] NULL ,
	[consume3] [decimal](20, 0) NULL ,
	[total_times] [int] NULL ,
	[total_consume] [decimal](20, 0) NULL ,
	[times4] [int] NULL ,
	[consume4] [decimal](20, 0) NULL ,
	[xfsd] [char] (30) NULL ,
	[bmbh] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[consumedata] (
	[deviceid] [int] NOT NULL ,
	[recordid] [decimal](20, 0) NULL ,
	[consumedate] [datetime] NOT NULL ,
	[consumetime] [datetime] NOT NULL ,
	[cardid] [int] NOT NULL ,
	[cardvalue] [decimal](20, 0) NULL ,
	[usecount] [int] NULL ,
	[consumemoney] [decimal](20, 0) NULL ,
	[mealtypeid] [int] NULL ,
	[operatorid] [int] NULL ,
	[dealflag] [int] NULL ,
	[manualflag] [int] NULL ,
	[nightdate] [datetime] NULL ,
	[nighttime] [datetime] NULL ,
	[xm] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[count_dep_jb] (
	[bmbh] [int] NOT NULL ,
	[bmmc] [char] (40) NULL ,
	[jb] [char] (40) NOT NULL ,
	[number] [int] NULL ,
	[bl] [char] (10) NULL ,
	[rs] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[count_dep_jg] (
	[bmmc] [char] (40) NOT NULL ,
	[jgb] [char] (40) NOT NULL ,
	[number] [int] NOT NULL ,
	[bl] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[count_dep_xb] (
	[bmmc] [char] (40) NOT NULL ,
	[xb] [char] (2) NOT NULL ,
	[number] [int] NOT NULL ,
	[bl] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[count_dep_xl] (
	[bmmc] [char] (40) NOT NULL ,
	[xlb] [char] (40) NOT NULL ,
	[number] [int] NOT NULL ,
	[bl] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[count_dep_zw] (
	[bmmc] [char] (40) NOT NULL ,
	[zwb] [char] (40) NOT NULL ,
	[number] [int] NOT NULL ,
	[bl] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[count_jg] (
	[jgb] [char] (40) NOT NULL ,
	[number] [int] NOT NULL ,
	[bl] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[count_xl] (
	[xlb] [char] (20) NOT NULL ,
	[number] [int] NOT NULL ,
	[bl] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[count_zw] (
	[zwb] [char] (40) NOT NULL ,
	[number] [int] NOT NULL ,
	[bl] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cpgx] (
	[cpbh] [char] (60) NOT NULL ,
	[gxbh] [char] (60) NOT NULL ,
	[gxmc] [char] (60) NULL ,
	[gxsl] [int] NULL ,
	[gxdj] [decimal](12, 6) NULL ,
	[sh] [char] (1) NULL ,
	[user1] [decimal](12, 6) NULL ,
	[user2] [char] (10) NULL ,
	[user3] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cpgx_base] (
	[gxbh] [char] (60) NOT NULL ,
	[gxmc] [char] (60) NOT NULL ,
	[gh] [char] (20) NULL ,
	[ks] [char] (20) NULL ,
	[ys] [char] (20) NULL ,
	[cm] [char] (20) NULL ,
	[sl] [decimal](12, 4) NULL ,
	[weight] [decimal](12, 4) NULL ,
	[bmbh] [int] NULL ,
	[bmmc] [char] (40) NULL ,
	[gxdj] [decimal](12, 6) NULL ,
	[user1] [char] (40) NULL ,
	[user2] [char] (40) NULL ,
	[user3] [char] (40) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cpgx_bm] (
	[cpbh] [char] (60) NOT NULL ,
	[gxbh] [char] (60) NOT NULL ,
	[gxmc] [char] (60) NULL ,
	[bmbh] [int] NOT NULL ,
	[gxdj] [decimal](12, 6) NULL ,
	[sh] [char] (1) NULL ,
	[user1] [decimal](12, 6) NULL ,
	[bmmc] [char] (40) NULL ,
	[user3] [char] (10) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cpmc] (
	[cpbh] [char] (60) NOT NULL ,
	[cpmc] [char] (60) NOT NULL ,
	[cpdj] [decimal](8, 2) NULL ,
	[cpkh] [char] (60) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cq_detail] (
	[bh] [decimal](20, 0) NOT NULL ,
	[bmbh] [decimal](20, 0) NULL ,
	[month] [char] (7) NOT NULL ,
	[d01] [char] (8) NULL ,
	[d02] [char] (8) NULL ,
	[d03] [char] (8) NULL ,
	[d04] [char] (8) NULL ,
	[d05] [char] (8) NULL ,
	[d06] [char] (8) NULL ,
	[d07] [char] (8) NULL ,
	[d08] [char] (8) NULL ,
	[d09] [char] (8) NULL ,
	[d10] [char] (8) NULL ,
	[d11] [char] (8) NULL ,
	[d12] [char] (8) NULL ,
	[d13] [char] (8) NULL ,
	[d14] [char] (8) NULL ,
	[d15] [char] (8) NULL ,
	[d16] [char] (8) NULL ,
	[d17] [char] (8) NULL ,
	[d18] [char] (8) NULL ,
	[d19] [char] (8) NULL ,
	[d20] [char] (8) NULL ,
	[d21] [char] (8) NULL ,
	[d22] [char] (8) NULL ,
	[d23] [char] (8) NULL ,
	[d24] [char] (8) NULL ,
	[d25] [char] (8) NULL ,
	[d26] [char] (8) NULL ,
	[d27] [char] (8) NULL ,
	[d28] [char] (8) NULL ,
	[d29] [char] (8) NULL ,
	[d30] [char] (8) NULL ,
	[d31] [char] (8) NULL ,
	[xm] [char] (16) NULL ,
	[bmmc] [char] (40) NULL ,
	[jn] [char] (20) NULL ,
	[jl] [char] (40) NULL ,
	[cf] [char] (40) NULL ,
	[user1] [char] (40) NULL ,
	[user2] [char] (40) NULL ,
	[user3] [char] (40) NULL ,
	[cqts] [char] (8) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cq_detail_2] (
	[bh] [decimal](20, 0) NOT NULL ,
	[bmbh] [decimal](20, 0) NULL ,
	[month] [char] (7) NOT NULL ,
	[d01] [char] (14) NULL ,
	[d02] [char] (14) NULL ,
	[d03] [char] (14) NULL ,
	[d04] [char] (14) NULL ,
	[d05] [char] (14) NULL ,
	[d06] [char] (14) NULL ,
	[d07] [char] (14) NULL ,
	[d08] [char] (14) NULL ,
	[d09] [char] (14) NULL ,
	[d10] [char] (14) NULL ,
	[d11] [char] (14) NULL ,
	[d12] [char] (14) NULL ,
	[d13] [char] (14) NULL ,
	[d14] [char] (14) NULL ,
	[d15] [char] (14) NULL ,
	[d16] [char] (14) NULL ,
	[d17] [char] (14) NULL ,
	[d18] [char] (14) NULL ,
	[d19] [char] (14) NULL ,
	[d20] [char] (14) NULL ,
	[d21] [char] (14) NULL ,
	[d22] [char] (14) NULL ,
	[d23] [char] (14) NULL ,
	[d24] [char] (14) NULL ,
	[d25] [char] (14) NULL ,
	[d26] [char] (14) NULL ,
	[d27] [char] (14) NULL ,
	[d28] [char] (14) NULL ,
	[d29] [char] (14) NULL ,
	[d30] [char] (14) NULL ,
	[d31] [char] (14) NULL ,
	[xm] [char] (16) NULL ,
	[bmmc] [char] (40) NULL ,
	[cqsj] [decimal](10, 2) NULL ,
	[jbcq_time] [decimal](10, 2) NULL ,
	[jbcq_day] [decimal](10, 2) NULL ,
	[jbtq_pxjb] [decimal](10, 2) NULL ,
	[jbtq_xxjb] [decimal](10, 2) NULL ,
	[jjrjb] [decimal](10, 2) NULL ,
	[beizhu] [char] (20) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cq_report] (
	[gh] [int] NOT NULL ,
	[xm] [char] (10) NULL ,
	[month] [char] (10) NULL ,
	[bmmc] [char] (10) NULL ,
	[cqrq] [smalldatetime] NULL ,
	[d1a] [decimal](4, 2) NULL ,
	[d1b] [decimal](4, 2) NULL ,
	[d1c] [decimal](4, 2) NULL ,
	[d1d] [decimal](4, 2) NULL ,
	[d2a] [decimal](4, 2) NULL ,
	[d2b] [decimal](4, 2) NULL ,
	[d2c] [decimal](4, 2) NULL ,
	[d2d] [decimal](4, 2) NULL ,
	[d3a] [decimal](4, 2) NULL ,
	[d3b] [decimal](4, 2) NULL ,
	[d3c] [decimal](4, 2) NULL ,
	[d3d] [decimal](4, 2) NULL ,
	[d4a] [decimal](4, 2) NULL ,
	[d4b] [decimal](4, 2) NULL ,
	[d4c] [decimal](4, 2) NULL ,
	[d4d] [decimal](4, 2) NULL ,
	[d5a] [decimal](4, 2) NULL ,
	[d5b] [decimal](4, 2) NULL ,
	[d5c] [decimal](4, 2) NULL ,
	[d5d] [decimal](4, 2) NULL ,
	[d6a] [decimal](4, 2) NULL ,
	[d6b] [decimal](4, 2) NULL ,
	[d6c] [decimal](4, 2) NULL ,
	[d6d] [decimal](4, 2) NULL ,
	[d7a] [decimal](4, 2) NULL ,
	[d7b] [decimal](4, 2) NULL ,
	[d7c] [decimal](4, 2) NULL ,
	[d7d] [decimal](4, 2) NULL ,
	[d8a] [decimal](4, 2) NULL ,
	[d8b] [decimal](4, 2) NULL ,
	[d8c] [decimal](4, 2) NULL ,
	[d8d] [decimal](4, 2) NULL ,
	[d9a] [decimal](4, 2) NULL ,
	[d9b] [decimal](4, 2) NULL ,
	[d9c] [decimal](4, 2) NULL ,
	[d9d] [decimal](4, 2) NULL ,
	[d10a] [decimal](4, 2) NULL ,
	[d10b] [decimal](4, 2) NULL ,
	[d10c] [decimal](4, 2) NULL ,
	[d10d] [decimal](4, 2) NULL ,
	[d11a] [decimal](4, 2) NULL ,
	[d11b] [decimal](4, 2) NULL ,
	[d11c] [decimal](4, 2) NULL ,
	[d11d] [decimal](4, 2) NULL ,
	[d12a] [decimal](4, 2) NULL ,
	[d12b] [decimal](4, 2) NULL ,
	[d12c] [decimal](4, 2) NULL ,
	[d12d] [decimal](4, 2) NULL ,
	[d13a] [decimal](4, 2) NULL ,
	[d13b] [decimal](4, 2) NULL ,
	[d13c] [decimal](4, 2) NULL ,
	[d13d] [decimal](4, 2) NULL ,
	[d14a] [decimal](4, 2) NULL ,
	[d14b] [decimal](4, 2) NULL ,
	[d14c] [decimal](4, 2) NULL ,
	[d14d] [decimal](4, 0) NULL ,
	[d15a] [decimal](4, 2) NULL ,
	[d15b] [decimal](4, 2) NULL ,
	[d15c] [decimal](4, 2) NULL ,
	[d15d] [decimal](4, 2) NULL ,
	[d16a] [decimal](4, 2) NULL ,
	[d16b] [decimal](4, 2) NULL ,
	[d16c] [decimal](4, 2) NULL ,
	[d16d] [decimal](4, 2) NULL ,
	[d17a] [decimal](4, 2) NULL ,
	[d17b] [decimal](4, 2) NULL ,
	[d17c] [decimal](4, 2) NULL ,
	[d17d] [decimal](4, 2) NULL ,
	[d18a] [decimal](4, 2) NULL ,
	[d18b] [decimal](4, 2) NULL ,
	[d18c] [decimal](4, 2) NULL ,
	[d18d] [decimal](4, 2) NULL ,
	[d19a] [decimal](4, 2) NULL ,
	[d19b] [decimal](4, 2) NULL ,
	[d19c] [decimal](4, 2) NULL ,
	[d19d] [decimal](4, 2) NULL ,
	[d20a] [decimal](4, 2) NULL ,
	[d20b] [decimal](4, 2) NULL ,
	[d20c] [decimal](4, 2) NULL ,
	[d20d] [decimal](4, 2) NULL ,
	[d21a] [decimal](4, 2) NULL ,
	[d21b] [decimal](4, 2) NULL ,
	[d21c] [decimal](4, 2) NULL ,
	[d21d] [decimal](4, 2) NULL ,
	[d22a] [decimal](4, 2) NULL ,
	[d22b] [decimal](4, 2) NULL ,
	[d22c] [decimal](4, 2) NULL ,
	[d22d] [decimal](4, 2) NULL ,
	[d23a] [decimal](4, 2) NULL ,
	[d23b] [decimal](4, 2) NULL ,
	[d23c] [decimal](4, 2) NULL ,
	[d23d] [decimal](4, 2) NULL ,
	[d24a] [decimal](4, 2) NULL ,
	[d24b] [decimal](4, 2) NULL ,
	[d24c] [decimal](4, 2) NULL ,
	[d24d] [decimal](4, 2) NULL ,
	[d25a] [decimal](4, 2) NULL ,
	[d25b] [decimal](4, 2) NULL ,
	[d25c] [decimal](4, 2) NULL ,
	[d25d] [decimal](4, 2) NULL ,
	[d26a] [decimal](4, 2) NULL ,
	[d26b] [decimal](4, 2) NULL ,
12345

⌨️ 快捷键说明

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