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