Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE clients (
- client_id SERIAL PRIMARY KEY,
- first_name VARCHAR(255) NOT NULL,
- last_name VARCHAR(255) NOT NULL,
- email VARCHAR(255) UNIQUE NOT NULL
- );
- CREATE TABLE phone_numbers (
- phone_id SERIAL PRIMARY KEY,
- client_id INT NOT NULL,
- phone_number VARCHAR(20),
- FOREIGN KEY (client_id) REFERENCES clients(client_id) ON DELETE CASCADE
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
