Skip to content
This repository was archived by the owner on May 19, 2023. It is now read-only.

Database Object Structure Proposal

Rajesh Hadiya edited this page Aug 25, 2022 · 5 revisions
enum class Color {
White, Black, Red, Greed, Yellow, Purpule,...
}
Object: Note {
     noteId: Long,
     title: String?,
     content: String,
     folderId: Long?,
     archived: Boolean,
     archivedOn: Instant?,
     color: Color?,
     createdOn: Instant,
     updatedOn: Instant,
}
Object: Reminder {
     reminderId: Long,
     message: String,
     datetime: Instant,
     repeat: String, ["None", "Daily", "Weekly", "Monthly", "Yearly"]
     repeatUntil: String, ["Forever", "Until a particular date", "For a number of events"]
     repeatUntilDate: Instant,
     repeatUntilNumberOfEvents: Int,
     repeatedEventCounts: Int,
     cancelled: Boolean,
     cancelledOn: Instant,
     completed: Boolean,
     completedOn: Instant,
     folderId: Long?,
     color: Color,
     createdOn: Instant,
     updatedOn: Instant
}
Object: NoteFolder {
    folderId: Long,
    name: String,
    description: String,
    notes: List<Note>,
    color: Color,
    createdOn : Instant,
    updatedOn : Instant
}
Object: ReminderFolder {
    folderId: Long,
    name: String,
    description: String,
    reminders: List<Reminder>,
    color: Color,
    createdOn : Instant,
    updatedOn : Instant
}

Clone this wiki locally