ShiftOffer

Table

shift_offers

Attributes

Name	Type	Nullable	Description
id	UNSIGNED BIGINT	No	primary key (auto-increment)
schedule_id	UNSIGNED BIGINT	No	foreign key
user_id	UNSIGNED BIGINT	No	foreign key
date	DATE	No
is_remote	BOOLEAN	No
comment	VARCHAR(255)	Yes
preference_level		No
created_at	TIMESTAMP	Yes
updated_at	TIMESTAMP	Yes
deleted_at	TIMESTAMP	Yes

Relationships

• ShiftOffer belongs to Schedule
• ShiftOffer belongs to User
• ShiftOffer has one Shift