boowang1

Tables (11)

auth_sessions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • refresh_token_hash — CHAR(64) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL

favorites

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • created_at — DATETIME — NOT NULL

parking_details

  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • is_free — BOOLEAN — NOT NULL
  • has roof (has_roof) — BOOLEAN — NOT NULL
  • fee_description — VARCHAR(500)
  • capacity — INT
  • operating_hours — VARCHAR(255)
  • updated_at — DATETIME — NOT NULL

place_photos

  • id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • uploaded_by — BIGINT — Foreign key → users.id — NOT NULL
  • image_url — VARCHAR(2048) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

place_reaction

  • user_id (id2) — BIGINT — Foreign key → users.id — NOT NULL
  • place_id (palce_id) — BIGINT — Foreign key → places.id — NOT NULL
  • reaction_type — VAECHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

places

  • id — BIGINT — Primary key — NOT NULL
  • created_by — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • detail_address — VARCHAR(255)
  • latitude — DECIMAL(10,7) — NOT NULL
  • longitude — DECIMAL(11,7) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

review_likes

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • review_id — BIGINT — Foreign key → reviews.id — NOT NULL
  • created_at — DATETIME — NOT NULL

reviews

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL

social_accounts

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(191) — NOT NULL
  • created_at — DATETIME — NOT NULL

trust_score_logs

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • score_delta — INT — NOT NULL
  • reason_code — VARCHAR(50) — NOT NULL
  • source_review_id — BIGINT — Foreign key → reviews.id
  • event_key — VARCHAR(191) — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • trust_score — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME