CREATE TABLE districts(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
name varchar(50),
region varchar(50),
created DATETIME default now(),
modified DATETIME default now()
);


CREATE TABLE counties(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
district_id INT NOT NULL, 
FOREIGN KEY district_key (district_id) REFERENCES districts(id),
created DATETIME default now(),
modified DATETIME default now()
);

CREATE TABLE sub_counties(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
county_id INT NOT NULL,
district_id INT NOT NULL, 
FOREIGN KEY district_key (district_id) REFERENCES districts(id),
FOREIGN KEY county_key (county_id) REFERENCES counties(id),
created DATETIME default now(),
modified DATETIME default now()
);

CREATE TABLE parishes(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
subcounty_id INT NOT NULL,
county_id INT NOT NULL,
district_id INT NOT NULL, 
FOREIGN KEY district_key (district_id) REFERENCES districts(id),
FOREIGN KEY county_key (county_id) REFERENCES counties(id),
FOREIGN KEY subcounty_key (subcounty_id) REFERENCES sub_counties(id),
created DATETIME default now(),
modified DATETIME default now()
);
 

CREATE TABLE villages(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
parish_id INT NOT NULL,
subcounty_id INT NOT NULL,
county_id INT NOT NULL,
district_id INT NOT NULL, 
FOREIGN KEY district_key (district_id) REFERENCES districts(id),
FOREIGN KEY county_key (county_id) REFERENCES counties(id),
FOREIGN KEY subcounty_key (subcounty_id) REFERENCES sub_counties(id),
FOREIGN KEY parish_key (parish_id) REFERENCES parishes(id),
created DATETIME default now(),
modified DATETIME default now()
);
 

CREATE TABLE families(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
village_id INT NOT NULL,
parish_id INT NOT NULL,
subcounty_id INT NOT NULL,
county_id INT NOT NULL,
district_id INT NOT NULL, 
FOREIGN KEY district_key (district_id) REFERENCES districts(id),
FOREIGN KEY county_key (county_id) REFERENCES counties(id),
FOREIGN KEY subcounty_key (subcounty_id) REFERENCES sub_counties(id),
FOREIGN KEY parish_key (parish_id) REFERENCES parishes(id),
FOREIGN KEY village_key (village_id) REFERENCES villages(id),
created DATETIME default now(),
modified DATETIME default now()
);
 

CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
userId varchar(100) unique not null,
email varchar(100) not null, 
phone varchar(100), 
photo_URL varchar(200),
district_id int,
county_id int,
subcounty_id int,
parish_id int,
village_id int,
family_id int,
token varchar(255),
role varchar(30),
active varchar(10),
FOREIGN KEY district_key (district_id) REFERENCES districts(id),
FOREIGN KEY county_key (county_id) REFERENCES counties(id),
FOREIGN KEY subcounty_key (subcounty_id) REFERENCES sub_counties(id),
FOREIGN KEY parish_key (parish_id) REFERENCES parishes(id),
FOREIGN KEY village_key (village_id) REFERENCES villages(id),
FOREIGN KEY family_key (family_id) REFERENCES families(id),
created  DATETIME default now(),
modified  DATETIME default now()
);

CREATE TABLE dhos(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
district_id int,
fname varchar(100),
lname varchar(100),
email varchar(100),
phone varchar(100),
address varchar(100),
languages varchar(200),
photo_url varchar(100),
FOREIGN KEY user_key (user_id) REFERENCES users(id),
created  DATETIME default now(),
modified  DATETIME default now()
);
 

CREATE TABLE dsfps(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
district_id int,
fname varchar(100),
lname varchar(100),
email varchar(100),
phone varchar(100),
address varchar(100),
languages varchar(200),
photo_url varchar(100),
FOREIGN KEY user_key (user_id) REFERENCES users(id),
created  DATETIME default now(),
modified  DATETIME default now()
);
 


CREATE TABLE posts(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL UNIQUE,
district_id int,
county_id int,
subcounty_id int,
parish_id int,
village_id int,
family_id int,
image_url varchar(200),
FOREIGN KEY district_key (district_id) REFERENCES districts(id),
FOREIGN KEY county_key (county_id) REFERENCES counties(id),
FOREIGN KEY subcounty_key (subcounty_id) REFERENCES sub_counties(id),
FOREIGN KEY parish_key (parish_id) REFERENCES parishes(id),
FOREIGN KEY village_key (village_id) REFERENCES villages(id),
FOREIGN KEY village_key (village_id) REFERENCES villages(id),
FOREIGN KEY user_key (user_id) REFERENCES users(id),
created  DATETIME default now(),
modified  DATETIME default now()
);

CREATE TABLE posts(
id int AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL UNIQUE,
district_id int,
county_id int,
subcounty_id int,
parish_id int,
village_id int,
family_id int,
image_url varchar(200),
FOREIGN KEY district_key (district_id) REFERENCES districts(id),
FOREIGN KEY county_key (county_id) REFERENCES counties(id),
FOREIGN KEY subcounty_key (subcounty_id) REFERENCES sub_counties(id),
FOREIGN KEY parish_key (parish_id) REFERENCES parishes(id),
FOREIGN KEY village_key (village_id) REFERENCES villages(id),
FOREIGN KEY village_key (village_id) REFERENCES villages(id),
FOREIGN KEY user_key (user_id) REFERENCES users(id),
created  DATETIME default now(),
modified  DATETIME default now()
);




https://webmail.westlake-chemical.com
info@westlake-chemical.com
sales@westlake-chemical.com
coronavirus2020