Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE phone
- (
- phone_id SERIAL PRIMARY KEY,
- phone CHAR(15),
- sub_id INT, -- subscriber id --
- cat_id INT -- category id --
- );
- CREATE TABLE category
- (
- cat_id SERIAL PRIMARY KEY, -- category id --
- cat_name CHAR(15) -- category name --
- );
- CREATE TABLE subscriber
- (
- sub_id SERIAL PRIMARY KEY,
- name CHAR(20),
- fname CHAR(20), -- first name --
- lname CHAR(20), -- last name --
- );
- CREATE TABLE address
- (
- addr_id SERIAL PRIMARY KEY,
- country CHAR(20),
- city CHAR(20),
- street CHAR(20),
- house_num INT,
- apartment_num INT
- );
- -- many-to-many relation --
- CREATE TABLE sub_link
- (
- sub_id INT REFERENCES subscriber(sub_id),
- addr_id INT
- );
Add Comment
Please, Sign In to add comment