Flavowcase

Tables (4)

Image (이미지)

  • id (이미지고유아이디) — BIGINT — Primary key — NOT NULL
  • str_id (매장고유아이디) — BIGINT — Foreign key → Store.id — NOT NULL
  • mnu_id (메뉴고유아이디) — BIGINT — Foreign key → Menu.id — NOT NULL
  • img_info (이미지를식별하는무언가정보) — VARCHAR
  • created_at (생성일) — DATETIME
  • updated_at (수정일) — DATETIME
  • sys_sta_cd (시스템상태코드) — VARCHAR(10)

Menu (메뉴)

  • id (메뉴고유아이디) — BIGINT — Primary key — NOT NULL
  • str_id (매장고유아이디) — BIGINT — Foreign key → Store.id — NOT NULL
  • name (메뉴명) — VARCHAR
  • price (가격) — INT
  • soldout_status (품절여부) — VARCHAR
  • description (메뉴설명) — VARCHAR
  • tag (태그) — VARCHAR
  • created_at (생성일) — DATETIME
  • updated_at (수정일) — DATETIME
  • sys_sta_cd (시스템상태코드) — VARCHAR(10)

Seller (판매자)

  • id (판매자고유아이디) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR
  • phone (전화번호) — VARCHAR
  • created_at (생성일) — DATETIME
  • updated_at (수정일) — DATETIME
  • sys_sta_cd (시스템상태코드) — VARCHAR(10)

Store (매장)

  • id (매장고유아이디) — BIGINT — Primary key — NOT NULL
  • sel_id (판매자고유아이디) — BIGINT — Foreign key → Seller.id — NOT NULL
  • name (매장명) — VARCHAR
  • description (설명) — VARCHAR
  • created_at (생성일) — DATETIME
  • updated_at (수정일) — DATETIME
  • sys_sta_cd (시스템상태코드) — VARCHAR(10) — 10: 정상, 20: 삭제됨