针对中小型酒店设计的管理系统，团队项目

-- ---------------------------- -- Table structure for admininfo -- ---------------------------- DROP TABLE IF EXISTS "public"."admininfo"; CREATE TABLE "public"."admininfo" ( "Id" int4 NOT NULL DEFAULT nextval('upms_log_id_seq'::regclass), "AdminAccount" varchar(15) COLLATE "pg_catalog"."default" NOT NULL, "AdminPassword" varchar(200) COLLATE "pg_catalog"."default", "AdminType" varchar(15) COLLATE "pg_catalog"."default", "AdminName" varchar(50) COLLATE "pg_catalog"."default", "IsAdmin" int4, "DeleteMk" int4, "datains_usr" varchar(20) COLLATE "pg_catalog"."default", "datains_time" date, "datachg_usr" varchar(20) COLLATE "pg_catalog"."default", "datachg_time" date ) ; COMMENT ON COLUMN "public"."admininfo"."Id" IS '自增长ID'; COMMENT ON COLUMN "public"."admininfo"."AdminAccount" IS '管理员账号'; COMMENT ON COLUMN "public"."admininfo"."AdminPassword" IS '管理员密码'; COMMENT ON COLUMN "public"."admininfo"."AdminType" IS '管理员类型'; COMMENT ON COLUMN "public"."admininfo"."AdminName" IS '管理员名称'; COMMENT ON COLUMN "public"."admininfo"."IsAdmin" IS '是否为超级管理员'; COMMENT ON COLUMN "public"."admininfo"."DeleteMk" IS '删除标记'; COMMENT ON COLUMN "public"."admininfo"."datains_usr" IS '资料新增人'; COMMENT ON COLUMN "public"."admininfo"."datains_time" IS '资料新增时间'; COMMENT ON COLUMN "public"."admininfo"."datachg_usr" IS '资料更新人'; COMMENT ON COLUMN "public"."admininfo"."datachg_time" IS '资料更新时间'; COMMENT ON TABLE "public"."admininfo" IS '管理员信息表'; -- ---------------------------- -- Records of admininfo -- ---------------------------- INSERT INTO "public"."admininfo" VALUES (1, 'admin', 'admin', 'Admin', '杨俊杰', 1, 0, NULL, NULL, NULL, NULL); INSERT INTO "public"."admininfo" VALUES (3, 'testmin', 'testmin', 'GeneralManager', '测试', 0, 1, '', '2021-05-16', NULL, NULL); INSERT INTO "public"."admininfo" VALUES (4, 'xym', 'cashmin', 'FinanceManager', '熊越明', 0, 0, NULL, NULL, NULL, NULL); INSERT INTO "public"."admininfo" VALUES (6, 'hr', '123456', 'HRManager', '人力经理', 0, 0, 'admin', '2021-05-22', NULL, NULL); INSERT INTO "public"."admininfo" VALUES (9, 'test1', '6666', 'test', '测试', 0, 1, 'admin', '2021-07-31', NULL, NULL); INSERT INTO "public"."admininfo" VALUES (5, 'lishun', 'lishun', 'GeneralManager', '李顺', 0, 1, 'admin', '2021-05-18', NULL, NULL); INSERT INTO "public"."admininfo" VALUES (2, 'bha', 'hotelmin', 'HotelManager', '宾华安', 0, 1, NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for admintype -- ---------------------------- DROP TABLE IF EXISTS "public"."admintype"; CREATE TABLE "public"."admintype" ( "Id" int4 NOT NULL DEFAULT nextval('upms_log_id_seq'::regclass), "type_id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "type_name" varchar(50) COLLATE "pg_catalog"."default", "delete_mk" int4 NOT NULL, "datains_usr" varchar(20) COLLATE "pg_catalog"."default", "datains_date" date, "datachg_usr" varchar(20) COLLATE "pg_catalog"."default", "datachg_date" date ) ; COMMENT ON COLUMN "public"."admintype"."Id" IS '编号'; COMMENT ON COLUMN "public"."admintype"."type_id" IS '管理员类型'; COMMENT ON COLUMN "public"."admintype"."type_name" IS '管理员类型名称'; COMMENT ON COLUMN "public"."admintype"."delete_mk" IS '删除标记'; COMMENT ON COLUMN "public"."admintype"."datains_usr" IS '资料创建人'; COMMENT ON COLUMN "public"."admintype"."datains_date" IS '资料创建时间'; COMMENT ON COLUMN "public"."admintype"."datachg_usr" IS '资料更新人'; COMMENT ON COLUMN "public"."admintype"."datachg_date" IS '资料更新时间'; COMMENT ON TABLE "public"."admintype" IS '管理员类型表'; -- ---------------------------- -- Records of admintype -- ---------------------------- INSERT INTO "public"."admintype" VALUES (1, 'Admin', '超级管理员', 0, NULL, NULL, NULL, NULL); INSERT INTO "public"."admintype" VALUES (2, 'FinanceManager', '财务经理', 0, NULL, NULL, NULL, NULL); INSERT INTO "public"."admintype" VALUES (3, 'GeneralManager', '总经理', 0, NULL, NULL, NULL, NULL); INSERT INTO "public"."admintype" VALUES (4, 'HotelManager', '酒店经理', 0, NULL, NULL, NULL, NULL); INSERT INTO "public"."admintype" VALUES (5, 'HRManager', '人力资源经理', 0, NULL, NULL, NULL, NULL); INSERT INTO "public"."admintype" VALUES (6, 'LogisticsManager', '后勤经理', 0, NULL, NULL, NULL, NULL); INSERT INTO "public"."admintype" VALUES (7, 'CheckGroup', '监管小组', 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for applicationversion -- ---------------------------- DROP TABLE IF EXISTS "public"."applicationversion"; CREATE TABLE "public"."applicationversion" ( "base_versionId" int2 NOT NULL DEFAULT nextval('upms_log_id_seq'::regclass), "base_version" varchar(50) COLLATE "pg_catalog"."default" NOT NULL ) ; COMMENT ON COLUMN "public"."applicationversion"."base_versionId" IS '流水号'; COMMENT ON COLUMN "public"."applicationversion"."base_version" IS '版本号'; COMMENT ON TABLE "public"."applicationversion" IS '应用程序版本控制表'; -- ---------------------------- -- Records of applicationversion -- ---------------------------- INSERT INTO "public"."applicationversion" VALUES (1, '1.5.0.8'); -- ---------------------------- -- Table structure for backinfo -- ---------------------------- DROP TABLE IF EXISTS "public"."backinfo"; CREATE TABLE "public"."backinfo" ( "BackNo" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "BackName" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "BackSource" varchar(18) COLLATE "pg_catalog"."default" NOT NULL, "BackCash" numeric(6,2) NOT NULL, "BackType" int4 NOT NULL, "BackPerson" varchar(8) COLLATE "pg_catalog"."default" NOT NULL, "ControlClub" varchar(12) COLLATE "pg_catalog"."default" NOT NULL, "BackClub" varchar(12) COLLATE "pg_catalog"."default" NOT NULL, "delete_mk" int4 NOT NULL, "datains_usr" varchar(20) COLLATE "pg_catalog"."default", "datains_date" date, "datachg_usr" varchar(20) COLLATE "pg_catalog"."default", "datachg_date" date ) ; COMMENT ON COLUMN "public"."backinfo"."BackNo" IS '物资编号'; COMMENT ON COLUMN "public"."backinfo"."BackName" IS '物资名称'; COMMENT ON COLUMN "public"."backinfo"."BackSource" IS '物资来源'; COMMENT ON COLUMN "public"."backinfo"."BackCash" IS '物资金额'; COMMENT ON COLUMN "public"."backinfo"."BackType" IS '物资类型'; COMMENT ON COLUMN "public"."backinfo"."BackPerson" IS '经办人'; COMMENT ON COLUMN "public"."backinfo"."ControlClub" IS '管理部门'; COMMENT ON COLUMN "public"."backinfo"."BackClub" IS '所属部门'; COMMENT ON COLUMN "public"."backinfo"."delete_mk" IS '删除标记'; COMMENT ON COLUMN "public"."backinfo"."datains_usr" IS '资料创建人'; COMMENT ON COLUMN "public"."backinfo"."datains_date" IS '资料创建时间'; COMMENT ON COLUMN "public"."backinfo"."datachg_usr" IS '资料更新人'; COMMENT ON COLUMN "public"."backinfo"."datachg_date" IS '资料更新时间'; COMMENT ON TABLE "public"."backinfo" IS '酒店物资表'; -- ---------------------------- -- Records of backinfo -- ---------------------------- INSERT INTO "public"."backinfo" VALUES ('B001', '一次性毛巾', '超市', 1000.00, 1, '李杰峰', '财务部', '餐饮部', 0, NULL, NULL, NULL, NULL); INSERT INTO "public"."backinfo" VALUES ('B002', '一次性牙刷', '超市', 2000.00, 2, '李杰峰', '财务部', '酒店部', 0, NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for base -- ---------------------------- DROP TABLE IF EXISTS "public"."base"; CREATE TABLE "public"."base" ( "url_no" int4 NOT NULL DEFAULT nextval('upms_log_id_seq'::regclass), "url_addr" varchar(255) COLLATE "pg_catalog"."default" ) ; COMMENT ON COLUMN "public"."base"."url_no" IS 'ID'; COMMENT ON COLUMN "public"."base"."url_addr" IS '地址'; COMMENT ON TABLE "public"."base" IS '程序�