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)