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: 삭제됨