· 8 years ago · Mar 05, 2018, 03:24 AM
1/*
2SQLyog Ultimate v12.09 (64 bit)
3MySQL - 5.6.37 : Database - etracs_image
4*********************************************************************
5*/
6
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
16CREATE DATABASE /*!32312 IF NOT EXISTS*/`etracs_image` /*!40100 DEFAULT CHARACTER SET latin1 */;
17
18USE `etracs_image`;
19
20/*Table structure for table `account` */
21
22DROP TABLE IF EXISTS `account`;
23
24CREATE TABLE `account` (
25 `objid` varchar(50) NOT NULL,
26 `parentid` varchar(50) DEFAULT NULL,
27 `state` varchar(10) DEFAULT NULL,
28 `chartid` varchar(50) DEFAULT NULL,
29 `code` varchar(50) DEFAULT NULL,
30 `title` varchar(255) DEFAULT NULL,
31 `type` varchar(20) DEFAULT NULL,
32 `acctgroup` varchar(50) DEFAULT NULL,
33 `target` decimal(12,2) DEFAULT NULL,
34 PRIMARY KEY (`objid`),
35 KEY `ix_parentid` (`parentid`),
36 KEY `ix_title` (`title`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8;
38
39/*Table structure for table `account_incometarget` */
40
41DROP TABLE IF EXISTS `account_incometarget`;
42
43CREATE TABLE `account_incometarget` (
44 `objid` varchar(50) NOT NULL,
45 `year` int(11) NOT NULL,
46 `target` decimal(18,2) DEFAULT NULL,
47 PRIMARY KEY (`objid`,`year`),
48 CONSTRAINT `account_incometarget_ibfk_1` FOREIGN KEY (`objid`) REFERENCES `account` (`objid`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8;
50
51/*Table structure for table `af` */
52
53DROP TABLE IF EXISTS `af`;
54
55CREATE TABLE `af` (
56 `objid` varchar(50) NOT NULL,
57 `title` varchar(255) DEFAULT NULL,
58 `usetype` varchar(50) DEFAULT NULL,
59 `serieslength` int(11) DEFAULT NULL,
60 `system` int(11) DEFAULT NULL,
61 `denomination` decimal(10,2) DEFAULT NULL,
62 `formtype` varchar(50) DEFAULT NULL,
63 PRIMARY KEY (`objid`)
64) ENGINE=InnoDB DEFAULT CHARSET=utf8;
65
66/*Table structure for table `af_control` */
67
68DROP TABLE IF EXISTS `af_control`;
69
70CREATE TABLE `af_control` (
71 `objid` varchar(50) NOT NULL,
72 `afid` varchar(50) DEFAULT NULL,
73 `txnmode` varchar(10) DEFAULT NULL,
74 `assignee_objid` varchar(50) DEFAULT NULL,
75 `assignee_name` varchar(50) DEFAULT NULL,
76 `startseries` int(11) DEFAULT NULL,
77 `currentseries` int(11) DEFAULT NULL,
78 `endseries` int(11) DEFAULT NULL,
79 `active` int(11) DEFAULT NULL,
80 `org_objid` varchar(50) DEFAULT NULL,
81 `org_name` varchar(50) DEFAULT NULL,
82 `fund_objid` varchar(50) DEFAULT NULL,
83 `fund_title` varchar(200) DEFAULT NULL,
84 `stubno` int(11) DEFAULT NULL,
85 `owner_objid` varchar(50) DEFAULT NULL,
86 `owner_name` varchar(255) DEFAULT NULL,
87 `prefix` varchar(10) DEFAULT NULL,
88 `suffix` varchar(10) DEFAULT NULL,
89 PRIMARY KEY (`objid`),
90 KEY `ix_org_objid` (`org_objid`),
91 KEY `ix_org_name` (`org_name`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8;
93
94/*Table structure for table `af_inventory` */
95
96DROP TABLE IF EXISTS `af_inventory`;
97
98CREATE TABLE `af_inventory` (
99 `objid` varchar(50) NOT NULL,
100 `afid` varchar(50) DEFAULT NULL,
101 `respcenter_objid` varchar(50) DEFAULT NULL,
102 `respcenter_name` varchar(50) DEFAULT NULL,
103 `respcenter_type` varchar(25) DEFAULT NULL,
104 `startseries` int(11) DEFAULT NULL,
105 `endseries` int(11) DEFAULT NULL,
106 `currentseries` int(11) DEFAULT NULL,
107 `startstub` int(11) DEFAULT NULL,
108 `endstub` int(11) DEFAULT NULL,
109 `currentstub` int(11) DEFAULT NULL,
110 `prefix` varchar(10) DEFAULT NULL,
111 `suffix` varchar(10) DEFAULT NULL,
112 `unit` varchar(10) DEFAULT NULL,
113 `qtyin` int(11) DEFAULT NULL,
114 `qtyout` int(11) DEFAULT NULL,
115 `qtycancelled` int(11) DEFAULT NULL,
116 `qtybalance` int(11) DEFAULT NULL,
117 `currentlineno` int(11) DEFAULT NULL,
118 `cost` decimal(10,2) DEFAULT NULL,
119 PRIMARY KEY (`objid`),
120 KEY `ix_afid` (`afid`),
121 KEY `ix_respcenter_objid` (`respcenter_objid`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8;
123
124/*Table structure for table `af_inventory_detail` */
125
126DROP TABLE IF EXISTS `af_inventory_detail`;
127
128CREATE TABLE `af_inventory_detail` (
129 `objid` varchar(50) NOT NULL,
130 `controlid` varchar(50) DEFAULT NULL,
131 `lineno` int(11) DEFAULT NULL,
132 `refid` varchar(50) DEFAULT NULL,
133 `refno` varchar(50) DEFAULT NULL,
134 `reftype` varchar(50) DEFAULT NULL,
135 `refdate` datetime DEFAULT NULL,
136 `txndate` datetime DEFAULT NULL,
137 `txntype` varchar(25) DEFAULT NULL,
138 `receivedstartseries` int(11) DEFAULT NULL,
139 `receivedendseries` int(11) DEFAULT NULL,
140 `beginstartseries` int(11) DEFAULT NULL,
141 `beginendseries` int(11) DEFAULT NULL,
142 `issuedstartseries` int(11) DEFAULT NULL,
143 `issuedendseries` int(11) DEFAULT NULL,
144 `endingstartseries` int(11) DEFAULT NULL,
145 `endingendseries` int(11) DEFAULT NULL,
146 `cancelledstartseries` int(11) DEFAULT NULL,
147 `cancelledendseries` int(11) DEFAULT NULL,
148 `qtyreceived` int(11) DEFAULT NULL,
149 `qtybegin` int(11) DEFAULT NULL,
150 `qtyissued` int(11) DEFAULT NULL,
151 `qtyending` int(11) DEFAULT NULL,
152 `qtycancelled` int(11) DEFAULT NULL,
153 `remarks` varchar(255) DEFAULT NULL,
154 `cost` decimal(10,2) DEFAULT NULL,
155 PRIMARY KEY (`objid`),
156 KEY `FK_afcontrol_detail_afcontrol` (`controlid`),
157 KEY `ix_refid` (`refid`),
158 KEY `ix_refno` (`refno`),
159 KEY `ix_refdate` (`refdate`),
160 KEY `ix_txndate` (`txndate`),
161 CONSTRAINT `af_inventory_detail_ibfk_1` FOREIGN KEY (`controlid`) REFERENCES `af_inventory` (`objid`)
162) ENGINE=InnoDB DEFAULT CHARSET=utf8;
163
164/*Table structure for table `af_inventory_detail_cancelseries` */
165
166DROP TABLE IF EXISTS `af_inventory_detail_cancelseries`;
167
168CREATE TABLE `af_inventory_detail_cancelseries` (
169 `objid` varchar(50) NOT NULL,
170 `series` int(11) NOT NULL,
171 `controlid` varchar(50) DEFAULT NULL,
172 PRIMARY KEY (`objid`,`series`),
173 KEY `ix_controlid` (`controlid`)
174) ENGINE=InnoDB DEFAULT CHARSET=utf8;
175
176/*Table structure for table `af_inventory_return` */
177
178DROP TABLE IF EXISTS `af_inventory_return`;
179
180CREATE TABLE `af_inventory_return` (
181 `objid` varchar(50) NOT NULL,
182 `dtfiled` datetime NOT NULL,
183 PRIMARY KEY (`objid`),
184 KEY `ix_dtfiled` (`dtfiled`)
185) ENGINE=InnoDB DEFAULT CHARSET=utf8;
186
187/*Table structure for table `ap` */
188
189DROP TABLE IF EXISTS `ap`;
190
191CREATE TABLE `ap` (
192 `objid` varchar(50) NOT NULL,
193 `subacctid` varchar(50) DEFAULT NULL,
194 `subacctclass` varchar(50) DEFAULT NULL,
195 `subaccttitle` varchar(50) DEFAULT NULL,
196 `sltype` varchar(10) DEFAULT NULL,
197 `totaldr` decimal(10,2) DEFAULT NULL,
198 `totalcr` decimal(10,2) DEFAULT NULL,
199 `balance` decimal(10,2) DEFAULT NULL,
200 PRIMARY KEY (`objid`)
201) ENGINE=InnoDB DEFAULT CHARSET=utf8;
202
203/*Table structure for table `ap_detail` */
204
205DROP TABLE IF EXISTS `ap_detail`;
206
207CREATE TABLE `ap_detail` (
208 `objid` varchar(50) NOT NULL,
209 `parentid` varchar(50) DEFAULT NULL,
210 `txndate` datetime DEFAULT NULL,
211 `txnrefid` varchar(50) DEFAULT NULL,
212 `txnrefno` varchar(50) DEFAULT NULL,
213 `txnreftype` varchar(50) DEFAULT NULL,
214 `particulars` varchar(255) DEFAULT NULL,
215 `dr` decimal(16,2) DEFAULT NULL,
216 `cr` decimal(16,2) DEFAULT NULL,
217 PRIMARY KEY (`objid`),
218 KEY `ap_detail_ap` (`parentid`),
219 CONSTRAINT `ap_detail_ibfk_1` FOREIGN KEY (`parentid`) REFERENCES `ap` (`objid`)
220) ENGINE=InnoDB DEFAULT CHARSET=utf8;
221
222/*Table structure for table `ar` */
223
224DROP TABLE IF EXISTS `ar`;
225
226CREATE TABLE `ar` (
227 `objid` varchar(50) NOT NULL,
228 `subacctid` varchar(50) DEFAULT NULL,
229 `subacctclass` varchar(50) DEFAULT NULL,
230 `subaccttitle` varchar(50) DEFAULT NULL,
231 `sltype` varchar(10) DEFAULT NULL,
232 `totaldr` decimal(10,2) DEFAULT NULL,
233 `totalcr` decimal(10,2) DEFAULT NULL,
234 `balance` decimal(10,2) DEFAULT NULL,
235 PRIMARY KEY (`objid`)
236) ENGINE=InnoDB DEFAULT CHARSET=utf8;
237
238/*Table structure for table `ar_detail` */
239
240DROP TABLE IF EXISTS `ar_detail`;
241
242CREATE TABLE `ar_detail` (
243 `objid` varchar(50) NOT NULL,
244 `parentid` varchar(50) DEFAULT NULL,
245 `txndate` datetime DEFAULT NULL,
246 `txnrefid` varchar(50) DEFAULT NULL,
247 `txnrefno` varchar(50) DEFAULT NULL,
248 `txnreftype` varchar(50) DEFAULT NULL,
249 `particulars` varchar(255) DEFAULT NULL,
250 `dr` decimal(16,2) DEFAULT NULL,
251 `cr` decimal(16,2) DEFAULT NULL,
252 PRIMARY KEY (`objid`),
253 KEY `ar_detail_ar` (`parentid`),
254 CONSTRAINT `ar_detail_ibfk_1` FOREIGN KEY (`parentid`) REFERENCES `ar` (`objid`)
255) ENGINE=InnoDB DEFAULT CHARSET=utf8;
256
257/*Table structure for table `assessmentnotice` */
258
259DROP TABLE IF EXISTS `assessmentnotice`;
260
261CREATE TABLE `assessmentnotice` (
262 `objid` varchar(50) NOT NULL,
263 `state` varchar(15) NOT NULL,
264 `txnno` varchar(25) NOT NULL,
265 `txndate` datetime DEFAULT NULL,
266 `taxpayerid` varchar(50) NOT NULL,
267 `taxpayername` text NOT NULL,
268 `taxpayeraddress` varchar(150) NOT NULL,
269 `createdbyid` varchar(50) DEFAULT NULL,
270 `createdbyname` varchar(100) NOT NULL,
271 `createdbytitle` varchar(50) NOT NULL,
272 `approvedbyid` varchar(50) DEFAULT NULL,
273 `approvedbyname` varchar(100) DEFAULT NULL,
274 `approvedbytitle` varchar(50) DEFAULT NULL,
275 `dtdelivered` datetime DEFAULT NULL,
276 `receivedby` varchar(150) DEFAULT NULL,
277 `remarks` text,
278 `assessmentyear` int(11) DEFAULT NULL,
279 `administrator_name` varchar(150) DEFAULT NULL,
280 `administrator_address` varchar(150) DEFAULT NULL,
281 PRIMARY KEY (`objid`),
282 KEY `ix_assessmentnotice_receivedby` (`receivedby`),
283 KEY `ix_assessmentnotice_state` (`state`),
284 KEY `ix_assessmentnotice_taxpayerid` (`taxpayerid`),
285 KEY `ix_assessmentnotice_txnno` (`txnno`)
286) ENGINE=InnoDB DEFAULT CHARSET=utf8;
287
288/*Table structure for table `assessmentnoticeitem` */
289
290DROP TABLE IF EXISTS `assessmentnoticeitem`;
291
292CREATE TABLE `assessmentnoticeitem` (
293 `objid` varchar(50) NOT NULL,
294 `assessmentnoticeid` varchar(50) NOT NULL,
295 `faasid` varchar(50) NOT NULL,
296 PRIMARY KEY (`objid`),
297 KEY `FK_assessmentnoticeitem_assessmentnotice` (`assessmentnoticeid`),
298 KEY `FK_assessmentnoticeitem_faas` (`faasid`),
299 CONSTRAINT `assessmentnoticeitem_ibfk_1` FOREIGN KEY (`assessmentnoticeid`) REFERENCES `assessmentnotice` (`objid`),
300 CONSTRAINT `assessmentnoticeitem_ibfk_2` FOREIGN KEY (`faasid`) REFERENCES `faas` (`objid`)
301) ENGINE=InnoDB DEFAULT CHARSET=utf8;
302
303/*Table structure for table `bank` */
304
305DROP TABLE IF EXISTS `bank`;
306
307CREATE TABLE `bank` (
308 `objid` varchar(50) NOT NULL,
309 `state` varchar(10) DEFAULT NULL,
310 `code` varchar(50) NOT NULL,
311 `name` varchar(100) NOT NULL,
312 `branchname` varchar(50) NOT NULL,
313 `address` varchar(255) DEFAULT NULL,
314 `manager` varchar(50) DEFAULT NULL,
315 `deposittype` varchar(50) DEFAULT NULL,
316 `depository` int(11) DEFAULT NULL,
317 PRIMARY KEY (`objid`),
318 KEY `ix_bank_state` (`state`)
319) ENGINE=InnoDB DEFAULT CHARSET=utf8;
320
321/*Table structure for table `bankaccount` */
322
323DROP TABLE IF EXISTS `bankaccount`;
324
325CREATE TABLE `bankaccount` (
326 `objid` varchar(50) NOT NULL,
327 `state` varchar(10) NOT NULL,
328 `code` varchar(50) NOT NULL,
329 `title` varchar(100) NOT NULL,
330 `description` varchar(255) DEFAULT NULL,
331 `accttype` varchar(50) NOT NULL,
332 `bank_objid` varchar(50) NOT NULL,
333 `bank_code` varchar(50) NOT NULL,
334 `bank_name` varchar(100) NOT NULL,
335 `fund_objid` varchar(50) NOT NULL,
336 `fund_code` varchar(50) NOT NULL,
337 `fund_title` varchar(50) NOT NULL,
338 `currency` varchar(10) NOT NULL,
339 `cashreport` varchar(50) DEFAULT NULL,
340 `cashbreakdownreport` varchar(50) DEFAULT NULL,
341 `checkreport` varchar(50) DEFAULT NULL,
342 `forwardbalance` decimal(16,2) DEFAULT NULL,
343 `beginbalance` decimal(16,2) DEFAULT NULL,
344 `totaldr` decimal(16,2) DEFAULT NULL,
345 `totalcr` decimal(16,2) DEFAULT NULL,
346 `endbalance` decimal(16,2) DEFAULT NULL,
347 `currentlineno` int(11) DEFAULT NULL,
348 `checkbreakdownreport` varchar(50) DEFAULT NULL,
349 PRIMARY KEY (`objid`),
350 KEY `bank_objid` (`bank_objid`),
351 KEY `fund_objid` (`fund_objid`),
352 CONSTRAINT `bankaccount_ibfk_1` FOREIGN KEY (`bank_objid`) REFERENCES `bank` (`objid`),
353 CONSTRAINT `bankaccount_ibfk_2` FOREIGN KEY (`fund_objid`) REFERENCES `fund` (`objid`)
354) ENGINE=InnoDB DEFAULT CHARSET=utf8;
355
356/*Table structure for table `bankaccount_account` */
357
358DROP TABLE IF EXISTS `bankaccount_account`;
359
360CREATE TABLE `bankaccount_account` (
361 `objid` varchar(50) NOT NULL,
362 `acctid` varchar(50) NOT NULL,
363 PRIMARY KEY (`objid`),
364 KEY `FK_bankaccount_account_account` (`acctid`),
365 CONSTRAINT `bankaccount_account_ibfk_1` FOREIGN KEY (`acctid`) REFERENCES `account` (`objid`),
366 CONSTRAINT `bankaccount_account_ibfk_2` FOREIGN KEY (`objid`) REFERENCES `bankaccount` (`objid`)
367) ENGINE=InnoDB DEFAULT CHARSET=utf8;
368
369/*Table structure for table `bankaccount_entry` */
370
371DROP TABLE IF EXISTS `bankaccount_entry`;
372
373CREATE TABLE `bankaccount_entry` (
374 `objid` varchar(50) NOT NULL,
375 `parentid` varchar(50) DEFAULT NULL,
376 `txndate` datetime DEFAULT NULL,
377 `refdate` datetime DEFAULT NULL,
378 `refid` varchar(50) DEFAULT NULL,
379 `refno` varchar(50) DEFAULT NULL,
380 `reftype` varchar(50) DEFAULT NULL,
381 `particulars` varchar(255) DEFAULT NULL,
382 `dr` decimal(16,2) DEFAULT NULL,
383 `cr` decimal(16,2) DEFAULT NULL,
384 `runbalance` decimal(16,2) DEFAULT NULL,
385 `lineno` int(11) DEFAULT NULL,
386 `postingrefid` varchar(50) DEFAULT NULL,
387 PRIMARY KEY (`objid`),
388 KEY `bankaccount_parent` (`parentid`),
389 KEY `idx_bankaccount_refid` (`refid`),
390 CONSTRAINT `bankaccount_entry_ibfk_1` FOREIGN KEY (`parentid`) REFERENCES `bankaccount` (`objid`)
391) ENGINE=InnoDB DEFAULT CHARSET=utf8;
392
393/*Table structure for table `bankdeposit` */
394
395DROP TABLE IF EXISTS `bankdeposit`;
396
397CREATE TABLE `bankdeposit` (
398 `objid` varchar(50) NOT NULL,
399 `txnno` varchar(50) DEFAULT NULL,
400 `dtposted` datetime DEFAULT NULL,
401 `cashier_objid` varchar(50) DEFAULT NULL,
402 `cashier_name` varchar(100) DEFAULT NULL,
403 `cashier_title` varchar(50) DEFAULT NULL,
404 `totalcash` decimal(16,2) DEFAULT NULL,
405 `totalnoncash` decimal(16,2) DEFAULT NULL,
406 `amount` decimal(16,2) DEFAULT NULL,
407 `validationno` varchar(50) DEFAULT NULL,
408 `validationdate` date DEFAULT NULL,
409 `state` varchar(25) DEFAULT NULL,
410 PRIMARY KEY (`objid`),
411 KEY `cashier_objid` (`cashier_objid`),
412 KEY `ix_dtposted` (`dtposted`),
413 KEY `ix_cashier_objid` (`cashier_objid`),
414 KEY `ix_cashier_name` (`cashier_name`),
415 CONSTRAINT `bankdeposit_ibfk_1` FOREIGN KEY (`cashier_objid`) REFERENCES `sys_user` (`objid`)
416) ENGINE=InnoDB DEFAULT CHARSET=utf8;
417
418/*Table structure for table `bankdeposit_entry` */
419
420DROP TABLE IF EXISTS `bankdeposit_entry`;
421
422CREATE TABLE `bankdeposit_entry` (
423 `objid` varchar(50) NOT NULL,
424 `parentid` varchar(50) NOT NULL,
425 `bankaccount_objid` varchar(50) NOT NULL,
426 `bankaccount_code` varchar(50) NOT NULL,
427 `bankaccount_title` varchar(255) NOT NULL,
428 `totalcash` decimal(16,2) NOT NULL,
429 `totalnoncash` decimal(16,2) NOT NULL,
430 `amount` decimal(16,2) NOT NULL,
431 `cashbreakdown` text NOT NULL,
432 `summaries` longtext,
433 `state` varchar(25) DEFAULT NULL,
434 `validationno` varchar(50) DEFAULT NULL,
435 `validationdate` date DEFAULT NULL,
436 PRIMARY KEY (`objid`),
437 KEY `parentid` (`parentid`),
438 KEY `bankaccount_objid` (`bankaccount_objid`),
439 CONSTRAINT `bankdeposit_entry_ibfk_1` FOREIGN KEY (`parentid`) REFERENCES `bankdeposit` (`objid`),
440 CONSTRAINT `bankdeposit_entry_ibfk_2` FOREIGN KEY (`bankaccount_objid`) REFERENCES `bankaccount` (`objid`)
441) ENGINE=InnoDB DEFAULT CHARSET=utf8;
442
443/*Table structure for table `bankdeposit_entry_check` */
444
445DROP TABLE IF EXISTS `bankdeposit_entry_check`;
446
447CREATE TABLE `bankdeposit_entry_check` (
448 `objid` varchar(50) NOT NULL,
449 `parentid` varchar(50) DEFAULT NULL,
450 PRIMARY KEY (`objid`),
451 KEY `FK_bankdeposit_check` (`parentid`),
452 CONSTRAINT `bankdeposit_entry_check_ibfk_1` FOREIGN KEY (`parentid`) REFERENCES `bankdeposit_entry` (`objid`)
453) ENGINE=InnoDB DEFAULT CHARSET=utf8;
454
455/*Table structure for table `bankdeposit_liquidation` */
456
457DROP TABLE IF EXISTS `bankdeposit_liquidation`;
458
459CREATE TABLE `bankdeposit_liquidation` (
460 `objid` varchar(50) NOT NULL,
461 `bankdepositid` varchar(50) DEFAULT NULL,
462 PRIMARY KEY (`objid`),
463 KEY `FK_bankdeposit_liquidation` (`bankdepositid`),
464 CONSTRAINT `bankdeposit_liquidation_ibfk_1` FOREIGN KEY (`bankdepositid`) REFERENCES `bankdeposit` (`objid`),
465 CONSTRAINT `bankdeposit_liquidation_ibfk_2` FOREIGN KEY (`objid`) REFERENCES `liquidation_cashier_fund` (`objid`)
466) ENGINE=InnoDB DEFAULT CHARSET=utf8;
467
468/*Table structure for table `barangay` */
469
470DROP TABLE IF EXISTS `barangay`;
471
472CREATE TABLE `barangay` (
473 `objid` varchar(50) NOT NULL,
474 `state` varchar(10) DEFAULT NULL,
475 `indexno` varchar(15) DEFAULT NULL,
476 `pin` varchar(15) DEFAULT NULL,
477 `name` varchar(50) DEFAULT NULL,
478 `previd` varchar(50) DEFAULT NULL,
479 `parentid` varchar(50) DEFAULT NULL,
480 `captain_name` varchar(100) DEFAULT NULL,
481 `captain_title` varchar(50) DEFAULT NULL,
482 `captain_office` varchar(50) DEFAULT NULL,
483 `treasurer_name` varchar(100) DEFAULT NULL,
484 `treasurer_title` varchar(50) DEFAULT NULL,
485 `treasurer_office` varchar(50) DEFAULT NULL,
486 `oldindexno` varchar(15) DEFAULT NULL,
487 `oldpin` varchar(15) DEFAULT NULL,
488 `fullname` varchar(250) DEFAULT NULL,
489 `address` varchar(250) DEFAULT NULL,
490 PRIMARY KEY (`objid`),
491 KEY `ix_lgu_barangay_indexno` (`indexno`),
492 KEY `ix_lgu_barangay_parentid` (`parentid`),
493 KEY `ix_lgu_barangay_previd` (`previd`),
494 CONSTRAINT `barangay_ibfk_1` FOREIGN KEY (`objid`) REFERENCES `sys_org` (`objid`) ON DELETE CASCADE ON UPDATE CASCADE
495) ENGINE=InnoDB DEFAULT CHARSET=utf8;
496
497/*Table structure for table `batchcapture_collection` */
498
499DROP TABLE IF EXISTS `batchcapture_collection`;
500
501CREATE TABLE `batchcapture_collection` (
502 `objid` varchar(50) NOT NULL,
503 `state` varchar(20) NOT NULL,
504 `txndate` datetime NOT NULL,
505 `defaultreceiptdate` datetime NOT NULL,
506 `txnmode` varchar(10) NOT NULL,
507 `stub` int(11) NOT NULL,
508 `formno` varchar(50) NOT NULL,
509 `formtype` varchar(10) NOT NULL,
510 `controlid` varchar(50) NOT NULL,
511 `serieslength` int(11) NOT NULL,
512 `prefix` varchar(10) DEFAULT NULL,
513 `suffix` varchar(10) DEFAULT NULL,
514 `startseries` int(11) NOT NULL,
515 `endseries` int(11) NOT NULL,
516 `totalamount` decimal(16,2) NOT NULL,
517 `totalcash` decimal(16,2) NOT NULL,
518 `totalnoncash` decimal(16,2) NOT NULL,
519 `collectiontype_objid` varchar(50) DEFAULT NULL,
520 `collectiontype_name` varchar(100) DEFAULT NULL,
521 `collector_objid` varchar(50) DEFAULT NULL,
522 `collector_name` varchar(100) DEFAULT NULL,
523 `collector_title` varchar(50) DEFAULT NULL,
524 `capturedby_objid` varchar(50) DEFAULT NULL,
525 `capturedby_name` varchar(100) DEFAULT NULL,
526 `capturedby_title` varchar(50) DEFAULT NULL,
527 `org_objid` varchar(50) NOT NULL,
528 `org_name` varchar(50) NOT NULL,
529 `postedby_objid` varchar(50) DEFAULT NULL,
530 `postedby_name` varchar(100) DEFAULT NULL,
531 `postedby_date` datetime DEFAULT NULL,
532 PRIMARY KEY (`objid`),
533 KEY `ix_batchcapture_collection_capturedbyname` (`capturedby_name`),
534 KEY `ix_batchcapture_collection_collectorname` (`collector_name`),
535 KEY `ix_batchcapture_collection_txndate` (`txndate`),
536 KEY `collector_objid` (`collector_objid`),
537 CONSTRAINT `batchcapture_collection_ibfk_1` FOREIGN KEY (`collector_objid`) REFERENCES `sys_user` (`objid`)
538) ENGINE=InnoDB DEFAULT CHARSET=utf8;
539
540/*Table structure for table `batchcapture_collection_entry` */
541
542DROP TABLE IF EXISTS `batchcapture_collection_entry`;
543
544CREATE TABLE `batchcapture_collection_entry` (
545 `objid` varchar(50) NOT NULL,
546 `parentid` varchar(50) DEFAULT NULL,
547 `receiptno` varchar(50) NOT NULL,
548 `receiptdate` datetime NOT NULL,
549 `paidby` varchar(100) NOT NULL,
550 `paidbyaddress` varchar(255) NOT NULL,
551 `amount` decimal(16,2) NOT NULL,
552 `totalcash` decimal(16,2) NOT NULL,
553 `totalnoncash` decimal(16,2) NOT NULL,
554 `series` int(11) NOT NULL,
555 `collectiontype_objid` varchar(50) DEFAULT NULL,
556 `collectiontype_name` varchar(100) DEFAULT NULL,
557 `remarks` varchar(255) DEFAULT NULL,
558 `particulars` longtext,
559 `voided` int(11) DEFAULT NULL,
560 `paymentitems` longtext,
561 PRIMARY KEY (`objid`),
562 KEY `ix_batchcapture_collection_entry_parentid` (`parentid`),
563 KEY `ix_batchcapture_collection_entry_receiptdate` (`receiptdate`),
564 KEY `ix_batchcapture_collection_entry_receiptno` (`receiptno`),
565 KEY `collectiontype_objid` (`collectiontype_objid`),
566 CONSTRAINT `batchcapture_collection_entry_ibfk_1` FOREIGN KEY (`parentid`) REFERENCES `batchcapture_collection` (`objid`),
567 CONSTRAINT `batchcapture_collection_entry_ibfk_2` FOREIGN KEY (`collectiontype_objid`) REFERENCES `collectiontype` (`objid`)
568) ENGINE=InnoDB DEFAULT CHARSET=utf8;
569
570/*Table structure for table `batchcapture_collection_entry_item` */
571
572DROP TABLE IF EXISTS `batchcapture_collection_entry_item`;
573
574CREATE TABLE `batchcapture_collection_entry_item` (
575 `objid` varchar(50) NOT NULL,
576 `parentid` varchar(50) DEFAULT NULL,
577 `item_objid` varchar(50) DEFAULT NULL,
578 `item_code` varchar(50) DEFAULT NULL,
579 `item_title` varchar(50) DEFAULT NULL,
580 `fund_objid` varchar(50) DEFAULT NULL,
581 `fund_code` varchar(50) DEFAULT NULL,
582 `fund_title` varchar(50) DEFAULT NULL,
583 `amount` decimal(16,2) DEFAULT NULL,
584 PRIMARY KEY (`objid`),
585 KEY `ix_batchcapture_collection_entry_item_item_code` (`item_code`),
586 KEY `ix_batchcapture_collection_entry_item_parentid` (`parentid`),
587 KEY `item_objid` (`item_objid`),
588 KEY `fund_objid` (`fund_objid`),
589 CONSTRAINT `batchcapture_collection_entry_item_ibfk_1` FOREIGN KEY (`parentid`) REFERENCES `batchcapture_collection_entry` (`objid`),
590 CONSTRAINT `batchcapture_collection_entry_item_ibfk_2` FOREIGN KEY (`item_objid`) REFERENCES `itemaccount` (`objid`),
591 CONSTRAINT `batchcapture_collection_entry_item_ibfk_3` FOREIGN KEY (`fund_objid`) REFERENCES `fund` (`objid`)
592) ENGINE=InnoDB DEFAULT CHARSET=utf8;
593
594/*Table structure for table `batchgr_error` */
595
596DROP TABLE IF EXISTS `batchgr_error`;
597
598CREATE TABLE `batchgr_error` (
599 `objid` varchar(50) NOT NULL,
600 `newry` int(11) DEFAULT NULL,
601 `msg` longtext,
602 `barangayid` varchar(50) DEFAULT NULL,
603 `barangay` varchar(100) DEFAULT NULL,
604 `tdno` varchar(30) DEFAULT NULL,
605 PRIMARY KEY (`objid`)
606) ENGINE=InnoDB DEFAULT CHARSET=utf8;
607
608/*Table structure for table `batchgr_items_forrevision` */
609
610DROP TABLE IF EXISTS `batchgr_items_forrevision`;
611
612CREATE TABLE `batchgr_items_forrevision` (
613 `objid` varchar(50) NOT NULL,
614 `rpuid` varchar(50) NOT NULL,
615 `realpropertyid` varchar(50) NOT NULL,
616 `barangayid` varchar(50) NOT NULL,
617 `rputype` varchar(15) NOT NULL,
618 `tdno` varchar(25) NOT NULL,
619 `fullpin` varchar(30) NOT NULL,
620 `pin` varchar(30) NOT NULL,
621 `suffix` int(11) NOT NULL,
622 PRIMARY KEY (`objid`)
623) ENGINE=InnoDB DEFAULT CHARSET=utf8;
624
625/*Table structure for table `batchgrerror` */
626
627DROP TABLE IF EXISTS `batchgrerror`;
628
629CREATE TABLE `batchgrerror` (
630 `faasid` varchar(50) NOT NULL,
631 `ry` int(11) NOT NULL,
632 `msg` longtext,
633 PRIMARY KEY (`faasid`)
634) ENGINE=InnoDB DEFAULT CHARSET=utf8;
635
636/*Table structure for table `image_chunk` */
637
638DROP TABLE IF EXISTS `image_chunk`;
639
640CREATE TABLE `image_chunk` (
641 `objid` varchar(50) NOT NULL,
642 `parentid` varchar(50) NOT NULL,
643 `fileno` int(11) NOT NULL,
644 `byte` blob NOT NULL,
645 PRIMARY KEY (`objid`)
646) ENGINE=InnoDB DEFAULT CHARSET=utf8;
647
648/*Table structure for table `image_header` */
649
650DROP TABLE IF EXISTS `image_header`;
651
652CREATE TABLE `image_header` (
653 `objid` varchar(50) NOT NULL,
654 `refid` varchar(50) NOT NULL,
655 `title` varchar(255) NOT NULL,
656 `filesize` int(255) DEFAULT NULL,
657 `extension` varchar(255) DEFAULT NULL,
658 PRIMARY KEY (`objid`)
659) ENGINE=InnoDB DEFAULT CHARSET=utf8;
660
661/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
662/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
663/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
664/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;