代码改变世界

Dutch App

2013-01-04 10:09  PingX  阅读(190)  评论(0编辑  收藏  举报

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)