test

Tables (11)

p_company

  • id — UUID
  • hub_id — UUID
  • name — VARCHAR(100)
  • type — ENUM('supplier', 'client')
  • address — VARCHAR(255)
  • 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')
  • 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 — INT
  • estimated_distance — VARCHAR(100)
  • estimated_duration — VARCHAR(100)
  • actual_distance — VARCHAR(100)
  • actual_duration — VARCHAR(100)
  • status — ENUM('planned', 'in_progress', 'completed')
  • 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
  • user_id — VARCHAR(100)
  • request_company_id — UUID
  • receive_company_id — UUID
  • delivery_id — UUID
  • 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_item

  • id — UUID
  • order_id — UUID
  • product_id — UUID
  • quantity — INT
  • 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

  • id — INT
  • username — VARCHAR(100)
  • password — VARCHAR(255)
  • role — ENUM('admin', 'user', 'guest')
  • is_delete — BOOLEAN
  • created_at — DATETIME
  • created_by — VARCHAR(100)
  • updated_at — DATETIME
  • updated_by — VARCHAR(100)
  • deleted_at — DATETIME
  • deleted_by — VARCHAR(100)