Database Design

This document contains a description of the tables in the database and their attributes.

Attributes Key: Field Name Field Type - Description/Additional Notes

Conference

Attributes:

• conference_id int - Conference Identifier, Primary Key
• floor_plan varchar(45) - Link to image of conference floor plan, Primary Key
• conference_name varchar(45) - Conference name
• start_date date - Start Date of Conference
• end_date date - End Date of Conference
• location varchar(45) - Address of Conference
• logo_url varchar(45) - imgur link to logo for conference

News

Attributes:

• conference int - CConference where event is happening, Foreign Key
• title varchar(50) - Event name
• logo_url varchar(45) - link to url of company hosting event
• text varchar(150) - Description of event/Body text
• author varchar(45) - Event creator