Price level (general, student, salesitems pricelevel char 1 N 1, 2 or 3 etc) System generated unique tickets ticketid int 11 N identifier tickets eventid int 11 N fk Foreign Key to event Alphanumeric, spaces dashes for this type of ticket tickets tickettitle varchar 255 N and slashes (Balcony seats, etc.) Can be 0 Number of tickets available tickets ticketsavailabile small int 6 N 0 (unlimited) (if blank, unlimited) Number of tickets sold so tickets ticketssold small int 6 N 0 Numeric far for this ticket type for a level 1 ticket tickets price1 decimal 5,2 N (general, student, etc) tickets price2 decimal 5,2 for a level 2 ticket tickets price3 decimal 5,2 Price for a level 3 ticket Cleaned for cross site scripting. HTML allowed, no tickets ticketdescription text 4000 N javascript. Description of this ticket events eventid int 11 N System generated events schoolid int 11 N fk Foreign Key Alpha characters, periods and Name of the (Holiday events eventname varchar 80 N spaces Concert, etc) Cleaned for cross site scripting. HTML allowed, no events eventdescription text 4000 N javascript. Description of the event schools schoolid int 11 N System generated Foreign Key (State of the schools stateid small int 6 N fk school) Determins if the account has schools activated char 1 N Y/N been activated by the school Determins if the account has been approved by the site schools approved char 1 N Y/N admin System generated unique code used to link directly to schools schoolcode char 9 N the school page Alpha characters, periods and Name of the school (Valley schools schoolname varchar 80 N spaces View Elementary, etc)
salesitems pricelevel char 1 N 1, 2 or 3 Price level (general, student, etc) tickets ticketid int 11 N System generated unique identifier tickets eventid int 11 N fk Foreign Key to event tickets tickettitle varchar 255 N Alphanumeric, spaces dashes and slashes for this type of ticket (Balcony seats, etc.) tickets ticketsavailabile small int 6 N 0 Can be 0 (unlimited) Number of tickets available (if blank, unlimited) tickets ticketssold small int 6 N 0 Numeric Number of tickets sold so far for this ticket type tickets price1 decimal 5,2 N for a level 1 ticket (general, student, etc) tickets price2 decimal 5,2 for a level 2 ticket tickets price3 decimal 5,2 Price for a level 3 ticket tickets ticketdescription text 4000 N Cleaned for cross site scripting. HTML allowed, no javascript. Description of this ticket events eventid int 11 N System generated events schoolid int 11 N fk Foreign Key events eventname varchar 80 N Alpha characters, periods and spaces Name of the (Holiday Concert, etc) events eventdescription text 4000 N Cleaned for cross site scripting. HTML allowed, no javascript. Description of the event schools schoolid int 11 N System generated schools stateid small int 6 N fk Foreign Key (State of the school) schools activated char 1 N Y/N Determins if the account has been activated by the school schools approved char 1 N Y/N Determins if the account has been approved by the site admin schools schoolcode char 9 N System generated unique code used to link directly to the school page schools schoolname varchar 80 N Alpha characters, periods and spaces Name of the school (Valley View Elementary, etc)
capstone_project_example_0.docx