project
Tables (5)
Brand List (brand_list)
- Brand Id (b_id) — INT — Primary key — NOT NULL
- Brand Name (b_name) — VARCHAR — NOT NULL
Fragrance List (fragrance_list)
- Fragrance Id (f_id) — INT — Primary key — NOT NULL
- Fragrance Name (f_name) — VARCHAR — NOT NULL
Note List (note_list)
- Note Id (n_id) — INT — Primary key — NOT NULL
- Note Name (n_name) — VARCHAR — NOT NULL
- Fragrance Id (f_id) — INT — Foreign key → Fragrance List.Fragrance Id — NOT NULL
Perfume List (perfume_list)
- Perfume Id (p_id) — INT — Primary key — NOT NULL
- Perfume Name (p_name) — VARCHAR — NOT NULL
- Perfume Image URL (imgurl) — VARCHAR — NOT NULL
- Brand Id (b_id) — INT — Foreign key → Brand List.Brand Id — NOT NULL
Perfume Note List (perfume_note_list)
- Perfume Note Id (p_n_id) — INT — Primary key — NOT NULL
- Note Type (n_type) — VARCHAR — NOT NULL
- Perfume Id (p_id) — INT — Foreign key → Perfume List.Perfume Id — NOT NULL
- Brand Id (b_id) — INT — Foreign key → Brand List.Brand Id — NOT NULL
- Note Id (n_id) — INT — Foreign key → Note List.Note Id — NOT NULL