123

Tables (9)

p_deliveries

  • delivery_id — UUID
  • order_id — UUID — NOT NULL
  • hub_delivery_manager_id — UUID
  • supplier_delivery_manager_id — UUID
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

p_delivery_managers

  • manager_id — UUID
  • hub_id — UUID — NOT NULL
  • name — VARCHAR(100)
  • manager_type — delivery_manager_type — NOT NULL
  • user_id — UUID
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

p_hub_routes

  • route_id — UUID
  • from_hub_id — UUID — NOT NULL
  • to_hub_id — UUID — NOT NULL
  • distance_km — INT
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

p_hubs

  • hub_id — UUID
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

p_orders

  • order_id — UUID
  • product_id — UUID — NOT NULL
  • source_hub_id — UUID — NOT NULL
  • target_hub_id — UUID — NOT NULL
  • supplier_id — UUID — NOT NULL
  • quantity — INT — NOT NULL
  • status — VARCHAR(50)
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

p_products

  • product_id — UUID
  • supplier_id — UUID — NOT NULL
  • hub_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • stock — INT
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

p_slack_messages

  • message_id — UUID
  • user_id — UUID
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

p_suppliers

  • supplier_id — UUID
  • hub_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • is_producer — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

p_users

  • user_id — UUID
  • username — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(100)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — role_type — NOT NULL
  • is_public — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID