ConOnRails_ConOnRails.sql

CREATE TABLE dbo_REGISTRATION_TYPE ( REG_TYPE_ID integer NOT NULL, YEAR integer NOT NULL, REG_TYPE char(50), MIN_BADGE_NUMBER integer, MAX_BADGE_NUMBER integer, MIN_PAYMENT_AMT numeric(19), MAX_PAYMENT_AMT numeric(19), PRIMARY KEY (REG_TYPE_ID, YEAR))
CREATE TABLE dbo_BADGE ( ATTENDEE_ID integer, YEAR integer NOT NULL, BADGE_NUMBER integer NOT NULL, BADGE_NAME char(32) NOT NULL, BADGE_PRINTED_IND boolean, SSMA_TimeStamp blob NOT NULL, CREATE_APPLICATION_NAME char(50), CREATE_DATE timestamp, UPDATE_APPLICATION_NAME char(50), UPDATE_DATE timestamp, PRIMARY KEY (YEAR, BADGE_NUMBER))
CREATE TABLE dbo_BAN ( ATTENDEE_ID integer NOT NULL, YEAR integer NOT NULL, DATE_CREATED timestamp, ACTIVE_IND boolean, COMMENTS text, SSMA_TimeStamp blob NOT NULL, CREATE_APPLICATION_NAME char(50), CREATE_DATE timestamp, UPDATE_APPLICATION_NAME char(50), UPDATE_DATE timestamp, PRIMARY KEY (ATTENDEE_ID, YEAR))
CREATE TABLE dbo_ATTENDEE_REG ( ATTENDEE_ID integer NOT NULL, YEAR integer NOT NULL, DATE_CREATED timestamp NOT NULL, AMT_PAID numeric(19) NOT NULL, WEB_TRANSACTION_ID char(50), PAYMENT_TYPE_ID integer NOT NULL, COMMENTS char(255), ATTENDEE_EMAILED_IND boolean, REG_TYPE_ID integer NOT NULL, DATE_MODIFIED timestamp, DATE_EMAIL_SENT timestamp, SSMA_TimeStamp blob NOT NULL, CREATE_APPLICATION_NAME char(50), CREATE_DATE timestamp, UPDATE_APPLICATION_NAME char(50), UPDATE_DATE timestamp, ASL_IND boolean, SEND_ART_SHOW_INFO boolean, WEB_TRANSACTION_DATE_ISSUED timestamp, REGISTRATION_PICKED_UP_IND boolean, REGISTRATION_PICKED_UP_BY char(50), REGISTRATION_PICKED_UP_DATE timestamp, VOLUNTEER_INTEREST boolean, SPECIAL_PRICING boolean, SPECIAL_PRICING_REASON char(50), PRIMARY KEY (ATTENDEE_ID, YEAR), /* Foreign keys */ FOREIGN KEY (ATTENDEE_ID) REFERENCES dbo_ATTENDEE(ATTENDEE_ID) ON DELETE NO ACTION ON UPDATE NO ACTION)
CREATE TABLE dbo_ATTENDEE ( ATTENDEE_ID integer PRIMARY KEY AUTOINCREMENT NOT NULL, FIRST_NAME char(50) NOT NULL, MIDDLE_NAME char(50), LAST_NAME char(50) NOT NULL, DATE_OF_BIRTH timestamp, COMMENTS char(100), EMAIL char(255), BAD_EMAIL_IND boolean, HOME_PHONE char(15), WORK_PHONE char(15), OTHER_PHONE char(15), ADDRESS_LINE_1 char(75), ADDRESS_LINE_2 char(50), ADDRESS_LINE_3 char(50), ADDRESS_CITY char(50), ADDRESS_STATE_CODE char(2), ADDRESS_ZIP char(20), FOREIGN_POSTAL_CODE char(12), BAD_ADDRESS_IND boolean, BAD_ADDRESS_DATE timestamp, COUNTRY_CODE char(3), NO_SEND_IND boolean, ADDRESS_TYPE_ID integer, PR_OPT_OUT_IND boolean, SSMA_TimeStamp blob NOT NULL, CREATE_APPLICATION_NAME char(50), CREATE_DATE timestamp, UPDATE_APPLICATION_NAME char(50), UPDATE_DATE timestamp, INTERNATIONAL_ADDRESS_INFO text, DECEASED boolean)