CREATE TABLE person $($

person$\_$id SMALLINT UNSIGNED PRIMARY KEY,

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

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

email VARCHAR$(20),$

active VARCHAR$(20),$

last$\_$update TIMESTAMP,

address$\_$id SMALLINT UNSIGNED,

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

$)$;

CREATE TABLE staff $($

person$\_$id SMALLINT UNSIGNED PRIMARY KEY,

picture BLOB,

username VARCHAR$(20),$

password VARCHAR$(20),$

store$\_$id TINYINT UNSIGNED,

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

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

$)$;

CREATE TABLE customer $($

person$\_$id SMALLINT UNSIGNED PRIMARY KEY,

create$\_$date TIMESTAMP,

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

$)$;