boowang
Tables (7)
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 (id2) — BIGINT — Foreign key → users.id — NOT NULL
- place_id (id3) — BIGINT — Foreign key → places.id — NOT NULL
- user_id — BIGINT — NOT NULL
- place_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
parking_details
- place_id — BIGINT — Foreign key → places.id — NOT NULL
- is_free — BOOLEAN
- 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
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
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
users
- id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME