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 |
|
|
||||
| pid | int4 | 10 | √ | null |
|
|
||||
| debitage_sub_classification | varchar | 20 | √ | null |
|
|
||||
| fragmentation | varchar | 40 | √ | null |
|
|
||||
| length | numeric | 10,2 | √ | null |
|
|
||||
| breadth | numeric | 10,2 | √ | null |
|
|
||||
| thickness | numeric | 10,2 | √ | null |
|
|
||||
| l_b_ratios | varchar | 100 | √ | null |
|
|
||||
| condition | varchar | 20 | √ | null |
|
|
||||
| patination | bool | 1 | √ | null |
|
|
||||
| reduction | varchar | 20 | √ | null |
|
|
||||
| number_of_dorsal_scars | int4 | 10 | √ | null |
|
|
||||
| dorsal_scar_direction | varchar | 40 | √ | null |
|
|
||||
| termination_type | varchar | 20 | √ | null |
|
|
||||
| bulb_type | varchar | 20 | √ | null |
|
|
||||
| platform_type | varchar | 20 | √ | null |
|
|
||||
| debitage_platform_preparation | varchar | 20 | √ | null |
|
|
||||
| platform_width | numeric | 10,2 | √ | null |
|
|
||||
| platform_thickness | numeric | 10,2 | √ | null |
|
|
||||
| pw_pt | varchar | 100 | √ | null |
|
|
||||
| crested_blades_sub_classification | varchar | 40 | √ | null |
|
|
||||
| refits_with | int4 | 10 | √ | null |
|
|
||||
| refits_with_findcode | text | 2147483647 | √ | null |
|
|
||||
| features | varchar | 30 | √ | null |
|
|
||||
| core_trimming_sub_classifications | text | 2147483647 | √ | null |
|
|
||||
| core_trimming_dorsal_face_morphology | text | 2147483647 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
