TACBAETICS
Tables (5)
Account (사용자)
- Key — Long — Primary key — NOT NULL
- Field — String
- Field2 — String
- Field3 — String
- Field4 — UserRoleEnum
AreaIndex (지역정보)
- Key — Long — Primary key — NOT NULL
- Field — String
- Field2 — String
- Field3 — int
- Field4 — String
Courier (택배정보)
- Key — Long — Primary key — NOT NULL
- Key (Key2) — Long — Foreign key → DeliveryAssignment.Key — NOT NULL
- Field — String
- Field2 — String
- Field3 — String
- Field4 — String
- Field5 — String
- Field6 — double
- Field7 — double
- Field8 — String
- Field9 — String
DeliveryAssignment (지역배송담당자 배정)
- Key — Long — Primary key — NOT NULL
- Key (Key2) — Long — Foreign key → Account.Key — NOT NULL
- Key (Key3) — Long — Foreign key → AreaIndex.Key — NOT NULL
UserRoleEnum (유저권한)
- Field — ENUM
- Field2 — ENUM