· 7 years ago · Oct 20, 2018, 05:50 PM
1-- --------------------------------------------------------
2-- Host: localhost
3-- Server version: 5.7.19 - MySQL Community Server (GPL)
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for pcm_hris
16CREATE DATABASE IF NOT EXISTS `pcm_hris` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `pcm_hris`;
18
19-- Dumping structure for table pcm_hris.bank_information
20CREATE TABLE IF NOT EXISTS `bank_information` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `code` varchar(50) NOT NULL,
23 `personalia_id` int(11) unsigned NOT NULL,
24 `bank_name` varchar(100) NOT NULL,
25 `rek_owner_name` varchar(100) NOT NULL,
26 `rek_number` varchar(50) NOT NULL,
27 `branch_name` varchar(255) NOT NULL,
28 `created_at` datetime DEFAULT NULL,
29 `updated_at` datetime DEFAULT NULL,
30 `deleted_at` datetime DEFAULT NULL,
31 `created_by` varchar(100) DEFAULT NULL,
32 `updated_by` varchar(100) DEFAULT NULL,
33 `deleted_by` varchar(100) DEFAULT NULL,
34 PRIMARY KEY (`id`),
35 KEY `FK_bank_information_personalia` (`personalia_id`),
36 CONSTRAINT `FK_bank_information_personalia` FOREIGN KEY (`personalia_id`) REFERENCES `personalia` (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
38
39-- Dumping data for table pcm_hris.bank_information: ~2 rows (approximately)
40/*!40000 ALTER TABLE `bank_information` DISABLE KEYS */;
41INSERT INTO `bank_information` (`id`, `code`, `personalia_id`, `bank_name`, `rek_owner_name`, `rek_number`, `branch_name`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
42 (1, 'BCWEMIOEMI', 1, 'tewutewu', 'yjfyufyu', '7326287632', 'development', '2018-10-20 17:11:50', '2018-10-20 17:11:50', NULL, 'super@gmail.com', NULL, NULL),
43 (2, 'YSZOIWWJDQ', 1, 'jdsahsakd', 'yjfyufyu', '7467364327', 'dfjdf', '2018-10-20 20:48:07', '2018-10-20 20:48:16', '2018-10-20 20:48:16', 'super@gmail.com', NULL, 'super@gmail.com');
44/*!40000 ALTER TABLE `bank_information` ENABLE KEYS */;
45
46-- Dumping structure for table pcm_hris.childrens
47CREATE TABLE IF NOT EXISTS `childrens` (
48 `id` int(11) NOT NULL AUTO_INCREMENT,
49 `code` varchar(50) NOT NULL,
50 `personalia_id` int(11) unsigned NOT NULL,
51 `children_name` varchar(100) NOT NULL,
52 `created_at` datetime DEFAULT NULL,
53 `updated_at` datetime DEFAULT NULL,
54 `deleted_at` datetime DEFAULT NULL,
55 `created_by` varchar(50) DEFAULT NULL,
56 `updated_by` varchar(50) DEFAULT NULL,
57 `deleted_by` varchar(50) DEFAULT NULL,
58 PRIMARY KEY (`id`),
59 KEY `FK_childrens_personalia` (`personalia_id`),
60 CONSTRAINT `FK_childrens_personalia` FOREIGN KEY (`personalia_id`) REFERENCES `personalia` (`id`)
61) ENGINE=InnoDB DEFAULT CHARSET=latin1;
62
63-- Dumping data for table pcm_hris.childrens: ~0 rows (approximately)
64/*!40000 ALTER TABLE `childrens` DISABLE KEYS */;
65/*!40000 ALTER TABLE `childrens` ENABLE KEYS */;
66
67-- Dumping structure for table pcm_hris.non_remuneration_career
68CREATE TABLE IF NOT EXISTS `non_remuneration_career` (
69 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
70 `code` varchar(20) NOT NULL,
71 `employee_status` varchar(100) NOT NULL,
72 `type` varchar(100) NOT NULL,
73 `personalia_id` int(10) unsigned NOT NULL,
74 `position_id` int(11) NOT NULL,
75 `departement_id` int(11) NOT NULL,
76 `grade` varchar(50) NOT NULL,
77 `group` varchar(50) NOT NULL,
78 `effectve_date` datetime NOT NULL,
79 `created_at` datetime DEFAULT NULL,
80 `updated_at` datetime DEFAULT NULL,
81 `deleted_at` datetime DEFAULT NULL,
82 `created_by` varchar(50) DEFAULT NULL,
83 `updated_by` varchar(50) DEFAULT NULL,
84 `deleted_by` varchar(50) DEFAULT NULL,
85 PRIMARY KEY (`id`),
86 KEY `FK_remuneration_career_positions` (`position_id`),
87 KEY `FK_remuneration_career_departments` (`departement_id`),
88 KEY `FK_remuneration_career_personalia` (`personalia_id`),
89 CONSTRAINT `FK_remuneration_career_departments` FOREIGN KEY (`departement_id`) REFERENCES `departments` (`id`),
90 CONSTRAINT `FK_remuneration_career_personalia` FOREIGN KEY (`personalia_id`) REFERENCES `personalia` (`id`),
91 CONSTRAINT `FK_remuneration_career_positions` FOREIGN KEY (`position_id`) REFERENCES `positions` (`id`)
92) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
93
94-- Dumping data for table pcm_hris.non_remuneration_career: ~0 rows (approximately)
95/*!40000 ALTER TABLE `non_remuneration_career` DISABLE KEYS */;
96INSERT INTO `non_remuneration_career` (`id`, `code`, `employee_status`, `type`, `personalia_id`, `position_id`, `departement_id`, `grade`, `group`, `effectve_date`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
97 (1, 'S6EFIZXVS0', 'tetap', 'baru rekrut', 1, 2, 1, 'golongan a', 'l/p', '2018-10-01 00:00:00', '2018-10-20 17:43:56', '2018-10-20 19:15:09', NULL, 'super@gmail.com', 'super@gmail.com', NULL);
98/*!40000 ALTER TABLE `non_remuneration_career` ENABLE KEYS */;
99
100-- Dumping structure for table pcm_hris.non_remuneration_career_history
101CREATE TABLE IF NOT EXISTS `non_remuneration_career_history` (
102 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
103 `code` varchar(20) NOT NULL,
104 `employee_status` varchar(100) NOT NULL,
105 `type` varchar(100) NOT NULL,
106 `personalia_id` int(10) unsigned NOT NULL,
107 `position_id` int(11) NOT NULL,
108 `departement_id` int(11) NOT NULL,
109 `grade` varchar(50) NOT NULL,
110 `group` varchar(50) NOT NULL,
111 `effectve_date` datetime NOT NULL,
112 `created_at` datetime DEFAULT NULL,
113 `updated_at` datetime DEFAULT NULL,
114 `deleted_at` datetime DEFAULT NULL,
115 `created_by` varchar(50) DEFAULT NULL,
116 `updated_by` varchar(50) DEFAULT NULL,
117 `deleted_by` varchar(50) DEFAULT NULL,
118 PRIMARY KEY (`id`)
119) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
120
121-- Dumping data for table pcm_hris.non_remuneration_career_history: ~2 rows (approximately)
122/*!40000 ALTER TABLE `non_remuneration_career_history` DISABLE KEYS */;
123INSERT INTO `non_remuneration_career_history` (`id`, `code`, `employee_status`, `type`, `personalia_id`, `position_id`, `departement_id`, `grade`, `group`, `effectve_date`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
124 (1, 'HPKSOXUMOJ', 'tetap', 'baru rekrut', 1, 2, 1, 'golongan a', 'l/p', '2018-10-01 00:00:00', '2018-10-20 17:44:19', '2018-10-20 17:44:19', NULL, 'super@gmail.com', NULL, NULL),
125 (2, 'B8YPHQFNRM', 'tetap', 'baru rekrut', 1, 2, 1, 'golongan a', 'l/p', '2018-10-01 00:00:00', '2018-10-20 19:15:09', '2018-10-20 19:15:09', NULL, 'super@gmail.com', NULL, NULL);
126/*!40000 ALTER TABLE `non_remuneration_career_history` ENABLE KEYS */;
127
128-- Dumping structure for table pcm_hris.personalia
129CREATE TABLE IF NOT EXISTS `personalia` (
130 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
131 `code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
132 `nik` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
133 `nip` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
134 `fullname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
135 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
136 `no_telp` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
137 `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
138 `emergency_contact_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
139 `emergency_contact_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
140 `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
141 `status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
142 `started_date` datetime DEFAULT NULL,
143 `place_of_birth` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
144 `date_of_birth` datetime DEFAULT NULL,
145 `religion` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
146 `last_education` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
147 `name_of_educational_institution` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
148 `study_program` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
149 `marital_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
150 `wife_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
151 `created_at` datetime DEFAULT NULL,
152 `updated_at` datetime DEFAULT NULL,
153 `deleted_at` datetime DEFAULT NULL,
154 `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
155 `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
156 `deleted_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
157 PRIMARY KEY (`id`),
158 UNIQUE KEY `email` (`email`),
159 UNIQUE KEY `nip` (`nip`),
160 UNIQUE KEY `nik` (`nik`)
161) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
162
163-- Dumping data for table pcm_hris.personalia: ~0 rows (approximately)
164/*!40000 ALTER TABLE `personalia` DISABLE KEYS */;
165INSERT INTO `personalia` (`id`, `code`, `nik`, `nip`, `fullname`, `email`, `no_telp`, `address`, `emergency_contact_name`, `emergency_contact_phone`, `image`, `status`, `started_date`, `place_of_birth`, `date_of_birth`, `religion`, `last_education`, `name_of_educational_institution`, `study_program`, `marital_status`, `wife_name`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
166 (1, 'TRBPZC6XJD', '655765', '545445', 'yjfyufyu', 'anang@gmail.com', '2378297397', 'ekhkehkfje', 'kjkjhkj', '7637263623', NULL, 'Active', '2018-10-24 00:00:00', 'jakarta', '2018-10-29 00:00:00', 'Katolik', 'SD', 'hghghgh', 'hhghsgh', 'Menikah', 'jjgds', '2018-10-20 17:11:50', '2018-10-20 20:47:48', NULL, 'super@gmail.com', 'super@gmail.com', NULL);
167/*!40000 ALTER TABLE `personalia` ENABLE KEYS */;
168
169-- Dumping structure for table pcm_hris.personalia_attachment
170CREATE TABLE IF NOT EXISTS `personalia_attachment` (
171 `id` int(11) NOT NULL AUTO_INCREMENT,
172 `code` varchar(50) NOT NULL,
173 `personalia_id` int(11) unsigned NOT NULL,
174 `curriculum_vitae` varchar(255) NOT NULL,
175 `identity_card` varchar(255) NOT NULL,
176 `family_card` varchar(255) NOT NULL,
177 `other_file` varchar(255) DEFAULT NULL,
178 `created_at` datetime DEFAULT NULL,
179 `updated_at` datetime DEFAULT NULL,
180 `deleted_at` datetime DEFAULT NULL,
181 `created_by` varchar(50) DEFAULT NULL,
182 `updated_by` varchar(50) DEFAULT NULL,
183 `deleted_by` varchar(50) DEFAULT NULL,
184 PRIMARY KEY (`id`),
185 KEY `FK_personalia_attachment_personalia` (`personalia_id`),
186 CONSTRAINT `FK_personalia_attachment_personalia` FOREIGN KEY (`personalia_id`) REFERENCES `personalia` (`id`)
187) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
188
189-- Dumping data for table pcm_hris.personalia_attachment: ~0 rows (approximately)
190/*!40000 ALTER TABLE `personalia_attachment` DISABLE KEYS */;
191INSERT INTO `personalia_attachment` (`id`, `code`, `personalia_id`, `curriculum_vitae`, `identity_card`, `family_card`, `other_file`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
192 (1, '6YPRFEAMMB', 1, 'Attachment/545445_yjfyufyu/20181020/yyge2jwaf8us45ioukvv.jpg', 'Attachment/545445_yjfyufyu/20181020/aoruysgurimao83gh0bc.png', 'Attachment/545445_yjfyufyu/20181020/4lgyxwxbqsvuafkwe8ow.jpg', 'Attachment/545445_yjfyufyu/20181020/brdr1by3jk7nnnazrag6.png', '2018-10-20 17:11:50', '2018-10-20 17:11:50', NULL, NULL, NULL, NULL);
193/*!40000 ALTER TABLE `personalia_attachment` ENABLE KEYS */;
194
195-- Dumping structure for table pcm_hris.remuneration_career
196CREATE TABLE IF NOT EXISTS `remuneration_career` (
197 `id` int(11) NOT NULL AUTO_INCREMENT,
198 `code` varchar(20) NOT NULL,
199 `personalia_id` int(11) unsigned NOT NULL,
200 `basic_salary_option` bit(1) NOT NULL DEFAULT b'0',
201 `allowance_option` bit(1) NOT NULL DEFAULT b'0',
202 `bonus_option` bit(1) NOT NULL DEFAULT b'0',
203 `basic_salary` bigint(20) NOT NULL,
204 `overtime` bigint(20) NOT NULL,
205 `meal_allowance` bigint(20) NOT NULL,
206 `transport_money` bigint(20) NOT NULL,
207 `other` bigint(20) DEFAULT NULL,
208 `created_at` datetime DEFAULT NULL,
209 `updated_at` datetime DEFAULT NULL,
210 `deleted_at` datetime DEFAULT NULL,
211 `created_by` varchar(50) DEFAULT NULL,
212 `updated_by` varchar(50) DEFAULT NULL,
213 `deleted_by` varchar(50) DEFAULT NULL,
214 PRIMARY KEY (`id`)
215) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
216
217-- Dumping data for table pcm_hris.remuneration_career: ~0 rows (approximately)
218/*!40000 ALTER TABLE `remuneration_career` DISABLE KEYS */;
219INSERT INTO `remuneration_career` (`id`, `code`, `personalia_id`, `basic_salary_option`, `allowance_option`, `bonus_option`, `basic_salary`, `overtime`, `meal_allowance`, `transport_money`, `other`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
220 (1, 'PO87UURLX9', 1, b'1', b'1', b'1', 1, 2, 3, 4, 5, '2018-10-20 19:15:57', '2018-10-20 19:19:20', NULL, 'super@gmail.com', 'super@gmail.com', NULL);
221/*!40000 ALTER TABLE `remuneration_career` ENABLE KEYS */;
222
223-- Dumping structure for table pcm_hris.remuneration_career_history
224CREATE TABLE IF NOT EXISTS `remuneration_career_history` (
225 `id` int(11) NOT NULL AUTO_INCREMENT,
226 `code` varchar(20) NOT NULL,
227 `personalia_id` int(11) unsigned NOT NULL,
228 `basic_salary_option` bit(1) NOT NULL DEFAULT b'0',
229 `allowance_option` bit(1) NOT NULL DEFAULT b'0',
230 `bonus_option` bit(1) NOT NULL DEFAULT b'0',
231 `basic_salary` bigint(20) NOT NULL,
232 `overtime` bigint(20) NOT NULL,
233 `meal_allowance` bigint(20) NOT NULL,
234 `transport_money` bigint(20) NOT NULL,
235 `other` bigint(20) DEFAULT NULL,
236 `created_at` datetime DEFAULT NULL,
237 `updated_at` datetime DEFAULT NULL,
238 `deleted_at` datetime DEFAULT NULL,
239 `created_by` varchar(50) DEFAULT NULL,
240 `updated_by` varchar(50) DEFAULT NULL,
241 `deleted_by` varchar(50) DEFAULT NULL,
242 PRIMARY KEY (`id`)
243) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
244
245-- Dumping data for table pcm_hris.remuneration_career_history: ~0 rows (approximately)
246/*!40000 ALTER TABLE `remuneration_career_history` DISABLE KEYS */;
247INSERT INTO `remuneration_career_history` (`id`, `code`, `personalia_id`, `basic_salary_option`, `allowance_option`, `bonus_option`, `basic_salary`, `overtime`, `meal_allowance`, `transport_money`, `other`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES
248 (1, 'YGGD5S3LY6', 1, b'1', b'1', b'1', 1, 2, 3, 4, 5, '2018-10-20 19:19:20', '2018-10-20 19:19:20', NULL, NULL, NULL, NULL);
249/*!40000 ALTER TABLE `remuneration_career_history` ENABLE KEYS */;
250
251/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
252/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
253/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;