PJpJbKca

1CREATE TABLE IF NOT EXISTS Users (user_id char(36), email_address varchar(100), pswd TEXT, account_created_date char(10), picture_url TEXT, PRIMARY KEY(user_id));
2CREATE TABLE IF NOT EXISTS Buyers (user_id char(36), first_name varchar(100), last_name varchar(100), username varchar(100) UNIQUE, birth_date char(10), FOREIGN KEY (user_id) REFERENCES Users(user_id), PRIMARY KEY (user_id));
3CREATE TABLE IF NOT EXISTS Sellers (user_id char(36), seller_name varchar(100), seller_description TEXT, FOREIGN KEY (user_id) REFERENCES Users(user_id), PRIMARY KEY (user_id));
4CREATE TABLE IF NOT EXISTS Categories (category_name varchar(100), PRIMARY KEY (category_name));
5CREATE TABLE IF NOT EXISTS Items (item_id char(36), item_description TEXT, price FLOAT(2), quantity integer, category varchar(100), seller_id char(36), FOREIGN KEY (category) REFERENCES Categories(category_name), FOREIGN KEY (seller_id) REFERENCES Sellers(user_id), PRIMARY KEY (item_id));
6CREATE TABLE IF NOT EXISTS Items_tags (item_id char(36), tag varchar(100), FOREIGN KEY (item_id) REFERENCES Items.item_id, PRIMARY KEY (item_id, tag));
7CREATE TABLE IF NOT EXISTS Comments (comment_id char(36), buyer_id char(36), item_id char(36), comment_content TEXT, rating integer(1), comment_creation_date char(10), comment_creation_time char(8), FOREIGN KEY (buyer_id) REFERENCES Buyers(user_id), FOREIGN KEY (item_id) REFERENCES Items(item_id), PRIMARY KEY (comment_id));
8