TimF

Tables (9)

Charge (부담대상)

  • chIdx (Key) — INT — Primary key — NOT NULL
  • Field

Client (고객사)

  • clientIdx (Key) — INT — Primary key — NOT NULL
  • clientName (Field) — VARCHAR(15)

CsManage (CS매니저)

  • csIdx (Key) — INT — Primary key — NOT NULL
  • csName (Field) — VARCHAR(15)

Delivery (운송사)

  • deliveryIdx (Key) — INT — Primary key — NOT NULL
  • deliveryName (Field) — VARCHAR(15)

Driver (운송기사)

  • driverIdx (Key) — INT — Primary key — NOT NULL
  • deliveryIdx (Key2) — INT — Foreign key → Delivery.deliveryIdx — NOT NULL
  • deliveryIdx (Field2) — INT — NOT NULL
  • driverName (Field) — VARCHAR(15) — NOT NULL
  • cutPay (Field3) — INT

PList (패널티 종류)

  • plistIdx (Key) — INT — Primary key — NOT NULL
  • pName (Field) — VARCHAR(15)

Penalty (패널티)

  • pIdx (Key) — INT — Primary key — NOT NULL
  • plistIdx (Key2) — INT — Foreign key → PList.plistIdx — NOT NULL
  • driverIdx (Key3) — INT — Foreign key → Driver.driverIdx — NOT NULL
  • text (Field) — TEXT

Reward (배상)

  • rewardIdx (Key) — INT — Primary key — NOT NULL
  • text (Field) — TEXT

VOC

  • vocIdx (Key) — INT — Primary key — NOT NULL
  • csIdx (Key3) — INT — Foreign key → CsManage.csIdx — NOT NULL
  • rewardIdx (Key5) — INT — Foreign key → Reward.rewardIdx — NOT NULL
  • pIdx (Key6) — INT — Foreign key → Penalty.pIdx — NOT NULL
  • dpCheck (Field3) — BOOLEAN — NOT NULL
  • dpAdmit (Field) — BOOLEAN — NOT NULL