test
Tables (10)
p_company
- id — UUID
- hub_id — UUID
- name — VARCHAR(100)
- type — ENUM('supplier', 'retailer', 'wholesaler')
- address — VARCHAR(255)
- is_public — BOOLEAN
- is_delete — BOOLEAN
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_delivery
- id — UUID
- order_id — UUID
- status — ENUM('pending', 'shipped', 'delivered', 'cancelled')
- origin_hub_id — UUID
- destination_hub_id — UUID
- address — VARCHAR(200)
- recipient_name — VARCHAR(200)
- slack_id — VARCHAR(200)
- is_delete — BOOLEAN
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_delivery_path
- id — UUID
- origin_hub_id — UUID
- destination_hub_id — UUID
- sequence — INTEGER
- estimated_distance — VARCHAR(100)
- estimated_duration — VARCHAR(100)
- actual_distance — VARCHAR(100)
- actual_duration — VARCHAR(100)
- status — ENUM('in_progress', 'completed', 'delayed')
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_hub
- id — UUID
- name — VARCHAR(30)
- address — VARCHAR(50)
- latitude — VARCHAR(100)
- hardness — VARCHAR(100)
- phone_number — VARCHAR(20)
- is_delete — BOOLEAN
- is_public — BOOLEAN
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_hub_path
- paths_id — UUID
- departure_id — UUID
- arrivals_id — UUID
- time_required — TIME
- is_delete — BOOLEAN
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_order
- id — UUID
- request_company_id — UUID
- receive_company_id — UUID
- product_id — UUID
- delivery_id — UUID
- quantity — INTEGER
- is_delete — BOOLEAN
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_product
- id — UUID
- company_id — UUID
- hub_id — UUID
- name — VARCHAR(100)
- is_delete — BOOLEAN
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_shipper
- id — UUID
- hub_affiliation_id — UUID
- slack_id — UUID
- shipper_type — BOOLEAN
- is_delete — BOOLEAN
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)
p_slack_message
- id — UUID
- user_id — UUID
- message — TEXT
- sent_at — DATETIME
p_users
- username — VARCHAR(100)
- password — VARCHAR(255)
- role — ENUM('admin', 'user', 'guest')
- is_public — BOOLEAN
- is_delete — BOOLEAN
- created_at — DATETIME
- created_by — VARCHAR(100)
- updated_at — DATETIME
- updated_by — VARCHAR(100)
- deleted_at — DATETIME
- deleted_by — VARCHAR(100)