Shift

Table

shifts

Attributes

Name	Type	Nullable	Description
id	UNSIGNED BIGINT	No	primary key (auto-increment)
compensation_id	UNSIGNED BIGINT	No	foreign key
roster_id	UNSIGNED BIGINT	No	foreign key
schedule_id	UNSIGNED BIGINT	Yes	foreign key
shift_offer_id	UNSIGNED BIGINT	Yes	foreign key
shift_update_id	UNSIGNED BIGINT	Yes	foreign key
user_id	UNSIGNED BIGINT	No	foreign key
date	DATE	No
time_start	TIME	Yes
time_end	TIME	Yes
is_remote	BOOLEAN	No
comment	VARCHAR(255)	Yes
compensation_factor		Yes
created_at	TIMESTAMP	Yes
updated_at	TIMESTAMP	Yes
deleted_at	TIMESTAMP	Yes

Relationships

• Shift belongs to Compensation
• Shift belongs to Roster
• Shift belongs to Schedule
• Shift belongs to ShiftOffer
• Shift belongs to ShiftUpdate
• Shift belongs to User