JjimKong

Tables (12)

categories

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)

favorites

  • favorite_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL

group_posts

  • group_post_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)
  • group_id — BIGINT — Foreign key → groups.group_id — NOT NULL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL

group_reviews

  • group_review_id — BIGINT — Primary key — NOT NULL
  • shared_by — BIGINT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)
  • group_id — BIGINT — Foreign key → groups.group_id — NOT NULL
  • review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL

groups

  • group_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)

post_reviews

  • post_review_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
  • review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL

posts

  • post_id — BIGINT — Primary key — NOT NULL
  • region — VARCHAR(100)
  • detail_address — VARCHAR(255)
  • restaurant_name — VARCHAR(255)
  • restaurant_uid — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.category_id — NOT NULL

review_criteria

  • review_criteria_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)
  • category_id (Key2) — BIGINT — Foreign key → categories.category_id — NOT NULL

review_photos

  • review_photo_id — BIGINT — Primary key — NOT NULL
  • photo_url — VARCHAR(500) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)
  • review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL

review_scores

  • review_score_id — BIGINT — Primary key — NOT NULL
  • score — DECIMAL(2,1)
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)
  • criterion_id — BIGINT — Foreign key → review_criteria.review_criteria_id — NOT NULL
  • review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL

reviews

  • review_id — BIGINT — Primary key — NOT NULL
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — VARCHAR(20)