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