database

Schema

UML

Initialization

CATEGORY_V1

INSERT INTO CATEGORY_V1 VALUES(1,'Bills');
INSERT INTO CATEGORY_V1 VALUES(2,'Food');
INSERT INTO CATEGORY_V1 VALUES(3,'Leisure');
INSERT INTO CATEGORY_V1 VALUES(4,'Automobile');
INSERT INTO CATEGORY_V1 VALUES(5,'Education');
INSERT INTO CATEGORY_V1 VALUES(6,'Homeneeds');
INSERT INTO CATEGORY_V1 VALUES(7,'Healthcare');
INSERT INTO CATEGORY_V1 VALUES(8,'Insurance');
INSERT INTO CATEGORY_V1 VALUES(9,'Vacation');
INSERT INTO CATEGORY_V1 VALUES(10,'Taxes');
INSERT INTO CATEGORY_V1 VALUES(11,'Miscellaneous');
INSERT INTO CATEGORY_V1 VALUES(12,'Gifts');
INSERT INTO CATEGORY_V1 VALUES(13,'Income');
INSERT INTO CATEGORY_V1 VALUES(14,'Other Income');
INSERT INTO CATEGORY_V1 VALUES(15,'Other Expenses');
INSERT INTO CATEGORY_V1 VALUES(16,'Transfer');

SUBCATEGORY_V1

INSERT INTO SUBCATEGORY_V1 VALUES(1,'Telephone',1);
INSERT INTO SUBCATEGORY_V1 VALUES(2,'Electricity',1);
INSERT INTO SUBCATEGORY_V1 VALUES(3,'Gas',1);
INSERT INTO SUBCATEGORY_V1 VALUES(4,'Internet',1);
INSERT INTO SUBCATEGORY_V1 VALUES(5,'Rent',1);
INSERT INTO SUBCATEGORY_V1 VALUES(6,'Cable TV',1);
INSERT INTO SUBCATEGORY_V1 VALUES(7,'Water',1);
INSERT INTO SUBCATEGORY_V1 VALUES(8,'Groceries',2);
INSERT INTO SUBCATEGORY_V1 VALUES(9,'Dining out',2);
INSERT INTO SUBCATEGORY_V1 VALUES(10,'Movies',3);
INSERT INTO SUBCATEGORY_V1 VALUES(11,'Video Rental',3);
INSERT INTO SUBCATEGORY_V1 VALUES(12,'Magazines',3);
INSERT INTO SUBCATEGORY_V1 VALUES(13,'Maintenance',4);
INSERT INTO SUBCATEGORY_V1 VALUES(14,'Gas',4);
INSERT INTO SUBCATEGORY_V1 VALUES(15,'Parking',4);
INSERT INTO SUBCATEGORY_V1 VALUES(16,'Registration',4);
INSERT INTO SUBCATEGORY_V1 VALUES(17,'Books',5);
INSERT INTO SUBCATEGORY_V1 VALUES(18,'Tuition',5);
INSERT INTO SUBCATEGORY_V1 VALUES(19,'Others',5);
INSERT INTO SUBCATEGORY_V1 VALUES(20,'Clothing',6);
INSERT INTO SUBCATEGORY_V1 VALUES(21,'Furnishing',6);
INSERT INTO SUBCATEGORY_V1 VALUES(22,'Others',6);
INSERT INTO SUBCATEGORY_V1 VALUES(23,'Health',7);
INSERT INTO SUBCATEGORY_V1 VALUES(24,'Dental',7);
INSERT INTO SUBCATEGORY_V1 VALUES(25,'Eyecare',7);
INSERT INTO SUBCATEGORY_V1 VALUES(26,'Physician',7);
INSERT INTO SUBCATEGORY_V1 VALUES(27,'Prescriptions',7);
INSERT INTO SUBCATEGORY_V1 VALUES(28,'Auto',8);
INSERT INTO SUBCATEGORY_V1 VALUES(29,'Life',8);
INSERT INTO SUBCATEGORY_V1 VALUES(30,'Home',8);
INSERT INTO SUBCATEGORY_V1 VALUES(31,'Health',8);
INSERT INTO SUBCATEGORY_V1 VALUES(32,'Travel',9);
INSERT INTO SUBCATEGORY_V1 VALUES(33,'Lodging',9);
INSERT INTO SUBCATEGORY_V1 VALUES(34,'Sightseeing',9);
INSERT INTO SUBCATEGORY_V1 VALUES(35,'Income Tax',10);
INSERT INTO SUBCATEGORY_V1 VALUES(36,'House Tax',10);
INSERT INTO SUBCATEGORY_V1 VALUES(37,'Water Tax',10);
INSERT INTO SUBCATEGORY_V1 VALUES(38,'Others',10);
INSERT INTO SUBCATEGORY_V1 VALUES(39,'Salary',13);
INSERT INTO SUBCATEGORY_V1 VALUES(40,'Reimbursement/Refunds',13);
INSERT INTO SUBCATEGORY_V1 VALUES(41,'Investment Income',13);