토착

테이블 (5)

restaurant

  • restaurant_id — INT — 기본 키 — NOT NULL
  • store_name — VARCHAR(50)
  • adress — VARCHAR(255)
  • category — VARCHAR(50)
  • ranking — INT

spot

  • spot_id — int — 기본 키 — NOT NULL
  • spot_name — varchar(50)
  • spot_adress — varchar(255)
  • spot_category — varchar(50)
  • classification — varchar(50)
  • ranking — int

touristspot

  • touristspot_id — INT — 기본 키 — NOT NULL
  • spot_name — VARCHAR(50)
  • adress — VARCHAR(255)
  • category — VARCHAR(50)
  • ranking — INT

user

  • user_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(20)
  • phone — VARCHAR(20)
  • nickname — VARCHAR(20)
  • age — INT

user_review

  • user_id — INT — 외래 키 → user.user_id — NOT NULL