ShiftUpdate

Table

shift_updates

Attributes

Name	Type	Nullable	Description
id	UNSIGNED BIGINT	No	primary key (auto-increment)
shift1_id	UNSIGNED BIGINT	Yes	foreign key
shift2_id	UNSIGNED BIGINT	Yes	foreign key
user_id	UNSIGNED BIGINT	Yes	foreign key
created_at	TIMESTAMP	Yes
updated_at	TIMESTAMP	Yes
deleted_at	TIMESTAMP	Yes

Relationships

• ShiftUpdate belongs to Shift (ShiftOld1)
• ShiftUpdate belongs to Shift (ShiftOld2)
• ShiftUpdate belongs to User
• ShiftUpdate has many Shift (ShiftsNew)