Australian Speleological Federation KID: ASF Field Definitions

Organisation Tables

There are 0 sub-tables.

OR0000: Organisation   (132 rows of data)
FID Field Type Null Key Default Extra
380 organisation_id varchar(9) NO PRI
376 organisation_country_code char(2) YES
178 organisation_code char(3) YES
390 organisation_initials varchar(8) YES
391 organisation_name varchar(60) YES
386 address_line_1 varchar(50) YES
387 address_line_2 varchar(50) YES
388 address_line_3 varchar(50) YES
389 address_line_4 varchar(50) YES
392 city varchar(25) YES
377 state_code char(2) YES
378 postcode varchar(12) YES
379 postcode_first_YN smallint(1) YES
395 address_country_code char(2) YES
506 country_name varchar(25) YES
393 organisation_coverage enum() YES
394 organisation_grouping enum() YES
381 organisation_type enum() YES
382 organisation_defunct_YN smallint(1) YES
383 final_year_if_defunct varchar(4) YES
384 current_org_id_if_defunct varchar(9) YES
416 initials_of_current_org varchar(8) YES
Back to Top




[ ASF | KID | search | help | privacy ]