CoffeeERD

Tables (6)

ALLERGY (allergy)

  • ALLERGY_ID (allergy_id) — CHAR(4) — Primary key — NOT NULL
  • NAME (name) — VARCHAR(100)

IMAGE (image)

  • IMAGE_ID (image_id) — CHAR(5) — Primary key — NOT NULL
  • IMAGE_ADDRESS (url) — VARCHAR(100)
  • IMAGE_MAIN_STATUS (is_main) — TINYINT(1)
  • PRODUCT_ID (product_id) — CHAR(5) — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL

MAIN_CATEGORY (main_category)

  • MAIN_CATEGORY_ID (main_category_id) — CHAR(5) — Primary key — NOT NULL
  • NAME (name) — VARCHAR(100)

PRODUCT (product)

  • PRODUCT_ID (product_id) — CHAR(4) — Primary key — NOT NULL
  • PRODUCT_NAME (product_name) — VARCHAR(100)
  • DESCRIPTION (desc) — TEXT
  • KCAL (kcal) — DECIMAL(4,1)
  • MG (mg) — DECIMAL(4,1)
  • SUB_CATEGORY_ID (sub_category_id) — CHAR(5) — Foreign key → SUB_CATEGORY.SUB_CATEGORY_ID — NOT NULL

PRODUCT_ALLERGY (product_allergy)

  • PRODUCT_ID (product_id) — CHAR(5) — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • ALLERGY_ID (allergy_id) — CHAR(5) — Foreign key → ALLERGY.ALLERGY_ID — NOT NULL

SUB_CATEGORY (sub_category)

  • SUB_CATEGORY_ID (sub_category_id) — CHAR(5) — Primary key — NOT NULL
  • NAME (name) — VARCHAR(100)
  • MAIN_CATEGORY_ID (main_category_id) — CHAR(5) — Foreign key → MAIN_CATEGORY.MAIN_CATEGORY_ID — NOT NULL