Market-Bridge
Tables (4)
Market (시장정보)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- address (Field2) — String
STORE_KEYWORDS (AI추천에 필요한 키워드)
- store_id (Key) — Long — Primary key — NOT NULL
- keywords (Key2) — String — Foreign key → Store.id — NOT NULL
STORE_MENU (메뉴정보)
- id (Key) — Long — Primary key — NOT NULL
- store_id (Key2) — Long — Foreign key → Store.id — NOT NULL
- name (Field) — String
- price (Field2) — Integer
Store (점포정보)
- id (Key) — Long — Primary key — NOT NULL
- market_id (Key2) — Long — Foreign key → Market.id — NOT NULL
- name (Field) — String
- category (Field2) — String
- intro (Field3) — String
- imageUrl (Field4) — String
- openTime (Field5) — String
- phoneNumber (Field6) — String