Random generated to be used at the event to validate the tickets. Each ticket will have a unique key that defines that very specific ticket (event, date and quantity). This will be used to validate tickets at the event and ensure duplicate invoice varchar 14 N tickets are not printed off. sales decimal 7,2 N Sum of all items sales transaction varchar 80 N Transaction ID from Paypal Valid email sales email varchar 80 N address Email of customer Must be a current sales date datetime N date/time Sales date/time Alpha characters, periods and sales firstname varchar 25 N spaces First name of customer Alpha characters, periods and lastname varchar 25 N spaces Last name of customer Alphanumeric characters, periods and Address of buyer from address varchar 40 spaces Paypal Alpha sales city varchar 25 characters City of buyer from Paypal state varchar 25 characters State of buyer from Paypal sales zip varchar 5 Numbers Zip of buyer from Paypal Numbers, dashes, periods and sales varchar 12 N parenthesis Phone of customer Set to 'Y' once Paypal IPN sales validated char 1 Y/N returns System generated unique identifier of this specific ticket (event, date and salesitems salesitemid int 11 N quantity) salesitems salesid int 11 N fk Foreign Key to sales record salesitems ticketid int 11 N fk Foreign Key to ticket record Number of tickets salesitems quantity tiny int 4 N purchased
invoice varchar 14 N Random generated to be used at the event to validate the tickets. Each ticket will have a unique key that defines that very specific ticket (event, date and quantity). This will be used to validate tickets at the event and ensure duplicate tickets are not printed off. sales decimal 7,2 N Sum of all items sales transaction varchar 80 N Transaction ID from Paypal sales email varchar 80 N Valid email address Email of customer sales date datetime N Must be a current date/time Sales date/time sales firstname varchar 25 N Alpha characters, periods and spaces First name of customer lastname varchar 25 N Alpha characters, periods and spaces Last name of customer address varchar 40 Alphanumeric characters, periods and spaces Address of buyer from Paypal sales city varchar 25 Alpha characters City of buyer from Paypal state varchar 25 characters State of buyer from Paypal sales zip varchar 5 Numbers Zip of buyer from Paypal sales varchar 12 N Numbers, dashes, periods and parenthesis Phone of customer sales validated char 1 Y/N Set to 'Y' once Paypal IPN returns salesitems salesitemid int 11 N System generated unique identifier of this specific ticket (event, date and quantity) salesitems salesid int 11 N fk Foreign Key to sales record salesitems ticketid int 11 N fk Foreign Key to ticket record salesitems quantity tiny int 4 N Number of tickets purchased
capstone_project_example_0.docx