final erd
Tables (32)
comments
- id — BIGSERIAL
- post_id — BIGINT — NOT NULL
- user_id — BIGINT
- parent_comment_id — BIGINT
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
email_verifications
- id — BIGSERIAL
- email — VARCHAR(100) — NOT NULL
- verification_code — VARCHAR(6) — NOT NULL
- purpose — VARCHAR(20) — NOT NULL
- is_verified — BOOLEAN
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
local_badges
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- city — VARCHAR(100) — NOT NULL
- level — INTEGER
- is_active — BOOLEAN
- first_authenticated_at — DATE
- last_authenticated_at — DATE
- next_authentication_due — DATE — NOT NULL
- maintenance_months — INTEGER
local_column_section_images
- id — BIGSERIAL
- section_id — BIGINT — NOT NULL
- image_url — TEXT — NOT NULL
- order — INTEGER
local_column_sections
- id — BIGSERIAL
- column_id — BIGINT — NOT NULL
- place_id — BIGINT
- order — INTEGER
- title — VARCHAR(200)
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
local_columns
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- thumbnail_url — TEXT
- content — TEXT — NOT NULL
- intro_image_url — TEXT
- representative_place_id — BIGINT
- view_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
login_history
- id — BIGSERIAL
- user_id — BIGINT
- username — VARCHAR(150)
- login_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- failure_reason — VARCHAR(100)
- ip_address — INET
- device_info — VARCHAR(255)
- attempted_at — TIMESTAMP
login_sessions
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- session_token — VARCHAR(255) — NOT NULL
- refresh_token — VARCHAR(255)
- device_info — VARCHAR(255)
- ip_address — INET
- is_auto_login — BOOLEAN
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
- last_activity_at — TIMESTAMP
password_reset_tokens
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- token — VARCHAR(255) — NOT NULL
- is_used — BOOLEAN
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
payment_transactions
- id — UUID
- user_id — BIGINT — NOT NULL
- reservation_id — UUID
- provider — VARCHAR(30)
- status — VARCHAR(20)
- amount — DECIMAL(12, 2) — NOT NULL
- currency — VARCHAR(3)
- order_id — VARCHAR(80) — NOT NULL
- payment_key — VARCHAR(120)
- fail_code — VARCHAR(80)
- fail_message — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
place_bookmarks
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- place_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(user_id, — place_id)
place_reviews
- id — BIGSERIAL
- place_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- rating — INTEGER
- image_url — VARCHAR(500)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
places
- id — BIGSERIAL
- provider — VARCHAR(50)
- place_api_id — VARCHAR(50)
- name — TEXT — NOT NULL
- category_main — VARCHAR(50) — NOT NULL
- category_detail — JSONB
- address — TEXT — NOT NULL
- city — VARCHAR(50) — NOT NULL
- latitude — DECIMAL(10, 7) — NOT NULL
- longitude — DECIMAL(10, 7) — NOT NULL
- thumbnail_urls — JSONB
- created_by — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
plan_details
- id — BIGSERIAL
- plan_id — BIGINT — NOT NULL
- place_id — BIGINT
- date — DATE — NOT NULL
- description — TEXT
- order_index — INTEGER
- temp_place_name — VARCHAR(255)
- temp_place_address — TEXT
- created_at — TIMESTAMP
post_likes
- id — BIGSERIAL
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(post_id, — user_id)
reservation_flight_segments
- id — UUID
- reservation_id — UUID — NOT NULL
- direction — VARCHAR(10) — NOT NULL
- segment_no — INTEGER — NOT NULL
- airline_code — VARCHAR(10)
- flight_no — VARCHAR(20)
- dep_airport — VARCHAR(10) — NOT NULL
- arr_airport — VARCHAR(10) — NOT NULL
- dep_at — TIMESTAMP — NOT NULL
- arr_at — TIMESTAMP — NOT NULL
- duration_min — INTEGER
- fare_per_person — DECIMAL(12, 2)
- seat_availability_note — VARCHAR(80)
reservation_flights
- reservation_id — UUID
- trip_type — VARCHAR(10) — NOT NULL
- cabin_class — VARCHAR(30) — NOT NULL
- adults — INTEGER
- children — INTEGER
- infants — INTEGER
- baggage_info — TEXT
- refund_rule — TEXT
- special_request — TEXT
- contact_email — VARCHAR(120)
- contact_phone — VARCHAR(40)
reservation_passengers
- id — UUID
- reservation_id — UUID — NOT NULL
- passenger_type — VARCHAR(10) — NOT NULL
- full_name — VARCHAR(100) — NOT NULL
- birth_date — DATE
- passport_no — VARCHAR(30)
reservation_seat_selections
- id — UUID
- reservation_id — UUID — NOT NULL
- passenger_id — UUID
- direction — VARCHAR(10) — NOT NULL
- segment_no — INTEGER — NOT NULL
- seat_no — VARCHAR(10)
- seat_note — TEXT
reservations
- id — UUID
- user_id — BIGINT — NOT NULL
- type — VARCHAR(10)
- status — VARCHAR(20)
- title — VARCHAR(200) — NOT NULL
- start_at — TIMESTAMP — NOT NULL
- end_at — TIMESTAMP
- total_amount — DECIMAL(12, 2) — NOT NULL
- currency — VARCHAR(3)
- provider — VARCHAR(50)
- provider_ref — VARCHAR(120)
- test_order_no — VARCHAR(80) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
saved_ids
- id — BIGSERIAL
- device_fingerprint — VARCHAR(255) — NOT NULL
- username — VARCHAR(150) — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(device_fingerprint, — username)
shortform_comment_likes
- id — BIGSERIAL
- comment_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(comment_id, — user_id)
shortform_comments
- id — BIGSERIAL
- shortform_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- source_lang — VARCHAR(10)
- total_likes — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
shortform_likes
- id — BIGSERIAL
- shortform_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(shortform_id, — user_id)
shortform_views
- id — BIGSERIAL
- shortform_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
shortforms
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- video_url — VARCHAR(500) — NOT NULL
- thumbnail_url — VARCHAR(500)
- title — TEXT — NOT NULL
- content — TEXT
- visibility — VARCHAR(10)
- source_lang — VARCHAR(10)
- total_likes — INTEGER
- total_comments — INTEGER
- total_views — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
translation_entries
- id — BIGSERIAL
- content_type_id — INTEGER — NOT NULL
- object_id — BIGINT — NOT NULL
- field_name — VARCHAR(100) — NOT NULL
- source_lang — VARCHAR(10) — NOT NULL
- target_lang — VARCHAR(10) — NOT NULL
- source_hash — VARCHAR(64) — NOT NULL
- translated_text — TEXT — NOT NULL
- updated_at — TIMESTAMP
- UNIQUE(content_type_id, — object_id,
travel_plans
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- plan_type — VARCHAR(20)
- ai_prompt — TEXT
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- is_public — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
travel_posts
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- plan_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- thumbnail_url — VARCHAR(500)
- destination — VARCHAR(100)
- is_public — BOOLEAN
- view_count — INTEGER
- like_count — INTEGER
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_preferences
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- language — VARCHAR(10)
- currency — VARCHAR(3)
- push_notification — BOOLEAN
- email_notification — BOOLEAN
- booking_alert — BOOLEAN
- schedule_alert — BOOLEAN
- flight_alert — BOOLEAN
- event_alert — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_withdrawal
- id — BIGSERIAL
- original_user_id — BIGINT — NOT NULL
- username — VARCHAR(150)
- email — VARCHAR(254)
- withdrawal_reason — VARCHAR(50)
- withdrawal_detail — TEXT
- withdrawn_at — TIMESTAMP
users
- id — BIGSERIAL
- password — VARCHAR(128) — NOT NULL
- last_login — TIMESTAMP
- is_superuser — BOOLEAN
- username — VARCHAR(150) — NOT NULL
- first_name — VARCHAR(150)
- last_name — VARCHAR(150)
- email — VARCHAR(254)
- is_staff — BOOLEAN
- is_active — BOOLEAN
- date_joined — TIMESTAMP
- nickname — VARCHAR(50)
- birth_year — INTEGER
- country — VARCHAR(100)
- city — VARCHAR(100)
- phone_number — VARCHAR(20)
- profile_image_url — VARCHAR(500)
- account_status — VARCHAR(20)
- is_email_verified — BOOLEAN
- email_consent — BOOLEAN
- provider_type — VARCHAR(20)
- provider_id — VARCHAR(255)
- is_temp_password — BOOLEAN
- updated_at — TIMESTAMP