The script should contain four Tables, User, Channel, User Channel, and Message
The User table should have these attributes:
username, password, firstname, lastname, email, address, city, state, postal code, country. All of which must be strings. The PRIMARY KEY is the username.
The Channel table should have these attributes:
channel ID which is an int, channel name, creator username, both of which will be strings.
The foreign key will be the creator username it should reference the username in the User table and the PRIMARY KEY for this table is the channel ID
The User Channel table is for keeping track of the channels that each user in a part of should have
username which is a string, channel ID as an int, a boolean variable called isAdmin. The primary key is the username and the channel id which refer to User.username and Channel.channelID.
The Message table should have
messageID an integer and the primary key, senderUsername a string foreign key that references User(username), channel ID an integer foreign key that references Channel(channelID), receiver username a string that references User(username), content a text, timeSent TIMESTAMP which is the time the message was sent.
The script should contain four Tables, User, Channel, User Channel, and Message
The User table should have these attributes: username, password, firstname, lastname, email, address, city, state, postal code, country. All of which must be strings. The PRIMARY KEY is the username.
The Channel table should have these attributes: channel ID which is an int, channel name, creator username, both of which will be strings. The foreign key will be the creator username it should reference the username in the User table and the PRIMARY KEY for this table is the channel ID
The User Channel table is for keeping track of the channels that each user in a part of should have username which is a string, channel ID as an int, a boolean variable called isAdmin. The primary key is the username and the channel id which refer to User.username and Channel.channelID.
The Message table should have messageID an integer and the primary key, senderUsername a string foreign key that references User(username), channel ID an integer foreign key that references Channel(channelID), receiver username a string that references User(username), content a text, timeSent TIMESTAMP which is the time the message was sent.