CREATE TABLE address_types(
id		INTEGER PRIMARY KEY,
literall	Varchar(30) NOT NULL UNIQUE);

CREATE TABLE address(
id				INTEGER PRIMARY KEY,
address_type_id 	INTEGER NOT NULL ,
city				VARCHAR(30) NOT NULL,
state			VARCHAR(30) NOT NULL,
zip				VARCHAR(30) NOT NULL,
residiential 		VARCHAR(30) NOT NULL,
CONSTRAINT address_to_type FOREIGN KEY (address_type_id) REFERENCES address_types(id)
);

CREATE TABLE stores (
id 				INTEGER PRIMARY KEY,
name				VARCHAR(30) NOT NULL,
address_id		INTEGER NOT NULL,
tax_percentage		DECIMAL(10,2) NOT NULL,
CONSTRAINT check_name_length CHECK(LENGTH(name) > 3),
CONSTRAINT address_id_to_address FOREIGN KEY (address_id) REFERENCES address(id)
);

CREATE TABLE employee_types(
id 				INTEGER PRIMARY KEY,
literall			VARCHAR(30) NOT NULL
);