Home

Welcome to your wiki!

This is the default page, edit it as you see fit. To add a new page simply reference it within brackets, e.g.: [SamplePage].

The wiki uses Markdown syntax.

List of pages:

• [DatabaseSchema]
• [APIsForModules]
• [ListOfFixedEmailAddresses]

Project Members:

• Andrew McCaffrey (admin)
• Julien PERUGINI (admin)
• Srini (admin)
• antoine gerardin (admin)
• ssava (admin)

[Julien PERUGINI]

CREATE TABLE DirectEmail
(
DirectEmailID varchar(255) NOT NULL,
DirectEmail varchar(255) NOT NULL,
PRIMARY KEY (DirectEmailId)
);

CREATE TABLE ContactEmail
(
ContactEmailID varchar(255) NOT NULL,
DirectEmailID varchar(255) NOT NULL,
ContactEmail varchar(255) NOT NULL,
PRIMARY KEY (ContactEmailId),
FOREIGN KEY (DirectEmailID) REFERENCES DirectEmail(DirectEmailId)
);

CREATE TABLE Users (
Username varchar(255) NOT NULL,
Password varchar(255) NOT NULL,
PRIMARY KEY (Username)
);

CREATE TABLE UserDirect (
Username varchar(255) NOT NULL,
DirectEmailID varchar(255) NOT NULL,
PRIMARY KEY (Username, DirectEmailID)
);