CA0000: Cave master table (6955 rows of data)
| FID |
Field |
Type |
Null |
Key |
Default |
Extra |
| 227 |
cave_id |
varchar(10) |
NO |
PRI |
|
|
| 1 |
karst_feature_type |
enum() |
YES |
|
|
|
| 9 |
quantity_of_entrances |
smallint(3) |
YES |
|
|
|
| 10 |
entrance_type |
enum() |
YES |
|
|
|
| 2 |
submersion |
enum() |
YES |
|
|
|
| 20 |
penetrability |
enum() |
YES |
|
|
|
| 3 |
flow_presence |
enum() |
YES |
|
|
|
| 4 |
flow_direction |
enum() |
YES |
|
|
|
| 5 |
internal_flow |
enum() |
YES |
|
|
|
| 6 |
internal_water |
enum() |
YES |
|
|
|
| 56 |
length |
decimal(10,1) |
YES |
|
|
|
| 57 |
length_method |
enum() |
YES |
|
|
|
| 58 |
length_accuracy |
decimal(10,2) |
YES |
|
|
|
| 511 |
vertical_extent |
decimal(7,2) |
YES |
|
|
|
| 59 |
extent_below_entrance |
decimal(8,2) |
YES |
|
|
|
| 60 |
extent_above_entrance |
decimal(8,2) |
YES |
|
|
|
| 61 |
vertical_method |
enum() |
YES |
|
|
|
| 62 |
vertical_accuracy |
decimal(7,2) |
YES |
|
|
|
| 63 |
length_of_largest_chamber |
decimal(8,2) |
YES |
|
|
|
| 64 |
width_of_largest_chamber |
decimal(8,2) |
YES |
|
|
|
| 65 |
height_of_largest_chamber |
decimal(8,2) |
YES |
|
|
|
| 67 |
extent_length |
decimal(8,1) |
YES |
|
|
|
| 68 |
extent_width |
decimal(8,1) |
YES |
|
|
|
| 297 |
length_category |
enum() |
YES |
|
|
|
| 527 |
depth_category |
enum() |
YES |
|
|
|
| 21 |
latitude_coarse |
decimal(8,4) |
YES |
|
|
|
| 22 |
longitude_coarse |
decimal(9,4) |
YES |
|
|
|
| 23 |
map_sheet_name_coarse |
varchar(30) |
YES |
|
|
|
| 26 |
grid_reference_coarse |
varchar(4) |
YES |
|
|
|
| 25 |
grref_qualifier_coarse |
varchar(4) |
YES |
|
|
|
| 27 |
nearest_locality |
varchar(30) |
YES |
|
|
|
| 28 |
altitude_coarse |
decimal(7,1) |
YES |
|
|
|
| 29 |
degree_explored |
enum() |
YES |
|
|
|
| 42 |
owner_type |
enum() |
YES |
|
|
|
| 44 |
management_classifier |
varchar(8) |
YES |
|
|
|
| 45 |
management_category |
enum() |
YES |
|
|
|
| 47 |
controller |
varchar(8) |
YES |
|
|
|
| 54 |
percent_mapped |
smallint(4) |
YES |
|
|
|
| 78 |
entrance_marking |
enum() |
YES |
|
|
|
| 13 |
minimum_temperature |
decimal(5,1) |
YES |
|
|
|
| 14 |
maximum_temperature |
decimal(5,1) |
YES |
|
|
|
| 15 |
minimum_humidity |
decimal(6,1) |
YES |
|
|
|
| 16 |
maximum_humidity |
decimal(6,1) |
YES |
|
|
|
| 17 |
moisture_level |
enum() |
YES |
|
|
|
| 228 |
owner_person_id |
varchar(10) |
YES |
|
|
|
| 417 |
owner_organisation_id |
varchar(9) |
YES |
|
|
|
| 418 |
owner_name |
varchar(60) |
YES |
|
|
|
| 229 |
local_government_area |
varchar(30) |
YES |
|
|
|
| 230 |
update_status |
char(2) |
YES |
|
|
|
| 220 |
country_in_cave_number |
char(2) |
YES |
|
|
|
| 18 |
state_in_cave_number |
enum() |
YES |
|
|
|
| 19 |
area_in_cave_number |
char(3) |
YES |
|
|
|
| 77 |
serial_in_cave_number |
varchar(11) |
YES |
|
|
|
| 303 |
area_lookup |
varchar(7) |
YES |
|
|
|
|
»------» |
CA0030: Cave discovery (2417 rows of data)
| FID |
Field |
Type |
Null |
Key |
Default |
Extra |
| 227 |
cave_id |
varchar(10) |
NO |
PRI |
|
|
|
value_sequence |
smallint(5) |
NO |
PRI |
|
|
| 30 |
discoverer_type |
enum() |
YES |
|
|
|
| 419 |
discoverer_person_id |
varchar(10) |
YES |
|
|
|
| 522 |
discoverer_surname |
varchar(30) |
YES |
|
|
|
| 523 |
discoverer_firstname |
varchar(20) |
YES |
|
|
|
| 420 |
discoverer_org_id |
varchar(9) |
YES |
|
|
|
| 524 |
discoverer_org_initials |
varchar(8) |
YES |
|
|
|
| 31 |
discoverer_name |
varchar(45) |
YES |
|
|
|
| 34 |
discoverer_year |
varchar(4) |
YES |
|
|
|
| 33 |
discoverer_month |
char(2) |
YES |
|
|
|
| 32 |
discoverer_day |
char(2) |
YES |
|
|
|
| 477 |
discoverer_date_qualifier |
char(2) |
YES |
|
|
|
|