Requirement:
1. Support go Dutch Event. Calculate the average/pay part of each staff.
2. Event support Peroid.
3. JSON Storage?
Layout:
Events | Staffs |
Event Info | FeeItems | Staffs |
Fee Item Info | PayItems |
Entity:
Staff:ID/Name/Phone/etc.
PayItem:ID/Staff/Amount
Event:ID/Name/Locations/DateFrom/DateTo/FullDay/Staffs/FeeItems
FeeItem:ID/Name/Amount/Location/OccurTime/Staffs/PayItems
Table:
Staff
PayItem
FeeItem/FeeItemDtl(FeeItemID/Name(StaffID/PayItemID)/Value)
Event/EventDtl(EventID/Name(StaffID/FeeItemID)/Value)