Roster

Table

rosters

Attributes

Name	Type	Nullable	Description
id	UNSIGNED BIGINT	No	primary key (auto-increment)
user_id	UNSIGNED BIGINT	No	foreign key
year		No
week		No
comment	VARCHAR(255)	Yes
mailed_at	TIMESTAMP	Yes
created_at	TIMESTAMP	Yes
updated_at	TIMESTAMP	Yes

Relationships

• Roster belongs to User
• Roster has many Shift