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