DAY9
Tables (3)
Albums
- album_id — INT — Primary key — NOT NULL
- title — VARCHAR(20)
- user_id — INT — Foreign key → Users.user_id — NOT NULL
Photos
- photo_id — INT — Primary key — NOT NULL
- thubmnail (thumbnail) — VARCHAR(200)
- album_id — INT — Foreign key → Albums.album_id — NOT NULL
Users
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(20)
- email — VARCHAR(50)
- company — VARCHAR(30)
- phone — VARCHAR(20)
- city — VARCHAR(30)
- password — VARCHAR(20)