logistics-service
Tables (12)
Copy Of Copy Of Untitled4 (p_hub_routes)
- Key (id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Key (from_hub_id) — UUID — Foreign key → Copy Of Untitled4.Key — NOT NULL — FK(p_hubs.id) 출발허브
- Key (to_hub_id) — UUID — Foreign key → Copy Of Untitled4.Key — NOT NULL — FK(p_hubs.id) 도착허브
- Field3 (duration_minutes) — INTEGER — NOT NULL — CHECK(-90~90)
- Field (distance_km) — DECIMAL(10,2) — NOT NULL — CHECK(-180~180)
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Copy Of Untitled5 (p_order_items)
- Key (order_item_id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Key (order_id) — UUID — Foreign key → Copy Of Untitled5.Key — NOT NULL
- Field2 (product_id) — UUID — NOT NULL — Product Service의 상품 ID
- Field3 (product_name) — VARCHAR(255) — NOT NULL — 주문 당시 상품명
- Field4 (unit_price) — DECIMAL(15,2) — NOT NULL — 주문 당시 개당 가격
- Field5 (quantity) — INTEGER — NOT NULL
- Field6 (subtotal) — DECIMAL(15,2) — NOT NULL
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Copy Of Untitled6 (p_ai_request_logs)
- Key (ai_request_id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Field (order_id) — UUID — NOT NULL — 주문 ID
- Field3 (prompt) — UUID
- Field4 (response) — TEXT — AI 응답 전문 (원본 응답)
- Field5 (final_dispatch_deadline) — TIMESTAMP — AI가 계산한 최종 발송 시한
- Field6 (reason) — TEXT — 생성 근거
- Field7 (model_name) — VARCHAR(100) — AI 모델명
- Field8 (response_time_ms) — INTEGER
- Field9 (status) — VARCHAR(20) — AI 처리상태 (SUCCESS , FAILED )
- Field (failure_reason) — TEXT — 실패 사유
- Field (requested_at) — TIMESTAMP
- Field2 (responded_at) — TIMESTAMP
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Copy Of Untitled7 (p_delivery_route_histories)
- Key (id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Field (delivery_id) — UUID — NOT NULL — 연관된 배송 ID FK(p_deliveries)
- Field2 (sequence) — INT — NOT NULL — 배송 경로 상 허브의 순번 (시퀀스)
- Field3 (departure_hub_id) — UUID — NOT NULL — 구간 출발 허브 ID
- Field4 (arrival_hub_id) — UUID — NOT NULL — 구간 도착 허브 ID
- Field5 (estimated_distance) — DOUBLE PRECISION — 예상 거리
- Field6 (estimated_duration) — INT — 예상 소요 시간 (분 등)
- Field7 (actual_distance) — DOUBLE PRECISION — 실제 거리
- Field8 (actual_duration) — INT — 실제 소요 시간
- Field (status) — VARCHAR(50) — NOT NULL — HUB_WAITING, HUB_MOVING, DEST_HUB_ARRIVED, DELIVERY_MOVING, COMPANY_MOVING, COMPLETED
- Field2 (hub_delivery_manager_id) — UUID — 허브 배송 담당자 ID
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Untitled (p_companies)
- Key (id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Field (name) — VARCHAR(100) — NOT NULL
- Field2 (type) — VARCHAR(20) — NOT NULL — PRODUCER , RECEIVER
- Field4 (hub_id) — UUID — NOT NULL — 관리 허브 ID (hub-service의 Hub 참조
- Field3 (address) — VARCHAR(255) — NOT NULL
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Untitled2 (p_products)
- Key (id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Field (name) — VARCHAR(100) — NOT NULL
- Field5 (company_id) — UUID — NOT NULL — 업체 ID (p_companies.id 참조, FK 제약 없음)
- Field3 (hub_id) — UUID — NOT NULL — 상품 관리 허브 ID (hub-service 참조)
- Field4 (unit_price) — DECIMAL(15,2) — NOT NULL — 상품 단가 (주문 당시 가격 스냅샷 원본)
- Field2 (stock_quantity) — INTEGER — NOT NULL — 재고 수량, 기본값 0 (스펙 미명시)
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Untitled3 (p_users)
- Key (user_id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Field (username) — VARCHAR(50) — NOT NULL — UNIQUE
- Field2 (password) — VARCHAR(255) — NOT NULL
- Field3 (slack_id) — VARCHAR(50) — NOT NULL
- Field4 (user_status) — VARCHAR(20) — NOT NULL — PENDING, APPROVED, REJECTED
- Field6 (affiliation_name) — VARCHAR(255) — NOT NULL
- Field5 (affiliation_type) — VARCHAR(20) — NOT NULL
- Field7 (role) — VARCHAR(20) — NOT NULL — MASTER, HUB_MANAGER, DELIVERY_MANAGER, COMPANY_MANAGER
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Untitled4 (p_hubs)
- Key (id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Field4 (name) — VARCHAR(100) — NOT NULL — UNIQUE
- Field2 (address) — VARCHAR(255) — NOT NULL
- Field3 (latitude) — DECIMAL(10,7) — NOT NULL — CHECK(-90~90)
- Field (longitude) — DECIMAL(10,7) — NOT NULL — CHECK(-180~180)
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Untitled5 (p_orders)
- Key (order_id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Field (order_number) — VARCHAR(50) — NOT NULL — UNIQUE
- Field2 (requester_id) — UUID — NOT NULL — 주문을 생성한 사용자
- Field3 (supplier_company_id) — UUID — NOT NULL — 요청업체·공급업체 ID
- Field4 (receiver_company_id) — UUID — NOT NULL — 수령업체 ID
- Field5 (delivery_id) — UUID
- Field6 (status) — VARCHAR(30) — NOT NULL
- Field7 (request_message) — VARCHAR(500)
- Field8 (requested_delivery_at) — TIMESTAMP
- Field9 (total_amount) — DECIMAL(19,2)
- Field10 (cancel_reason) — VARCHAR(500)
- Field11 (failure_reason) — VARCHAR(500)
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Untitled6 (p_slack_messages)
- Key (slack_message_id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Field (order_id) — UUID — NOT NULL — 주문 ID
- Field2 (ai_request_id) — UUID — NOT NULL — AI 요청 ID (p_ai_request_logs 참조)
- Field3 (recipient_user_id) — UUID — NOT NULL
- Field4 (recipient_slack_id) — VARCHAR(100) — NOT NULL
- Field5 (message) — TEXT — Slack으로 발송할 메시지 내용
- Field6 (status) — VARCHAR(20) — PENDING , SENT , FAILED
- Field7 (retry_count) — INTEGER — 재시도 횟수
- Field8 (failure_reason) — TEXT
- Field9 (sent_at) — TIMESTAMP
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Copy Of Untitled7 (p_deliveries)
- Key (id) — UUID — Primary key — NOT NULL — Application Generated(UUIDv7)
- Field (order_id) — UUID — 연관된 주문 ID (Order Service 연동)
- Field2 (status) — VARCHAR(50) — NOT NULL — HUB_WAITING, HUB_MOVING, DEST_HUB_ARRIVED, DELIVERY_MOVING, COMPANY_MOVING, COMPLETED
- Field3 (departure_hub_id) — UUID — NOT NULL — 출발 허브 ID
- Field4 (arrival_hub_id) — UUID — NOT NULL — 목적지 허브 ID
- Field5 (delivery_address) — VARCHAR(255) — NOT NULL
- Field6 (receiver_name) — VARCHAR(100) — NOT NULL
- Field7 (receiver_slack_id) — VARCHAR(100) — 수령인 Slack ID (전화번호 대체)
- Field8 (delivery_manager_id) — 업체 배송 담당자 ID
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID
Untitled (default)
- Field (create_at) — TIMESTAMP — NOT NULL
- Field2 (create_by) — UUID — NOT NULL
- Field3 (updated_at) — TIMESTAMP
- Field4 (updated_by) — UUID
- Field (deleted_at) — TIMESTAMP — 삭제 시간 (soft delete, null이면 활성 상태)
- Field5 (deleted_by) — UUID