1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
delimiter $$
CREATE TABLE `client_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(45) DEFAULT NULL,
`address_id` int(11) DEFAULT NULL,
`contact_1` bigint(20) DEFAULT NULL,
`contact_2` bigint(20) DEFAULT NULL,
`contact_3` bigint(20) DEFAULT NULL,
`opening_balance` decimal(9,2) DEFAULT NULL,
`opening_balance_type` varchar(45) DEFAULT NULL,
`lock_ind` varchar(10) DEFAULT NULL,
`created_date` datetime DEFAULT NULL,
`updated_date` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_address_id` (`address_id`),
CONSTRAINT `fk_address_id` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1$$
delimiter $$
CREATE TABLE `address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`address1` varchar(45) NOT NULL,
`address2` varchar(45) DEFAULT NULL,
`city_id` int(11) DEFAULT NULL,
`state_id` int(11) DEFAULT NULL,
`created_date` datetime DEFAULT NULL,
`update_date` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `city_fk_id_idx` (`id`),
KEY `fk_city_id` (`city_id`),
CONSTRAINT `fk_city_id` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1$$
delimiter $$
CREATE TABLE `vehicle_owner` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(45) DEFAULT NULL,
`address_id` int(11) DEFAULT NULL,
`contact_1` bigint(20) DEFAULT NULL,
`contact_2` bigint(20) DEFAULT NULL,
`contact_3` bigint(20) DEFAULT NULL,
`opening_balance` decimal(9,2) DEFAULT NULL,
`opening_balance_type` varchar(45) DEFAULT NULL,
`lock_ind` varchar(45) DEFAULT NULL,
`created_date` datetime DEFAULT NULL,
`updated_date` datetime DEFAULT NULL,
`updated_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_addr_id` (`address_id`),
CONSTRAINT `fk_addr_id` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8$$
|