Skip to content

Instantly share code, notes, and snippets.

@owans

owans/timeoff_db.md

Last active April 16, 2019 21:38
Show Gist options
  • Save owans/dfb94f49dd580cc654c814ef5f138a31 to your computer and use it in GitHub Desktop.
Save owans/dfb94f49dd580cc654c814ef5f138a31 to your computer and use it in GitHub Desktop.
Download ZIP
A workbench image of relationship description for the timeoff_app database
Raw
timeoff_db.md

Entities:

Employee Organiation Manager Timeoff_type

Entities and data_types employee_table: id(INT), employee_id(VARCHAR), first_name(VARCHAR), last_name(VARCHAR), gender(VARCHAR), DOB(DATE), LGA(VARCHAR), state_of_origin(VARCHAR), phone_nos(VARCHAR).

organization_table: id(INT), reg_no(VARCHAR), name(VARCHAR), location(VARCHAR).

manager_table: id(INT), first_name(VARCHAR), last_name(VARCHAR), department_heading(VARCHAR), gender(VARCHAR), LGA(VARCHAR), State_of_origin(VARCHAR), phone_nos(VARCHAR).

timeoff_table: id(INT), timeoff_type(VARCHAR), start_date(DATE), end_date(DATE), duration(VARCHAR), approval status(enum: approved, rejected), fill_absence_form(boolean).

Relationships: 1:1 manager timeoff 1:M organization:employee employee:timeoff manager:employee organization:manager

`

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment