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