spring0915
Tables (3)
Album (album)
- id (album_id) — int — Primary key — NOT NULL
- title — VARCHAR(100)
- id (user_id) — int — Foreign key → User.id — NOT NULL
Photo (photo)
- id (photo_id) — int — Primary key — NOT NULL
- thumbnail — VARCHAR(100)
- id (album_id) — int — Foreign key → Album.id — NOT NULL
User (user)
- id (user_id) — int — Primary key — NOT NULL
- name — VARCHAR(10)
- emaile (email) — VARCHAR(100)
- company — VARCHAR(100)
- phone — VARCHAR(30)
- city — VARCHAR(10)