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