Identification of data structures
| user |
|
| #ID_user PK |
int |
| *name |
varchar |
| *surname |
varchar |
| *email_adress | varchar |
| *User_type FK |
int |
| Email |
|
| #ID_email PK |
int |
| * content |
varchar |
| *ID_sender FK |
int |
| *ID_receiver FK |
int |
| Inbox |
|
| #ID_inbox PK |
int |
| *ID_user FK |
int |
| Drafts |
|
| #ID_draft PK |
int |
| *ID_Inbox FK |
int |
| content_draft |
varchar |
| User_type |
|
| #ID_user_type PK |
int |
| *name |
varchar |