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