IDLE_REACT

Tables (17)

admin

  • id_index — integer — Primary key — NOT NULL
  • admin_id — character — NOT NULL
  • del_date — timestamp
  • empl_id — character
  • is_del — boolean
  • name — character
  • password — character — NOT NULL
  • reg_date — timestamp
  • role — character — NOT NULL

business_license

  • id — bigint — Primary key — NOT NULL
  • business_name — character
  • business_number — character — NOT NULL
  • start_date — timestamp
  • verified — boolean
  • verified_at — timestamp
  • car_num — character — NOT NULL
  • transport_auth_id — bigint — NOT NULL

car_owner_vehicle

  • id — bigint — Primary key — NOT NULL
  • capacity — integer
  • model — character
  • owner_id — character — NOT NULL
  • plate_number — character — NOT NULL
  • is_primary — boolean — NOT NULL
  • registered_at — timestamp — NOT NULL
  • status — character
  • type — character

chat_sessions

  • id — bigint — Primary key — NOT NULL
  • chat_room_id — character — NOT NULL
  • created_at — timestamp — NOT NULL
  • session_id — character — NOT NULL
  • customer_id — integer

customer

  • id_num — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • custom_name — character
  • id — character — NOT NULL
  • is_lefted — boolean — NOT NULL
  • lefted_at — timestamp
  • nickname — character — NOT NULL
  • password_enc — character
  • phone — character
  • role — character
  • sns_login_provider — character
  • sns_provider_id — character
  • updated_at — timestamp
  • user_point — integer — NOT NULL
  • refresh_token — character
  • rt_expires_at — timestamp
  • avatar_url — character
  • reset_expires_at — timestamp
  • reset_token_hash — character
  • reset_used — boolean

driver_license

  • id — bigint — Primary key — NOT NULL
  • issue_date — date
  • license_number — character — NOT NULL
  • name_on_license — character
  • verified — boolean
  • verified_at — timestamp
  • car_num — character — NOT NULL
  • transport_auth_id — bigint — NOT NULL

driver_offers

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • driver_id — bigint
  • memo — character
  • price — bigint — NOT NULL
  • status — character
  • updated_at — timestamp
  • order_id — bigint — NOT NULL
  • driver_id_num — integer — NOT NULL

faqs

  • id — bigint — Primary key — NOT NULL
  • answer — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • is_del — boolean — NOT NULL
  • question — character — NOT NULL
  • updated_at — timestamp — NOT NULL
  • view_count — integer — NOT NULL
  • writer_admin_id — character — NOT NULL

inquiry

  • inquiry_id — uuid — Primary key — NOT NULL
  • admin_id — character
  • answered_at — timestamp
  • created_at — timestamp — NOT NULL
  • customer_id_num — bigint — NOT NULL
  • inquiry_answer — text
  • inquiry_content — text — NOT NULL
  • inquiry_title — character — NOT NULL
  • re_inquiry_id — uuid
  • status — character — NOT NULL
  • admin_id_index — bigint

notices

  • id — bigint — Primary key — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • is_del — boolean — NOT NULL
  • title — character — NOT NULL
  • updated_at — timestamp — NOT NULL
  • view_count — integer — NOT NULL
  • writer_admin_id — character — NOT NULL

orders

  • id — bigint — Primary key — NOT NULL
  • arrival — character
  • cargo_size — character
  • cargo_type — character
  • departure — character
  • distance — double
  • is_immediate — boolean — NOT NULL
  • reserved_date — character
  • vehicle — character
  • weight — character
  • status — character — NOT NULL
  • transport_auth_id — bigint
  • proposed_price — integer
  • avg_price — bigint
  • driver_price — bigint
  • packing_option — character
  • created_at — timestamp
  • updated_at — timestamp
  • assigned_driver_id — bigint
  • order_no — character
  • shipper_id — character
  • completed_at — timestamp
  • departed_at — timestamp

payments

  • id — bigint — Primary key — NOT NULL
  • amount — bigint
  • buyer_email — character
  • buyer_name — character
  • cancelled_at — timestamp
  • imp_uid — character
  • item_name — character
  • merchant_uid — character
  • paid_at — timestamp
  • payment_status — character
  • requested_at — timestamp
  • customer_id — integer
  • points_used — integer
  • pg_provider — character
  • order_id — bigint

point_history

  • id — bigint — Primary key — NOT NULL
  • amount — integer — NOT NULL
  • balance_after — integer — NOT NULL
  • description — character
  • transaction_date — timestamp — NOT NULL
  • transaction_type — character — NOT NULL
  • customer_id_num — integer — NOT NULL

reviews

  • id — bigint — Primary key — NOT NULL
  • content — text
  • created_at — timestamp — NOT NULL
  • rating — integer — NOT NULL
  • author_id — integer — NOT NULL
  • target_id — integer — NOT NULL
  • order_id — bigint

settlement

  • id — bigint — Primary key — NOT NULL
  • amount — numeric — NOT NULL
  • created_at — timestamp
  • memo — character
  • order_id — bigint
  • owner_id — character — NOT NULL
  • paid_at — timestamp
  • status — character
  • tx_ref — character
  • updated_at — timestamp
  • batch_id — bigint — NOT NULL
  • approved_at — timestamp
  • commission — numeric — NOT NULL
  • month_key — date — NOT NULL
  • requested_at — timestamp

settlement_batch

  • id — bigint — Primary key — NOT NULL
  • approved_at — timestamp
  • item_count — integer — NOT NULL
  • month_key — date — NOT NULL
  • owner_id — character — NOT NULL
  • paid_at — timestamp
  • requested_at — timestamp — NOT NULL
  • status — character — NOT NULL
  • total_amount — numeric — NOT NULL
  • bank_code — character
  • bank_account_no — character

transport_auth

  • id — bigint — Primary key — NOT NULL
  • car_insurance_status — boolean — NOT NULL
  • car_num — character
  • car_type — character — NOT NULL
  • getorder — bigint
  • id_num — integer — NOT NULL
  • vehicle_id — bigint
  • business_license_id — bigint — NOT NULL