User

Table

users

Attributes

Name Type Nullable Description
id UNSIGNED BIGINT No primary key (auto-increment)
name_first VARCHAR(255) No
name_last VARCHAR(255) No
email VARCHAR(255) No
is_active BOOLEAN No
is_auto_submitting BOOLEAN No
is_employee BOOLEAN No
is_manager BOOLEAN No
is_name_ambiguous BOOLEAN No
is_remote_capable BOOLEAN No
is_student BOOLEAN No
created_at TIMESTAMP Yes
updated_at TIMESTAMP Yes
deleted_at TIMESTAMP Yes

Relationships

  • User has many Billing
  • User has many Comment
  • User has many Roster
  • User has many Shift
  • User has many ShiftOffer
  • User has many Unavailability