· 5 years ago · May 28, 2020, 03:10 AM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : PostgreSql
5 Source Server Type : PostgreSQL
6 Source Server Version : 110005
7 Source Host : localhost:5432
8 Source Catalog : hrms
9 Source Schema : public
10
11 Target Server Type : PostgreSQL
12 Target Server Version : 110005
13 File Encoding : 65001
14
15 Date: 28/05/2020 10:05:57
16*/
17
18
19-- ----------------------------
20-- Table structure for ms_menu
21-- ----------------------------
22DROP TABLE IF EXISTS "public"."ms_menu";
23CREATE TABLE "public"."ms_menu" (
24 "id_menu" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
25 "reference" varchar(30) COLLATE "pg_catalog"."default",
26 "menu" varchar(100) COLLATE "pg_catalog"."default",
27 "sequence" int2,
28 "menu_url" varchar(100) COLLATE "pg_catalog"."default",
29 "menu_icon" varchar(100) COLLATE "pg_catalog"."default",
30 "created_at" timestamp(6),
31 "created_by" varchar(255) COLLATE "pg_catalog"."default",
32 "updated_at" timestamp(6),
33 "updated_by" varchar(100) COLLATE "pg_catalog"."default",
34 "menu_level" int2
35)
36;
37
38-- ----------------------------
39-- Records of ms_menu
40-- ----------------------------
41INSERT INTO "public"."ms_menu" VALUES ('1', NULL, 'Master Data', 1, NULL, 'fa fa-folder-open', '2020-03-30 13:33:34', 'Admin', '2020-03-30 13:33:44', 'Admin', 1);
42INSERT INTO "public"."ms_menu" VALUES ('4', '1', 'Hobby', 2, 'hobby', NULL, '2020-03-30 13:38:52', 'Admin', '2020-03-30 13:38:59', 'Admin', 2);
43INSERT INTO "public"."ms_menu" VALUES ('5', '1', 'Education', 3, 'education', NULL, '2020-03-30 13:40:00', 'Admin', '2020-03-30 13:40:07', 'Admin', 2);
44INSERT INTO "public"."ms_menu" VALUES ('6', '1', 'Document', 4, 'document', NULL, '2020-03-30 13:40:47', 'Admin', '2020-03-30 13:40:54', 'Admin', 2);
45INSERT INTO "public"."ms_menu" VALUES ('7', '1', 'Bank', 5, 'bank', NULL, '2020-03-30 13:42:02', 'Admin', '2020-03-30 13:42:06', 'Admin', 2);
46INSERT INTO "public"."ms_menu" VALUES ('8', '1', 'Position', 6, 'position', NULL, '2020-03-30 13:43:08', 'Admin', '2020-03-30 13:43:13', 'Admin', 2);
47INSERT INTO "public"."ms_menu" VALUES ('9', '2', 'Employee', 1, 'employee', NULL, '2020-03-30 13:45:30', 'Admin', '2020-03-30 13:45:34', 'Admin', 2);
48INSERT INTO "public"."ms_menu" VALUES ('11', '2', 'Employee Address', 3, 'employee_address', NULL, '2020-03-30 13:48:38', 'Admin', '2020-03-30 13:48:41', 'Admin', 2);
49INSERT INTO "public"."ms_menu" VALUES ('12', '2', 'Pra-Employee Address', 4, 'pra_employee_address', NULL, '2020-03-30 13:49:33', 'Admin', '2020-03-30 13:49:43', 'Admin', 2);
50INSERT INTO "public"."ms_menu" VALUES ('13', '2', 'Family', 5, 'family', NULL, '2020-03-30 13:50:29', 'Admin', '2020-03-30 13:50:36', 'Admin', 2);
51INSERT INTO "public"."ms_menu" VALUES ('15', '2', 'Organization Chart', 7, 'organization_chart', NULL, '2020-03-30 13:52:45', 'Admin', '2020-03-30 13:52:51', 'Admin', 2);
52INSERT INTO "public"."ms_menu" VALUES ('2', NULL, 'Employee Data', 2, NULL, 'fa fa-user', '2020-03-30 13:44:16', 'Admin', '2020-03-30 13:44:20', 'Admin', 1);
53INSERT INTO "public"."ms_menu" VALUES ('14', '2', 'Employee Bank', 6, 'employee_bank', NULL, '2020-03-30 13:51:20', 'Admin', '2020-03-30 13:51:36', 'Admin', 2);
54INSERT INTO "public"."ms_menu" VALUES ('3', '1', 'Religion', 1, 'agama', NULL, '2020-03-30 13:37:27', 'Admin', '2020-03-30 13:37:34', 'Admin', 2);
55INSERT INTO "public"."ms_menu" VALUES ('20', '1', 'Workflow', 8, 'workflow', NULL, '2020-04-05 21:12:56', 'Admin', '2020-04-05 21:13:02', 'Admin', 2);
56INSERT INTO "public"."ms_menu" VALUES ('21', '19', 'User Role', 1, 'user_role', NULL, '2020-04-07 10:58:05', 'Admin', '2020-04-07 10:58:14', 'Admin', 2);
57INSERT INTO "public"."ms_menu" VALUES ('19', NULL, 'User Management', 3, NULL, 'fa fa-user-lock', '2020-04-05 21:12:56', 'Admin', '2020-04-05 21:13:02', 'Admin', 1);
58INSERT INTO "public"."ms_menu" VALUES ('22', NULL, 'Request', 5, NULL, 'fa fa-link', '2020-04-07 11:05:40', 'Admin', '2020-04-07 11:05:45', 'Admin', 1);
59INSERT INTO "public"."ms_menu" VALUES ('27', NULL, 'Appraisal', 7, NULL, 'fa fa-medal', '2020-04-07 11:14:44', 'Admin', '2020-04-07 11:14:50', 'Admin', 1);
60INSERT INTO "public"."ms_menu" VALUES ('28', '27', 'Appraisal Type', 1, 'appraisal_type', NULL, '2020-04-07 11:18:27', 'Admin', '2020-04-07 11:18:33', 'Admin', 2);
61INSERT INTO "public"."ms_menu" VALUES ('29', '27', 'Appraisal Criteria', 2, 'appraisal_criteria', NULL, '2020-04-07 11:19:12', 'Admin', '2020-04-07 11:19:18', 'Admin', 2);
62INSERT INTO "public"."ms_menu" VALUES ('30', '27', 'Appraisal Aspect', 3, 'appraisal_aspect', NULL, '2020-04-07 11:19:59', 'Admin', '2020-04-07 11:20:03', 'Admin', 2);
63INSERT INTO "public"."ms_menu" VALUES ('31', '27', 'Indicator Perspective', 4, 'indicator_perspective', NULL, '2020-04-07 11:20:42', 'Admin', '2020-04-07 11:20:47', 'Admin', 2);
64INSERT INTO "public"."ms_menu" VALUES ('32', '27', 'Passing Grade', 5, 'passing_grade', NULL, '2020-04-07 11:21:15', 'Admin', '2020-04-07 11:21:22', 'Admin', 2);
65INSERT INTO "public"."ms_menu" VALUES ('33', NULL, 'ESS', 8, 'ess', 'fa fa-concierge-bell', '2020-04-07 11:23:42', 'Admin', '2020-04-07 11:23:48', 'Admin', 1);
66INSERT INTO "public"."ms_menu" VALUES ('36', '33', 'My Request', 3, 'ess_request', NULL, '2020-04-07 11:26:41', 'Admin', '2020-04-07 11:26:47', 'Admin', 2);
67INSERT INTO "public"."ms_menu" VALUES ('26', NULL, 'Report', 6, '', 'fa fa-file', '2020-04-07 11:11:50', 'Admin', '2020-04-07 11:11:55', 'Admin', 1);
68INSERT INTO "public"."ms_menu" VALUES ('38', '37', 'Trainer', 1, 'trainer', NULL, '2020-04-07 14:35:52', 'Admin', '2020-04-07 14:35:59', 'Admin', 2);
69INSERT INTO "public"."ms_menu" VALUES ('40', '37', 'Training Plan', 3, 'training_plan', NULL, '2020-04-07 14:38:19', 'Admin', '2020-04-07 14:38:24', 'Admin', 2);
70INSERT INTO "public"."ms_menu" VALUES ('41', '37', 'Training Member', 4, 'training_member', NULL, '2020-04-07 14:39:29', 'Admin', '2020-04-07 14:39:33', 'Admin', 2);
71INSERT INTO "public"."ms_menu" VALUES ('42', '37', 'Training Schedule', 5, 'training_schedule', NULL, '2020-04-07 14:40:38', 'Admin', '2020-04-07 14:40:43', 'Admin', 2);
72INSERT INTO "public"."ms_menu" VALUES ('43', '37', 'Vendor', 6, 'vendor_training', NULL, '2020-04-07 14:41:29', 'Admin', '2020-04-07 14:41:34', 'Admin', 2);
73INSERT INTO "public"."ms_menu" VALUES ('39', '37', 'Training Name', 2, 'training', NULL, '2020-04-07 14:37:16', 'Admin', '2020-04-07 14:37:21', 'Admin', 2);
74INSERT INTO "public"."ms_menu" VALUES ('47', '27', 'Question', 6, 'question', NULL, '2020-04-22 13:28:43', 'Admin', '2020-04-22 13:28:49', 'Admin', 2);
75INSERT INTO "public"."ms_menu" VALUES ('51', '22', 'Travel', 3, 'travel_request', NULL, '2020-04-27 10:33:29', 'Admin', '2020-04-27 10:33:35', 'Admin', 2);
76INSERT INTO "public"."ms_menu" VALUES ('52', '22', 'Training', 4, 'training_request', NULL, '2020-04-27 10:34:15', 'Admin', '2020-04-27 10:34:25', 'Admin', 2);
77INSERT INTO "public"."ms_menu" VALUES ('53', '22', 'Permission', 5, 'permission_request', NULL, '2020-04-27 10:34:59', 'Admin', '2020-04-27 10:35:05', 'Admin', 2);
78INSERT INTO "public"."ms_menu" VALUES ('23', '22', 'Sick', 1, 'sick_request', NULL, '2020-04-07 11:07:31', 'Admin', '2020-04-07 11:07:36', 'Admin', 2);
79INSERT INTO "public"."ms_menu" VALUES ('24', '22', 'Leave', 2, 'leave_request', NULL, '2020-04-07 11:08:40', 'Admin', '2020-04-07 11:08:46', 'Admin', 2);
80INSERT INTO "public"."ms_menu" VALUES ('25', '22', 'Client Visit', 3, 'client_visit_request', NULL, '2020-04-07 11:09:29', 'Admin', '2020-04-07 11:09:35', 'Admin', 2);
81INSERT INTO "public"."ms_menu" VALUES ('10', '2', 'Pra-employee', 2, 'praemployee', NULL, '2020-03-30 13:47:09', 'Admin', '2020-03-30 13:47:15', 'Admin', 2);
82INSERT INTO "public"."ms_menu" VALUES ('59', '27', 'Aspect Assessment', 7, 'aspect_assessment', NULL, '2020-05-07 13:31:21', 'Admin', '2020-05-07 13:31:31', 'Admin', 2);
83INSERT INTO "public"."ms_menu" VALUES ('60', '27', 'Indicator Assessment', 8, 'indicator_assessment', '', '2020-05-11 13:09:00', 'Admin', '2020-05-11 13:09:00', 'Admin', 2);
84INSERT INTO "public"."ms_menu" VALUES ('37', NULL, 'Manage Training', 9, '', 'fa fa-chalkboard-teacher', '2020-04-07 14:33:49', 'Admin', '2020-04-07 14:33:56', 'Admin', 1);
85INSERT INTO "public"."ms_menu" VALUES ('61', '2', 'Education History', 8, 'education_history', NULL, '2020-05-26 14:17:33', 'Admin', '2020-05-26 14:17:41', 'Admin', 2);
86INSERT INTO "public"."ms_menu" VALUES ('62', '2', 'Working History', 9, 'working_history', NULL, '2020-05-26 14:18:22', 'Admin', '2020-05-26 14:18:29', 'Admin', 2);
87INSERT INTO "public"."ms_menu" VALUES ('63', '1', 'Holiday', 8, 'holiday', NULL, '2020-05-27 11:32:26', 'Admin', '2020-05-27 11:32:33', 'Admin', 2);
88INSERT INTO "public"."ms_menu" VALUES ('64', NULL, 'Attendance', 4, NULL, 'fa fa-clock', '2020-05-27 13:21:42', 'Admin', '2020-05-27 13:21:49', 'Admin', 1);
89INSERT INTO "public"."ms_menu" VALUES ('35', '64', 'My Attendance', 2, 'ess_attendance', NULL, '2020-04-07 11:26:08', 'Admin', '2020-04-07 11:26:13', 'Admin', 2);
90INSERT INTO "public"."ms_menu" VALUES ('55', '54', 'Promotion', 1, 'promotion', NULL, '2020-04-28 10:23:37', 'Admin', '2020-04-28 10:23:43', 'Admin', 3);
91INSERT INTO "public"."ms_menu" VALUES ('58', '64', 'All Attendance', 8, 'attendance', NULL, '2020-04-29 13:04:51', 'Admin', '2020-04-29 13:04:57', 'Admin', 2);
92INSERT INTO "public"."ms_menu" VALUES ('65', '1', 'Attendance Type', 9, 'attendance_type', NULL, '2020-05-27 15:00:45', 'Admin', '2020-05-27 15:00:53', 'Admin', 2);
93INSERT INTO "public"."ms_menu" VALUES ('66', '1', 'Leave Balance', 10, 'leave_balance', NULL, '2020-05-27 16:23:17', 'Admin', '2020-05-27 16:23:28', 'Admin', 2);
94INSERT INTO "public"."ms_menu" VALUES ('16', '2', 'Qualification', 10, NULL, '', '2020-03-30 13:54:26', 'Admin', '2020-03-30 13:54:30', 'Admin', 2);
95INSERT INTO "public"."ms_menu" VALUES ('17', '16', 'Skill', 1, 'skill', NULL, '2020-03-30 13:55:33', 'Admin', '2020-03-30 13:55:37', 'Admin', 3);
96INSERT INTO "public"."ms_menu" VALUES ('18', '16', 'Certification', 2, 'certification', NULL, '2020-03-30 13:56:35', 'Admin', '2020-03-30 13:56:38', 'Admin', 3);
97INSERT INTO "public"."ms_menu" VALUES ('44', '2', 'Medical Record', 11, NULL, NULL, '2020-04-20 09:35:36', 'Admin', '2020-04-20 09:35:46', 'Admin', 2);
98INSERT INTO "public"."ms_menu" VALUES ('45', '44', 'Medical Status', 1, 'medical_status', NULL, '2020-04-20 09:40:14', 'Admin', '2020-04-20 09:40:20', 'Admin', 3);
99INSERT INTO "public"."ms_menu" VALUES ('46', '44', 'Medical History', 2, 'medical_history', NULL, '2020-04-20 09:42:39', 'Admin', '2020-04-20 09:40:41', 'Admin', 3);
100INSERT INTO "public"."ms_menu" VALUES ('54', '2', 'Development', 12, NULL, NULL, '2020-04-28 10:22:20', 'Admin', '2020-04-28 10:22:26', 'Admin', 2);
101INSERT INTO "public"."ms_menu" VALUES ('56', '54', 'Mutation', 2, 'mutation', NULL, '2020-04-28 10:24:17', 'Admin', '2020-04-28 10:24:22', 'Admin', 3);
102INSERT INTO "public"."ms_menu" VALUES ('57', '54', 'Deposition', 3, 'deposition', NULL, '2020-04-28 10:25:04', 'Admin', '2020-04-28 10:25:10', 'Admin', 3);
103
104-- ----------------------------
105-- Primary Key structure for table ms_menu
106-- ----------------------------
107ALTER TABLE "public"."ms_menu" ADD CONSTRAINT "ms_menu_pkey" PRIMARY KEY ("id_menu");