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)