yuFrKqc8

1Schema for Inspection/Exam Questions/Answers with scoring
2CREATE TABLE IF NOT EXISTS inspection(
3id mediumint(8) unsigned not null auto_increment PRIMARY KEY,
4store_id mediumint(8) unsigned not null,
5inspection_id mediumint(8) unsigned not null,
6date_created datetime,
7date_modified timestamp,
8INDEX IDX_STORE(store_id),
9INDEX IDX_inspection(inspection_id),
10FOREIGN KEY (store_id) REFERENCES store (store_id)ON DELETE CASCADE,
11FOREIGN KEY (inspection_id) REFERENCES inspection (inspection_id)ON DELETE CASCADE)
12
13CREATE TABLE IF NOT EXISTS input_type(
14input_type_id tinyint(4) unsigned not null auto_increment PRIMARY KEY,
15input_type_name varchar(255),
16date_created datetime,
17date_modified timestamp)
18
19CREATE TABLE IF NOT EXISTS inspection_question(
20question_id mediumint(8) unsigned not null auto_increment PRIMARY KEY,
21question text,
22input_type_id mediumint(8),
23date_created datetime,
24date_modified timestamp)
25CREATE TABLE IF NOT EXISTS inspection_option(
26option_id,
27value)