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