review_db
Tables (3)
restaurant (장소)
- id (맛집 고유 ID) — INT (Long) — Primary key — NOT NULL
- id (유저 고유 ID) — INT (Long) — Foreign key → users.id — NOT NULL
- name (맛집 이름) — VARCHAR
- address (맛집 주소) — VARCHAR
- phone (전화번호) — VARCHAR
- category (음식 카테고리) — VARCHAR
- avg_rating (평균 별점) — DOUBLE
- created_at (생성일) — DATETIME
- updated_at (수정일) — DATETIME
review (리뷰)
- id (리뷰 고유 ID) — INT (Long) — Primary key — NOT NULL
- id (맛집 고유 ID) — INT (Long) — Foreign key → restaurant.id — NOT NULL
- id (유저 고유 ID) — INT (Long) — Foreign key → restaurant.id — NOT NULL
- user_id (작성 유저 ID) — INT
- restaurant_id (대상 맛집 ID) — INT
- rating (별점 (1~5점)) — INT
- comment (리뷰 내용) — TEXT
- created_at (생성일) — DATETIME
- updated_at (수정일) — DATETIME
users (유저)
- id (유저 고유 ID) — INT (Long) — Primary key — NOT NULL
- username (유저 아이디) — VARCHAR
- nickname (닉네임) — VARCHAR
- created_at4 (생성일) — DATETIME
- Field5 (수정일) — DATETIME