Case 3: MySQL Database Planning

Users Table
Column Name	Constraint Type	Data Type	Size
user_id	primary key	integer	maximum
user_name	unique	varchar	30
password	not null	varchar	14
first_name	not null	varchar	30
last_name	not null	varchar	30
user_email_address	not null	varchar	55

Comments Table
Column Name	Constraint Type	Reference Table	Reference Column	Data Type	Size
comment_id	Primary Key			Integer	Maximum
user_id	foreign_key	users	user_id	integer	maximum
comment_content	not null			clob	maximum
comment_date	not null			date	date

Messages Table
Column Name	Constraint Type	Reference Table	Reference Column	Data Type	Size
message_id	primary key			integer	maximum
sender_id	foreign key	users	user_id	integer	maximum
message_content				clob	maximum
message_sent_date	not null			date	date

Lifts Table
Column Name	Constraint Type	Data Type	Size
lift_id	primary key	integer	maximum
lift_name	not null	varchar	40
lift_image_path	not null	varchar	50
lift_image_alternative_text	not null	varchar	125
lift_instruction	not null	clob	maximum