Triplog
Tables (9)
bookmarks
- id — BIGINT
- user_id — BIGINT — NOT NULL
- review_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
comments
- id — BIGINT
- review_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- parent_id — BIGINT
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
likes
- id — BIGINT
- user_id — BIGINT — NOT NULL
- review_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
places
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- region — VARCHAR(255)
- category — VARCHAR(100)
- created_at — DATETIME — NOT NULL
review_images
- id — BIGINT
- review_id — BIGINT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INT
review_tags
- review_id — BIGINT — Primary key — NOT NULL
- tag_id — BIGINT — Primary key — NOT NULL
reviews
- id — BIGINT
- user_id — BIGINT — NOT NULL
- place_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- rating — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
tags
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL