Australian Speleological Federation KID: ASF Field Definitions

Person Tables

There are 0 sub-tables.

PE0000: Person   (1319 rows of data)
FID Field Type Null Key Default Extra
478 person_id varchar(10) NO PRI
479 surname varchar(30) YES
480 usual_first_name varchar(20) YES
481 middle_initial varchar(5) YES
482 initials_for_given_names varchar(10) YES
483 title varchar(20) YES
484 address_line_1 varchar(50) YES
485 address_line_2 varchar(50) YES
486 address_line_3 varchar(50) YES
487 address_line_4 varchar(50) YES
488 city_or_suburb varchar(25) YES
490 state_code char(2) YES
491 postcode varchar(12) YES
492 country_name varchar(25) YES
493 country_code char(2) YES
494 email_address varchar(30) YES
495 phone_numbers_prefix varchar(15) YES
496 home_phone_number varchar(18) YES
497 work_phone_number varchar(18) YES
498 mobile_phone_number varchar(18) YES
499 fax_phone_number varchar(18) YES
500 pager_phone_user_number varchar(20) YES
501 organisation_code_1 char(3) YES
502 organisation_code_2 char(3) YES
503 organisation_code_3 char(3) YES
Back to Top




[ ASF | KID | search | help | privacy ]