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