msa
Tables (10)
DeliveryInfo (Untitled12)
- deliveryInfo_id (Key) — Primary key — NOT NULL
- delivery_state (Field)
- start_hub_id (Field2)
- end_hub_id (Field3)
- receiver_store_address (Field4)
- receiver_store_user_id (Field5)
- receiver_store_user_slack_id (Field6)
DeliveryRouteInfo (Untitled14)
- deliveryRouteInfo_id (Key) — Primary key — NOT NULL
- route_sequence (Field)
- start_hub_id (Field2)
- end_hub_id (Field3)
- estimated_time (Field4)
- estimated_distance (Field5)
- actual_time (Field6)
- actual_distance (Field7)
- current_state (Field8)
- deliveryInfo_id (Key2) — Foreign key → DeliveryInfo.deliveryInfo_id — NOT NULL
- hub_route_id (Key3) — Foreign key → HubRoutes.hub_route_id — NOT NULL
HubDeliveryManagers (Untitled6)
- 유저Id (Key) — Foreign key → Users.유저Id — NOT NULL
- slack_id (Field)
- delivery_type (Field2)
- is_deleted (Field3)
- 소속허브Id (hub_id2) — Foreign key → Hubs.허브Id — NOT NULL
HubRoutes (Untitled2)
- hub_route_id (Key) — Primary key — NOT NULL
- start_hub_id (hub_id) — Foreign key → Hubs.허브Id — NOT NULL
- end_hub_id (hub_id2) — Foreign key → Hubs.허브Id — NOT NULL
- distance (Field4)
- driving_time (Field5)
- route_name (Field6)
- is_deleted (Field)
Hubs (Untitled)
- 허브Id (hub_id) — Primary key — NOT NULL
- name (Field)
- hub_routes (Field6)
- dosi (Field2)
- is_deleted (Field3)
- city (Field4)
- street (Field5)
- detail_address (Field7)
OrderProduct (Untitled3)
- order_product_id (Key) — Primary key — NOT NULL
- order_id (Key3) — Foreign key → Orders.order_id — NOT NULL
- product_id (Key2) — Foreign key → Products.product_id — NOT NULL
- product_quantity (Field)
Orders (Untitled9)
- order_id (Key) — Primary key — NOT NULL
- 유저Id (Key4) — Foreign key → Users.유저Id — NOT NULL
- deliveryInfo_id (Key2) — Foreign key → DeliveryInfo.deliveryInfo_id — NOT NULL
- sender_store_id (Field)
- receiver_store_id (Field4)
- product_id (Field3)
- product_quantity (Field5)
Products (Untitled8)
- product_id (Key) — Primary key — NOT NULL
- product_name (Field)
- quantity (Field2)
- is_deleted (Field3)
- store_id (Key2) — Foreign key → Store.store_id — NOT NULL
- 허브Id (hub_id) — Foreign key → Hubs.허브Id — NOT NULL
Store (Untitled7)
- store_id (Key) — Primary key — NOT NULL
- store_name (Field)
- store_type (Field2)
- dosi (Field3)
- city (Field4)
- street (Field5)
- detail_address (Field6)
- 소속허브Id (hub_id) — Foreign key → Hubs.허브Id — NOT NULL
- 유저Id (Key2) — Foreign key → Users.유저Id — NOT NULL
Users (Untitled4)
- 유저Id (Key) — Primary key — NOT NULL
- username (Field)
- password (Field4)
- user_role (Field2)
- is_deleted (Field3)