vEnquiryContactAddress


Columns

Column Type Size Nulls Auto Default Children Parents Comments
EnquiryID int 4 √ null
EnquiryGuessID int 4 √ null
EnquiryCommunityID int 4 √ null
EnquiryStatus varchar 8 √ null
EnquiryContactID int 4 null
EnquiryContactGuessID int 4 null
EnquiryContactCommunityID int 4 null
EnquirySurname varchar 30 √ null
EnquiryPreferred varchar 20 √ null
EnquiryGiven1 varchar 20 √ null
EnquiryGiven2 varchar 50 √ null
EnquiryBirthDate datetime 16,3 √ null
EnquiryGender varchar 15 √ null
EnquiryCategory varchar 5 √ null
EnquiryPriority varchar 3 √ null
EnquiryDate datetime 16,3 √ null
EnquiryEnrolDate datetime 16,3 √ null
EnquiryCampus varchar 3 √ null
EnquiryYearLevel smallint 2 √ null
EnquiryHouse varchar 5 √ null
EnquiryForm varchar 15 √ null
EnquiryTutor varchar 15 √ null
EnquirySuppEnrolDate1 datetime 16,3 √ null
EnquirySuppCampus1 varchar 3 √ null
EnquirySuppYearLevel1 smallint 2 √ null
EnquirySuppEnrolDate2 datetime 16,3 √ null
EnquirySuppCampus2 varchar 3 √ null
EnquirySuppYearLevel2 smallint 2 √ null
EnquirySource varchar 10 √ null
EnquirySourceComment varchar 50 √ null
EnquiryPreviousSchool varchar 15 √ null
EnquiryBoarder varchar 3 √ null
EnquiryBoarderType varchar 30 √ null
EnquiryComment varchar 2147483647 √ null
EnquiryFullFeeFlag bit 1 √ null
EnquiryContactMailName varchar 100 √ null
EnquiryContactSurname varchar 30 √ null
EnquiryContactPreferred varchar 20 √ null
EnquiryContactGiven1 varchar 20 √ null
EnquiryContactMailSalutation varchar 100 √ null
EnquiryContactAddress1 varchar 40 √ null
EnquiryContactAddress2 varchar 40 √ null
EnquiryContactAddress3 varchar 40 √ null
EnquiryContactsuburb varchar 40 √ null
EnquiryContactAddressComma varchar 200 √ null
EnquiryContactAddress varchar 200 √ null
EnquiryContactState varchar 5 √ null
EnquiryContactCountryCode varchar 5 √ null
EnquiryContactPostCode varchar 5 √ null
EnquiryContactAddressDPID varchar 8 √ null
EnquiryContactAddressDPIDBarcode varchar 60 √ null
EnquiryContactAddressSortPlanNumber varchar 3 √ null
EnquiryContactAddressPAFVersion varchar 10 √ null
EnquiryContactPhone varchar 15 √ null
EnquiryContactOccupPhone varchar 15 √ null
EnquiryContactEmail varchar 201 √ null
EnquiryContactOccupEmail varchar 100 √ null
EnquiryContactHomeEmail varchar 100 √ null
EnquiryContactFax varchar 15 √ null
ValidAddressFlag int 4 √ null
ProspectusPrintedDate datetime 16,3 √ null
EnquiryCampusDescription varchar 30 √ null
EnquiryCampusHeadOfCampus varchar 30 √ null
EnquiryCampusSort int 4 √ null
EnquiryYearLevelDescription varchar 30 √ null
EnquiryYearLevelCoordinator varchar 30 √ null
EnquiryYearLevelSort smallint 2 √ null
EnquiryYearLevelGroup varchar 15 √ null
EnquiryYearLevelGroupDescription varchar 50 √ null
EnquiryYearLevelSubSchool varchar 15 √ null
EnquiryYearLevelSubSchoolDescription varchar 100 √ null
EnquiryHouseDescription varchar 30 √ null
EnquiryHouseHeadOfHouse varchar 100 √ null
EnquirySourceDescription varchar 50 √ null
EnquiryReligionCode varchar 5 √ null
EnquiryReligionDescription varchar 40 √ null
EnquiryContactReligionCode varchar 5 √ null
EnquiryContactReligionDesciption varchar 40 √ null
EnquiryContactSpouseReligionCode varchar 5 √ null
EnquiryContactSpouseReligionDescription varchar 40 √ null
EnquiryContactStudentRelationshipCode varchar 5 √ null
EnquiryContactStudentRelationshipDescription varchar 30 √ null
EnquiryContactSpouseStudentRelationshipCode varchar 5 √ null
EnquiryContactSpouseStudentRelationshipDescription varchar 30 √ null
EnquiryContactContactSpouseRelationshipCode varchar 5 null
EnquiryContactContactSpouseRelationshipDescription varchar 30 √ null
SpouseID int 4 √ null
SpouseGuessID int 4 null
EnquiryContactSpouseSurname varchar 30 √ null
EnquiryContactSpouseInitials varchar 15 √ null
EnquiryContactSpouseTitle varchar 30 √ null
EnquiryContactSpouseSuffix varchar 20 √ null
EnquiryContactSpousePreferred varchar 20 √ null
EnquiryContactSpouseGiven1 varchar 20 √ null
EnquiryContactSpouseGiven2 varchar 50 √ null
EnquiryContactSpouseGender varchar 15 √ null
EnquiryContactSpouseOccupPhone varchar 15 √ null
EnquiryContactSpouseEmail varchar 201 √ null
EnquiryContactSpouseOccupEmail varchar 100 √ null
EnquiryContactSpouseHomeEmail varchar 100 √ null
EnquiryGenderSynergyMeaning varchar 30 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views