?? hrdb.sql
字號:
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 ,
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -