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