· 4 years ago · Aug 01, 2021, 09:18 AM
1DROP TABLE IF EXISTS historycustomer;
2DROP TABLE IF EXISTS historycustomershm;
3DROP TABLE IF EXISTS historycustomerbpkb;
4DROP TABLE IF EXISTS historycustomerattachment;
5CREATE TABLE `historycustomer` (
6 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
7 `idcustomer` INT(11) NOT NULL,
8 `company` VARCHAR(50) NOT NULL COLLATE 'utf8_general_ci',
9 `accno` VARCHAR(50) NOT NULL COLLATE 'utf8_general_ci',
10 `accountname` VARCHAR(255) NOT NULL COLLATE 'utf8_general_ci',
11 `custno` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
12 `fotocustomer` TEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci',
13 `photocustomer` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
14 `custtype` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
15 `gender` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
16 `maritalstatus` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
17 `birthdate` DATE NOT NULL,
18 `birthplace` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
19 `custaddress` TEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci',
20 `custphoneno` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
21 `mobileno` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
22 `mobileno2` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
23 `negativestatus` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
24 `negativedesc` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
25 `relativename` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
26 `relativetype` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
27 `relativeaddress` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
28 `relativephone` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
29 `spousename` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
30 `spousebirthdate` DATE NOT NULL,
31 `spousebirthplace` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
32 `spouseaddress` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
33 `spousemobileno` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
34 `spouseoffice` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
35 `spouseofficephone` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
36 `spousejobname` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
37 `companyname` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
38 `companybusiness` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
39 `companyaddress` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
40 `companyphone` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
41 `companyfax` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
42 `jobname` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
43 `merkname` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
44 `modelname` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
45 `typename` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
46 `categoryname` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
47 `caryear` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
48 `color` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
49 `chassisno` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
50 `engineno` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
51 `policeno` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
52 `route` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
53 `collbussname` VARCHAR(255) NULL DEFAULT NULL COMMENT '1' COLLATE 'utf8_general_ci',
54 `latitude` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
55 `longitude` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
56 `custemail` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
57 `collectiongroupcode` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
58 `collectiontypecode` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
59 `collectionbucketcode` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
60 `collectionmodulecode` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
61 `is_active` TINYINT(1) NOT NULL DEFAULT '1',
62 `idparent` INT(11) NULL DEFAULT NULL,
63 `datetime` DATETIME NOT NULL,
64 `userid` INT(11) NOT NULL,
65 `created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
66 `updated_at` DATETIME NOT NULL,
67 PRIMARY KEY (`id`) USING BTREE
68)
69COLLATE='utf8_general_ci'
70ENGINE=InnoDB
71AUTO_INCREMENT=1
72;
73
74CREATE TABLE `historycustomerattachment` (
75 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
76 `idcollateral` INT(11) NOT NULL,
77 `type` ENUM('shm','bpkb') NOT NULL COLLATE 'utf8_general_ci',
78 `storagetype` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
79 `path` TEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci',
80 `filename` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
81 `description` TEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci',
82 `datetime` DATETIME NOT NULL,
83 `created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
84 `updated_at` DATETIME NOT NULL,
85 PRIMARY KEY (`id`) USING BTREE
86)
87COLLATE='utf8_general_ci'
88ENGINE=InnoDB
89AUTO_INCREMENT=1
90;
91
92CREATE TABLE `historycustomerbpkb` (
93 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
94 `idhistorycustomer` INT(11) NOT NULL,
95 `company` VARCHAR(50) NOT NULL COLLATE 'utf8_general_ci',
96 `accno` VARCHAR(50) NOT NULL COLLATE 'utf8_general_ci',
97 `category` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
98 `debiturno` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
99 `namadebitur` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
100 `seq` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
101 `lokasiagunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
102 `jenisagunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
103 `bpkbasli` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
104 `nobpkbinvoice` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
105 `norangka` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
106 `nomesin` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
107 `merk` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
108 `model` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
109 `jenis` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
110 `tahun` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
111 `nopolisi` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
112 `detailagunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
113 `namapemilikagunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
114 `hubungandengandebitur` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
115 `collateralissue` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
116 `statusjaminan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
117 `idparent` INT(11) NULL DEFAULT NULL,
118 `datetime` DATETIME NOT NULL,
119 `created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
120 `updated_at` DATETIME NOT NULL,
121 PRIMARY KEY (`id`) USING BTREE
122)
123COLLATE='utf8_general_ci'
124ENGINE=InnoDB
125AUTO_INCREMENT=1
126;
127
128CREATE TABLE `historycustomershm` (
129 `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
130 `idshm` INT(11) NULL DEFAULT NULL,
131 `idhistorycustomer` INT(11) NOT NULL,
132 `company` VARCHAR(50) NOT NULL COLLATE 'utf8_general_ci',
133 `accno` VARCHAR(50) NOT NULL COLLATE 'utf8_general_ci',
134 `category` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
135 `debiturno` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
136 `namadebitur` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
137 `seq` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
138 `lokasiagunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
139 `jenisagunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
140 `luastanah` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
141 `luasbangunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
142 `jeniskepimilikan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
143 `nosertifikat` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
144 `alamatlokasiagunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
145 `koordinatlokasiagunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
146 `nilaipasar` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
147 `nilaihaktanggungan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
148 `nilailikuidasiagunan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
149 `tanggalappraisal` DATE NULL DEFAULT NULL,
150 `kjpp` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
151 `lelangprogress` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
152 `tanggalpenjualan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
153 `masaberlakukepemilikan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
154 `statusjaminan` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
155 `idparent` INT(11) NULL DEFAULT NULL,
156 `datetime` DATETIME NOT NULL,
157 `created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
158 `updated_at` DATETIME NOT NULL,
159 PRIMARY KEY (`id`) USING BTREE
160)
161COLLATE='utf8_general_ci'
162ENGINE=InnoDB
163AUTO_INCREMENT=1
164;