Schema

Schema

users

Name	Type	Property
id	Integer	Primary Key
email	String	Required, Unique
password	String	Required, min length: 8
firstName	String	Required
lastName	String	Required
company	Integer	Foreign Key, Required
manager	Integer	Foreign Key, Optional
team	Integer	Foreign Key, Required
date	Date	Required

• Dependent destroy Employees, Team table

companies

Name	Type	Property
id	Integer	Primary Key
name	String	Required
industry	Integer	Foreign Key, Required, Bonus
ceo	Integer	Foreign Key, Required, Bonus
date	Date	Required

industries (Bonus)

Name	Type	Property
id	Integer	Primary Key
name	String	Required

teams

Name	Type	Property
id	Integer	Primary Key
name	String	Required
company	Integer	Foreign Key, Required
date	Date	Required

• [company, name] unique

tasks

Name	Type	Property
id	Integer	Primary Key
user	Integer	Foreign Key, Required
transcript	String	Required
date	Date	Required
results	String	Required