sample
Tables (3)
tb_category (Untitled2)
- category_id (카테고리 ID) — int unsigned — Primary key — NOT NULL
- category_name (카테고리 이름) — varchar(100)
- category_depth (카테고리 레벨) — int unsigned
- parent_id (상위카테고리 ID) — int unsigned — Foreign key → tb_category.category_id — NOT NULL
tb_god (Untitled)
- god_cd (상품코드) — varchar(50) — Primary key — NOT NULL
- god_nm (상품명) — varchar(300)
- god_pr (단가) — int unsigned
- in_pr (입고가) — int unsigned
- sal_pr (판매가) — int unsigned
- reg_id (등록자) — varchar(36)
- reg_time (등록시간) — timestamp
- upd_id (수정자) — varchar(36)
- upd_time (수정시간) — timestamp
- mall_id (쇼핑몰ID) — varchar(50) — NOT NULL
tb_god_category_mapping (Untitled3)
- god_cd (상품코드) — varchar(50) — Primary key — NOT NULL
- category_id (카테고리 ID) — int unsigned — Primary key — NOT NULL
- god_cd (상품코드2) — varchar(50) — Foreign key → tb_god.god_cd — NOT NULL
- category_id (카테고리 ID2) — int unsigned — Foreign key → tb_category.category_id — NOT NULL