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)