Identification of data structures

user
#ID_user PK	int
*name	varchar
*surname	varchar
*email_adress	varchar
*User_type FK	int

                                                                                 

Message
#ID_email PK	int
* content	varchar
*email_adress_sender FK	varchar
*email_adress_receiver FK	varchar

Drafts
#ID_draft PK	int
*ID_user FK	int
content_draft	varchar

File
#ID_file PK	int
*ID_Message FK	int
*content_file	varchar

User_type
#ID_user_type PK	int
*name	varchar

Based on the system functions I saw earlier, I created the first version of the email database. I declared the attributes and data types in each database. My work will help my teammates during their part of work.