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