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