Skip to content
Curtiss02 edited this page Apr 1, 2020 · 10 revisions

[Meeting Team Hong 2020 03 06]

Entities

  • User
  • Flat
  • Payment
  • User_Schedule
  • Chores

Diagram

image

Description

Flat

Represents a singular flat which contains users, payments and schedules.

User

Represents a singular flat tenant.

Primary key: username the user registers with

Payment

Represents all the payments a user can make towards the flat.

  • PaymentType: an enum of the various options a payment can be made towards

  • Recurring: an enum of the frequency of payments

    [Only needed for recurring payments]

    • Fixed: if true, the cost is the same for every recurring payment. Otherwise, variable
    • EndDate: only appears for recurring payments

For one-off payments, StartDate serves as the due date and there is no EndDate.

Description: should describe the payment to differentiate two of the same payment types if needed

User_Schedule

Represents time away from the flat or chores (to be added in the future).

The start and end date are assigned when the user selects the period of time they are away for.

Chores

Represents the chores that each user is assigned too

Has a Due date to see when the chore should be finished by and a Recurring field to see if it repeats

Clone this wiki locally