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