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