bdz

Tables (20)

Copy Of users (CopyOfusers)

  • Key — Foreign key → parking_lot.Key — NOT NULL
  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • phone — VARCHAR(30)
  • role — VARCHAR(50)
  • profile_image_url — VARCHAR(500)
  • is_active — BOOLEAN
  • is_email_verified — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Untitled

    cars

    • id (id2) — BIGINT — Foreign key → users.id — NOT NULL
    • user_id — BIGINT — NOT NULL
    • car_number — VARCHAR(30) — NOT NULL
    • car_model — VARCHAR(100)
    • is_default — BOOLEAN
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    conversation_turns

    • id — BIGINT
    • conversation_id — VARCHAR(64) — NOT NULL
    • turn_index — INT — NOT NULL
    • role — VARCHAR(20) — NOT NULL
    • type — VARCHAR(20) — NOT NULL
    • content — TEXT
    • created_at — TIMESTAMP

    conversations

    • conversation_id — VARCHAR(64)
    • user_id — BIGINT
    • created_at — TIMESTAMP
    • ended_at — TIMESTAMP

    notifications

    • id — BIGINT
    • receiver_user_id — BIGINT — NOT NULL
    • type — VARCHAR(50)
    • message — TEXT
    • status — VARCHAR(20)
    • target_type — VARCHAR(50)
    • target_id — BIGINT
    • sent_at — TIMESTAMP
    • created_at — TIMESTAMP

    parking_fee_policy

    • parking_lot_id — VARCHAR(20) — Primary key — NOT NULL
    • date_type — CHAR(3) — Primary key — NOT NULL — WKD/SAT/SUN/HOL
    • base_fee — INT — NOT NULL
    • base_time_min — INT — NOT NULL
    • add_fee — INT — NOT NULL
    • add_time_min — INT — NOT NULL
    • daily_max_fee — INT
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    parking_lot

    • Key — Primary key — NOT NULL
    • id — VARCHAR(20)
    • name — VARCHAR(50)
    • road_addr — VARCHAR(255)
    • lot_addr — VARCHAR(255)
    • admin_area_code — CHAR(10)
    • latitude — DECIMAL(9,6)
    • longitude — DECIMAL(9,6)
    • capacity_total — INT
    • is_public — BOOLEAN
    • is_24h — BOOLEAN
    • is_street — BOOLEAN
    • is_unman — BOOLEAN
    • has_disable_zone — BOOLEAN
    • has_ev_charging — BOOLEAN
    • has_cctv — BOOLEAN
    • has_height — BOOLEAN
    • is_free — BOOLEAN
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    parking_meta

    • parking_lot_id — VARCHAR(20)
    • full_address — VARCHAR(255)
    • data_source — VARCHAR(50) — NOT NULL
    • reference_date — TIMESTAMP
    • last_synced_at — TIMESTAMP
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    parking_operation_exception

    • parking_lot_id — VARCHAR(20) — Primary key — NOT NULL
    • date — DATE — Primary key — NOT NULL
    • is_closed — BOOLEAN — NOT NULL
    • override_time — BOOLEAN — NOT NULL
    • open_time_min — INT
    • close_time_min — INT
    • reason — VARCHAR(255)
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    parking_operation_time

    • parking_lot_id — VARCHAR(20) — Primary key — NOT NULL
    • day — VARCHAR(10) — Primary key — NOT NULL
    • is_closed — BOOLEAN — NOT NULL
    • open_time_min — INT
    • close_time_min — INT
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    payment_events

    • id — BIGINT
    • payment_id — BIGINT — NOT NULL
    • event_type — VARCHAR(50)
    • prev_status — VARCHAR(30)
    • new_status — VARCHAR(30)
    • payload — JSON
    • occurred_at — TIMESTAMP — NOT NULL
    • created_at — TIMESTAMP

    payments

    • id — BIGINT
    • user_id — BIGINT — NOT NULL
    • reservation_id — BIGINT — NOT NULL
    • order_id — VARCHAR(100)
    • amount — INT — NOT NULL
    • currency — VARCHAR(10)
    • method — VARCHAR(30)
    • status — VARCHAR(30)
    • pg_transaction_id — VARCHAR(200)
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    recommendation_events

    • id — BIGINT
    • user_id — BIGINT — NOT NULL
    • result_id — BIGINT — NOT NULL
    • event_type — VARCHAR(30) — NOT NULL
    • reservation_id — BIGINT
    • metadata — JSON
    • occurred_at — TIMESTAMP — NOT NULL
    • created_at — TIMESTAMP

    recommendation_requests

    • id — BIGINT
    • user_id — BIGINT — NOT NULL
    • user_latitude — DECIMAL(10,7) — NOT NULL
    • user_longitude — DECIMAL(10,7) — NOT NULL
    • radius_m — INT
    • algorithm_version — VARCHAR(50)
    • context — JSON
    • created_at — TIMESTAMP

    recommendation_results

    • id — BIGINT
    • request_id — BIGINT — NOT NULL
    • parking_lot_id — VARCHAR(20) — NOT NULL
    • rank — INT — NOT NULL
    • score — DECIMAL(10,5)
    • distance_m — INT
    • created_at — TIMESTAMP

    reports

    • id — BIGINT
    • report_code — VARCHAR(100)
    • reporter_user_id — BIGINT — NOT NULL
    • target_type — VARCHAR(50) — NOT NULL
    • target_id — BIGINT — NOT NULL
    • category — VARCHAR(50)
    • status — VARCHAR(30)
    • processed_by_user_id — BIGINT
    • admin_memo — TEXT
    • user_notice — TEXT
    • processed_at — TIMESTAMP
    • created_at — TIMESTAMP

    reservations

    • id — BIGINT
    • user_id — BIGINT — NOT NULL
    • parking_lot_id — VARCHAR(20) — NOT NULL
    • car_id — BIGINT
    • car_number — VARCHAR(30) — NOT NULL
    • initial_start_time — TIMESTAMP — NOT NULL
    • initial_end_time — TIMESTAMP — NOT NULL
    • start_time — TIMESTAMP — NOT NULL
    • end_time — TIMESTAMP — NOT NULL
    • status — VARCHAR(30)
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    user_settings

    • id — BIGINT
    • user_id — BIGINT — NOT NULL
    • marketing_opt_in — BOOLEAN
    • terms_required_agreed — BOOLEAN
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    users

    • id — BIGINT — Primary key — NOT NULL
    • email — VARCHAR(255) — NOT NULL
    • password — VARCHAR(255) — NOT NULL
    • name — VARCHAR(100)
    • phone — VARCHAR(30)
    • role — VARCHAR(50)
    • profile_image_url — VARCHAR(500)
    • is_active — BOOLEAN
    • is_email_verified — BOOLEAN
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP