맛집탐방
테이블 (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