test

Tables (9)

installation_site_devices

  • id — TEXT — Primary key — NOT NULL
  • installation_site_id — TEXT — Foreign key → installation_sites.id — NOT NULL
  • model — TEXT — NOT NULL
  • capacity_liters — INTEGER — NOT NULL
  • active — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

installation_sites

  • id — TEXT — Primary key — NOT NULL
  • pole — TEXT — NOT NULL
  • business_name — TEXT — NOT NULL
  • area — TEXT — NOT NULL
  • road_address — TEXT — NOT NULL
  • site_type — TEXT — NOT NULL
  • note — TEXT
  • latitude — REAL
  • longitude — REAL
  • coordinate_source — TEXT
  • coordinate_verified_at — TEXT
  • active — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

logistics_companies

  • id — TEXT — Primary key — NOT NULL
  • business_name — TEXT — NOT NULL
  • business_number — TEXT — NOT NULL
  • corporate_registration_number — TEXT — NOT NULL
  • business_address — TEXT — NOT NULL
  • manager_name — TEXT — NOT NULL
  • manager_phone — TEXT — NOT NULL
  • bank_code — TEXT — NOT NULL
  • account_number — TEXT — NOT NULL
  • account_holder — TEXT — NOT NULL
  • active — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

mileage_application_photos

  • id — TEXT — Primary key — NOT NULL
  • mileage_application_id — TEXT — Foreign key → mileage_applications.id — NOT NULL
  • kind — TEXT — NOT NULL
  • storage_key — TEXT — NOT NULL
  • content_type — TEXT — NOT NULL
  • byte_size — INTEGER — NOT NULL
  • uploaded_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

mileage_applications

  • id — TEXT — Primary key — NOT NULL
  • user_id — TEXT — Foreign key → users.id — NOT NULL
  • logistics_company_id — TEXT — Foreign key → logistics_companies.id — NOT NULL
  • idempotency_key — TEXT — NOT NULL
  • receipt_amount — INTEGER
  • meter_amount — INTEGER
  • final_amount — INTEGER
  • mileage_amount — INTEGER
  • receipt_at — TEXT
  • match_status — TEXT — NOT NULL
  • approval_status — TEXT — NOT NULL
  • rejection_reason — TEXT
  • settlement_id — TEXT — Foreign key → settlements.id
  • submitted_at — TEXT — NOT NULL
  • decided_at — TEXT
  • updated_at — TEXT — NOT NULL

password_reset_tokens

  • id — TEXT — Primary key — NOT NULL
  • user_id — TEXT — Foreign key → users.id — NOT NULL
  • token_hash — TEXT — NOT NULL
  • expires_at — TEXT — NOT NULL
  • used_at — TEXT
  • created_at — TEXT — NOT NULL

phone_verifications

  • id — TEXT — Primary key — NOT NULL
  • purpose — TEXT — NOT NULL
  • phone — TEXT — NOT NULL
  • scope_email — TEXT
  • code_hash — TEXT — NOT NULL
  • proof_hash — TEXT
  • expires_at — TEXT — NOT NULL
  • verified_at — TEXT
  • consumed_at — TEXT
  • invalidated_at — TEXT
  • created_at — TEXT — NOT NULL

settlements

  • id — TEXT — Primary key — NOT NULL
  • logistics_company_id — TEXT — Foreign key → logistics_companies.id — NOT NULL
  • settlement_month — TEXT — NOT NULL
  • transfer_status — TEXT — NOT NULL
  • transferred_at — TEXT
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

users

  • id — TEXT — Primary key — NOT NULL
  • role — TEXT — NOT NULL
  • email — TEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • name — TEXT — NOT NULL
  • phone — TEXT
  • logistics_company_id — TEXT — Foreign key → logistics_companies.id
  • service_terms_version — TEXT
  • privacy_terms_version — TEXT
  • marketing_terms_version — TEXT
  • marketing_consent — INTEGER — NOT NULL
  • marketing_consent_updated_at — TEXT
  • deactivated_at — TEXT
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL