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