ㅅ
Tables (11)
boarding_events
- event_id — bigint
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- bus_id — bigint — Foreign key → buses.bus_id — NOT NULL
- board_station_id — bigint — Foreign key → stations.station_id
- alight_station_id — bigint — Foreign key → stations.station_id
- board_idempotency_key — varchar(36) — NOT NULL
- alight_idempotency_key — varchar(36) — NOT NULL
- status — varchar(20) — NOT NULL
- payment_method — varchar(20)
- held_amount — decimal(8,2)
- final_amount — decimal(8,2)
- rssi_mean — decimal(6,2)
- rssi_std_dev — decimal(6,2)
- rssi_beacon_balance — decimal(6,2)
- imu_accel_max — decimal(6,3)
- imu_gyro_variance — decimal(8,5)
- ml_confidence — decimal(4,3)
- boarded_at — datetime — NOT NULL
- alighted_at — datetime
- timeout_at — datetime — NOT NULL
- device_time — datetime — NOT NULL
- created_at — datetime
buses
- bus_id — bigint
- operator_id — int — NOT NULL
- route_number — varchar(20) — NOT NULL
- beacon_uuid — varchar(36) — NOT NULL
- beacon_major — int — NOT NULL
- beacon_minor — int — NOT NULL
- tx_power — int — NOT NULL
- status — varchar(20)
- created_at — datetime
charge_history
- charge_id — bigint
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- idempotency_key — varchar(36) — NOT NULL
- amount — decimal(8,2) — NOT NULL
- status — varchar(20) — NOT NULL
- pg_transaction_id — varchar(255)
- created_at — datetime
fare_table
- route_number — varchar(20) — Primary key — NOT NULL
- board_seq — int — Primary key — NOT NULL
- alight_seq — int — Primary key — NOT NULL
- fare — decimal(8,2) — NOT NULL
- max_fare — decimal(8,2) — NOT NULL
outbox
- id — bigint
- topic — varchar(100) — NOT NULL
- payload — json — NOT NULL
- created_at — datetime
- published_at — datetime
payments
- payment_id — bigint
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- event_id — bigint — Foreign key → boarding_events.event_id
- idempotency_key — varchar(36) — NOT NULL
- payment_type — varchar(20) — NOT NULL
- amount — decimal(8,2) — NOT NULL
- post_balance — decimal(10,2) — NOT NULL
- processed_at — datetime
processed_messages
- message_id — varchar(255)
- processed_at — datetime
sensor_logs
- log_id — bigint — Primary key — NOT NULL
- logged_at — datetime — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id
- bus_id — bigint — Foreign key → sensor_logs.log_id
- rssi_series — json
- imu_series — json
- behavior — varchar(20)
- ml_confidence — decimal(4,3)
stations
- station_id — bigint
- station_name — varchar(100) — NOT NULL
- route_number — varchar(20) — NOT NULL
- sequence — int — NOT NULL
- latitude — decimal(10,7) — NOT NULL
- longitude — decimal(10,7) — NOT NULL
- created_at — datetime
user_cards
- card_id — bigint
- user_id — bigint — NOT NULL
- billing_key — varchar(255) — NOT NULL
- card_company — varchar(50) — NOT NULL
- masked_card_number — varchar(20) — NOT NULL
- auto_charge_enabled — boolean
- auto_charge_threshold — decimal(8,2)
- auto_charge_amount — decimal(8,2)
- created_at — datetime
users
- user_id — bigint
- phone_number — varchar(20) — NOT NULL
- device_token — varchar(255)
- balance — decimal(10,2)
- postpay_amount — decimal(8,2)
- status — varchar(20)
- version — int — NOT NULL
- created_at — datetime