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