ㅏㅏ
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