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