ㅏㅏ

Tables (10)

p_deliveries

  • delivery_id — UUID
  • order_id — UUID — NOT NULL
  • status — delivery_status
  • source_hub_id — UUID — NOT NULL
  • target_hub_id — UUID — NOT NULL
  • delivery_address — VARCHAR(500)
  • recipient_name — VARCHAR(100)
  • recipient_slack_id — VARCHAR(100)
  • 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
  • name — VARCHAR(100)
  • manager_type — delivery_manager_type — NOT NULL
  • delivery_sequence — INT
  • user_id — UUID
  • created_at — TIMESTAMP
  • created_by — UUID
  • updated_at — TIMESTAMP
  • updated_by — UUID
  • deleted_at — TIMESTAMP
  • deleted_by — UUID

p_delivery_routes

  • route_id — UUID
  • delivery_id — UUID — NOT NULL
  • sequence — INT — NOT NULL
  • from_hub_id — UUID — NOT NULL
  • to_hub_id — UUID — NOT NULL
  • expected_distance_km — DECIMAL(10,2)
  • expected_duration_minutes — INT
  • actual_distance_km — DECIMAL(10,2)
  • actual_duration_minutes — INT
  • status — delivery_status
  • delivery_manager_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 — DECIMAL(10,2)
  • duration_minutes — 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
  • latitude — DECIMAL(10,8)
  • longitude — DECIMAL(11,8)
  • 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
  • recipient_supplier_id — UUID — NOT NULL
  • quantity — INT — NOT NULL
  • request_note — TEXT
  • status — order_status
  • 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
  • sent_at — TIMESTAMP
  • 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
  • address — VARCHAR(500)
  • 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
  • slack_id — VARCHAR(100)
  • 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