CREATE TABLE person $($

person$\_$id SMALLINT UNSIGNED NOT NULL,

first$\_$name VARCHAR$(20)$ NOT NULL,

last$\_$name VARCHAR$(20)$ NOT NULL,

email VARCHAR$(20)$ NOT NULL,

active BOOLEAN NOT NULL,

last$\_$update TIMESTAMP NOT NULL,

PRIMARY KEY $($person$\_$id$)$

$)$;

CREATE TABLE staff $($

person$\_$id SMALLINT UNSIGNED NOT NULL,

picture BLOB,

username VARCHAR$(20)$ NOT NULL,

password VARCHAR$(20)$ NOT NULL,

FOREIGN KEY $($person$\_$id$)$ REFERENCES person$($person$\_$id$)$ ON DELETE CASCADE,

PRIMARY KEY $($person$\_$id$)$

$)$;

CREATE TABLE customer $($

person$\_$id SMALLINT UNSIGNED NOT NULL,

create$\_$date TIMESTAMP NOT NULL,

FOREIGN KEY $($person$\_$id$)$ REFERENCES person$($person$\_$id$)$ ON DELETE CASCADE,

PRIMARY KEY $($person$\_$id$)$

$)$;

ALTER TABLE person

ADD address$\_$id SMALLINT UNSIGNED NOT NULL,

ADD FOREIGN KEY $($address$\_$id$)$ REFERENCES address$($address$\_$id$)$ ON DELETE RESTRICT;

ALTER TABLE staff

ADD store$\_$id TINYINT UNSIGNED NOT NULL,

ADD FOREIGN KEY $($store$\_$id$)$ REFERENCES store$($store$\_$id$)$ ON DELETE RESTRICT;