TA_1

create database TA_45369;
use TA_45369;

create table Me(
my_id int not null auto_increment,
first_name varchar(25),
last_name varchar(25),
primary key(my_id));

create table Social_Networks(
network_code int not null auto_increment,
network_name varchar(25) not null,
network_description varchar(50) not null,
primary key(network_code));

create table My_Email_Logins(
my_login int not null auto_increment,
my_id_E int,
network_code_E int,
date_signed_up datetime,
my_email_name varchar(25),
my_email_password varchar(64),
primary key(my_login),
constraint fk_my_email_1 foreign key(my_id_E) references Me(my_id),
constraint fk_my_email_2 foreign key(network_code_E) references Social_Networks(network_code));

create table Mail_Boxes(
mail_id int not null auto_increment,
my_login_MB int,
date_recieved datetime,
from_email_address varchar(25),
from_name varchar(25),
subject varchar(25),
message varchar(100),
primary key(mail_id),
constraint fk_mail_boxes foreign key(my_login_MB) references My_Email_Logins(my_login));

create table Sent_Messages(
message_id int not null auto_increment,
my_login_SM int,
date_sent datetime,
to_email_address varchar(25),
subject varchar(25),
message varchar(100),
primary key(message_id),
constraint fk_sent_message foreign key(my_login_SM) references My_Email_Logins(my_login));

create table Notifications(
notification_id int not null auto_increment,
my_login_N int,
date_recieved datetime,
subject varchar(25),
message varchar(100),
primary key(notification_id),
constraint fk_notifications foreign key(my_login_N) references My_Email_Logins(my_login));

create table Updates(
update_id int not null auto_increment,
my_login_U int,
date_recieved datetime,
subject varchar(25),
message varchar(100),
primary key(update_id),
constraint fk_update foreign key(my_login_U) references My_Email_Logins(my_login));