Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| findcode | text | 2147483647 | √ | null |
|
|
||||
| group_no | int4 | 10 | √ | null |
|
|
||||
| site_sub_div | varchar | 50 | √ | null |
|
|
||||
| piece_no | int4 | 10 | √ | null |
|
|
||||
| ml | numeric | 5,2 | √ | null |
|
|
||||
| mw | numeric | 5,2 | √ | null |
|
|
||||
| mth | numeric | 5,2 | √ | null |
|
|
||||
| comments | text | 2147483647 | √ | null |
|
|
||||
| category | varchar | 50 | √ | null |
|
|
||||
| raw_material | varchar | 20 | √ | null |
|
|
||||
| type | varchar | 20 | √ | null |
|
|
||||
| classification | varchar | 30 | √ | null |
|
|
||||
| gridsquare_no | numeric | 131089 | √ | null |
|
|
||||
| knapping_group | int4 | 10 | √ | null |
|
|
||||
| lithic_record | int4 | 10 | √ | null |
|
|
||||
| colour | varchar | 20 | √ | null |
|
|
||||
| sample_area | text | 2147483647 | √ | null |
|
|
||||
| microwear_analysis | bool | 1 | √ | null |
|
|
||||
| protein_residue_analysis | bool | 1 | √ | null |
|
|
||||
| raw_material_sourcing_analysis | bool | 1 | √ | null |
|
|
||||
| illustration | bool | 1 | √ | null |
|
|
||||
| drawing_number | varchar | 20 | √ | null |
|
|
||||
| weight | numeric | 10,2 | √ | null |
|
|
||||
| core_shape | varchar | 40 | √ | null |
|
|
||||
| recycled_material | bool | 1 | √ | null |
|
|
||||
| procent_cortext_remaining | varchar | 20 | √ | null |
|
|
||||
| discard_features | varchar | 60 | √ | null |
|
|
||||
| pebble_flint_original_pebble_size | varchar | 20 | √ | null |
|
|
||||
| flaked_pebbles_reason_discard | varchar | 20 | √ | null |
|
|
||||
| flaked_pebbles_flakes_removed | int4 | 10 | √ | null |
|
|
||||
| cortex_type | varchar | 20 | √ | null |
|
|
||||
| extent_platform_area | varchar | 20 | √ | null |
|
|
||||
| bipolar_working_stage | varchar | 40 | √ | null |
|
|
||||
| reduction_stages | int2 | 5 | √ | null |
|
|
||||
| id | int4 | 10 | √ | null |
|
|
||||
| pid | int4 | 10 | √ | null |
|
|
||||
| stage | int2 | 5 | √ | null |
|
|
||||
| scar_orientation | varchar | 40 | √ | null |
|
|
||||
| platform | varchar | 40 | √ | null |
|
|
||||
| core_platform_preparation | varchar | 20 | √ | null |
|
|
||||
| platform_features | varchar | 30 | √ | null |
|
|
||||
| core_maintenance | bool | 1 | √ | null |
|
|
||||
| number_of_blade_scars | int4 | 10 | √ | null |
|
|
||||
| number_of_flake_scars | int4 | 10 | √ | null |
|
|
||||
| maximum_blade_scar_length | numeric | 5,2 | √ | null |
|
|
||||
| maximum_blade_scar_width | numeric | 5,2 | √ | null |
|
|
||||
| maximum_flake_scar_length | numeric | 5,2 | √ | null |
|
|
||||
| maximum_flake_scar_width | numeric | 5,2 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
