맛집탐방

테이블 (4)

image

  • id — BIGINT — 기본 키 — NOT NULL
  • restaurant_id — BIGINT — 외래 키 → restaurant.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL

member

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — DATETIME

restaurant

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • latitude — DOUBLE
  • longitude — DOUBLE
  • description — TEXT
  • created_at — DATETIME

review

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • restaurant_id — BIGINT — 외래 키 → restaurant.id — NOT NULL
  • content — TEXT — NOT NULL
  • rating — INT — NOT NULL
  • created_at — DATETIME