ㅅ

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