tacbaetics erd renew

Tables (14)

Area (에어리어정보)

  • Key — Long — Primary key — NOT NULL
  • Key (Key2) — Long — Foreign key → Region.Key — NOT NULL
  • Field — String

Camp (캠프정보)

  • Key — Long — Primary key — NOT NULL
  • Key (Key2) — Long — Foreign key → Area.Key — NOT NULL
  • Key (Key22) — Long — Foreign key → Area.Key — NOT NULL
  • Field — String

Customer (고객)

  • Key — Long — Primary key — NOT NULL
  • Field — String
  • Field2 — String

DeliveryDifficulty (배송난이도)

  • Key — Long — Primary key — NOT NULL
  • Field — double

DeliveryIndicator (배송지표)

  • Key — Long — Primary key — NOT NULL
  • Key (Key22) — Long — Foreign key → User.Key — NOT NULL
  • Key (Key2222) — Long — Foreign key → User.Key — NOT NULL
  • Key (Key222) — Long — Foreign key → User.Key — NOT NULL
  • Key (Key2) — Long — Foreign key → User.Key — NOT NULL
  • Field — short
  • Field2 — float
  • Field3 — short
  • Field4 — int

DeliveryPerson (배송담당자)

  • Key4 — Long — Primary key — NOT NULL
  • Key — Long — Foreign key → User.Key — NOT NULL
  • Key (Key222) — Long — Foreign key → User.Key — NOT NULL
  • Key (Key22) — Long — Foreign key → User.Key — NOT NULL
  • Key (Key2) — Long — Foreign key → User.Key — NOT NULL

DeliveryState (배송상태)

  • Key — Long — Primary key — NOT NULL
  • Field — String

Parcel (택배)

  • Key — Long — Primary key — NOT NULL
  • Key (Key3) — Long — Foreign key → Customer.Key — NOT NULL
  • Key (Key2223) — Long — Foreign key → SubRoute.Key — NOT NULL
  • Key (Key223) — Long — Foreign key → SubRoute.Key — NOT NULL
  • Key (Key23) — Long — Foreign key → SubRoute.Key — NOT NULL
  • Key (Key232) — Long — Foreign key → SubRoute.Key — NOT NULL
  • Key (Key7) — Long — Foreign key → SubRoute.Key — NOT NULL
  • Key4 (Key42) — Long — Foreign key → DeliveryPerson.Key4 — NOT NULL
  • Key (Key5) — Long — Foreign key → DeliveryState.Key — NOT NULL
  • Key (Key6) — Long — Foreign key → ShippingMethod.Key — NOT NULL
  • Field6 — String
  • Field7 — String
  • Field8 — String
  • Field14 — String
  • Field — String

Region (리전정보)

  • Key — Long — Primary key — NOT NULL
  • Field — String

Route (라우트정보)

  • Key — Long — Primary key — NOT NULL
  • Key (Key222) — Long — Foreign key → Camp.Key — NOT NULL
  • Key (Key22) — Long — Foreign key → Camp.Key — NOT NULL
  • Key (Key2) — Long — Foreign key → Camp.Key — NOT NULL
  • Key (Key3) — Long — Foreign key → DeliveryDifficulty.Key — NOT NULL
  • Field — short

ShippingMethod (배송방법)

  • Key — Long — Primary key — NOT NULL
  • Field — String

SubRoute (서브라우트정보)

  • Key — Long — Primary key — NOT NULL
  • Key (Key222) — Long — Foreign key → Route.Key — NOT NULL
  • Key (Key22) — Long — Foreign key → Route.Key — NOT NULL
  • Key (Key2) — Long — Foreign key → Route.Key — NOT NULL
  • Key (Key23) — Long — Foreign key → Route.Key — NOT NULL
  • Key (Key3) — Long — Foreign key → Route.Key — NOT NULL
  • Key4 — Long — Foreign key → DeliveryPerson.Key4 — NOT NULL
  • Field — String
  • Field2 — short

User (사용자)

  • Key — Long — Primary key — NOT NULL
  • Key (Key2) — Long — Foreign key → Camp.Key — NOT NULL
  • Key (Key22) — Long — Foreign key → Camp.Key — NOT NULL
  • Key (Key222) — Long — Foreign key → Camp.Key — NOT NULL
  • Field — String
  • Field2 — String
  • Field5 — UserRoleEnum
  • Field3 — String
  • Field4 — String
  • Field6 — String

UserRoleEnum (사용자권한)

  • Field — ENUM
  • Field2 — ENUM