| Table: site | |||||
| Field | Type | Null | Key | Default | Extra |
| site | varchar(10) | Yes | Null | ||
| sector | char(2) | Yes | Null | ||
| utm_north | int(11) | Yes | Null | ||
| utm_east | int(11) | Yes | Null | ||
| elevation | int(11) | Yes | Null | ||
| area | float(5,2) | Yes | Null | ||
| phase | char(3) | Yes | Null | ||
| zone | varchar(255) | Yes | Null | ||
| type | varchar(255 | Yes | Null | ||
| prefix | varchar(10) | Yes | Null | ||
| area_corrected | float(5,2) | Yes | Null | ||
| pop_index | float(5,2) | Yes | Null |
| Table: surface_ceramics | |||||
| Field | Type | Null | Key | Default | Extra |
| locus | int(11) | Yes | Null | ||
| paste_group | varchar(100) | Yes | Null | ||
| painted_sherd | int(11) | Yes | Null | ||
| rim_shirds | int(11) | Yes | Null | ||
| incised_sherds | int(11) | Yes | Null | ||
| other_diag_sherds | int(11) | Yes | Null | ||
| plain_body_sherds | int(11) | Yes | Null | ||
| total_sherds | int(11) | Yes | Null |
| Table: surface_collection | |||||
| Field | Type | Null | Key | Default | Extra |
| site | int(11) | Yes | Null | ||
| locus | int(11) | Yes | Null | ||
| area | float(5,2) | Yes | Null | ||
| north | float(5,2) | Yes | Null | ||
| east | float(5,2) | Yes | Null | ||
| real_north | float(5,2) | Yes | Null | ||
| real_east | float(5,2) | Yes | Null | ||
| ceramic_bags | int(11) | Yes | Null | ||
| lithic_bags | int(11) | Yes | Null | ||
| other_bags | int(11) | Yes | Null | ||
| ground_cover | varchar(255) | Yes | Null | ||
| more_info | varchar(255) | Yes | Null | ||
| prefix | varchar(10) | Yes | Null |