erd_pra1

Tables (6)

Allergy_table (allergy)

  • 알러지ID (allergyID) — char(4) — Primary key — NOT NULL
  • 알러지명 (allergyName) — varchar(30)

Img_table (img)

  • 이미지ID (imgID) — char(4) — Primary key — NOT NULL
  • 이미지주소 (imgUrl) — varchar(100)
  • 이미지메인여부 (isMain) — tinnyint(1)
  • 상품ID (productID) — char(4) — Foreign key → Product_table.상품ID — NOT NULL

MainCtg_table (mainCtg)

  • 메인카테고리ID (mainCtgID) — char(4) — Primary key — NOT NULL
  • 메인카테고리명 (mainCtgName)

ProductAllergy (productAllergy)

  • 상품ID (productID) — char(4) — Foreign key → Product_table.상품ID — NOT NULL
  • 알러지ID (allergyID) — char(4) — Foreign key → Allergy_table.알러지ID — NOT NULL

Product_table (product)

  • 상품ID (productID) — char(4) — Primary key — NOT NULL
  • 상품명kr (krName) — varchar(30)
  • 상품명en (enName) — varchar(30)
  • 상세설명 (desc) — varchar(50)
  • 칼로리 (kcal) — decimal(4,1)
  • 나트륨 (mg) — decimal(4,1)
  • 서브카테고리ID (subCtgID) — char(4) — Foreign key → SubCtg_table.서브카테고리ID — NOT NULL

SubCtg_table (subCtg)

  • 서브카테고리ID (subCtgID) — char(4) — Primary key — NOT NULL
  • 서브카테고리명 (subCtgName)
  • 메인카테고리ID (mainCtgID) — char(4) — Foreign key → MainCtg_table.메인카테고리ID — NOT NULL