Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
Grid_square | int4 | 10 | √ | null |
|
|
||
Excavator | varchar | 50 | √ | null |
|
|
||
Issued | timestamp | 29,6 | √ | null |
|
|
||
Issued_yes | bool | 1 | √ | null |
|
|
||
Current_location | varchar | 50 | √ | null |
|
|
||
Completed | timestamp | 29,6 | √ | null |
|
|
||
Completed_yes | bool | 1 | √ | null |
|
|
||
Related cut numbers | varchar | 255 | √ | null |
|
|
||
Level_top | float8 | 17,17 | √ | null |
|
|
||
Level_base | float8 | 17,17 | √ | null |
|
|
||
Bulk_sample_numbers | varchar | 50 | √ | null |
|
|
||
Monolith_sample_numbers | varchar | 50 | √ | null |
|
|
||
Total buckets filled | int4 | 10 | √ | null |
|
|
||
1_CTX | int4 | 10 | √ | null |
|
|
||
1_thickness | float8 | 17,17 | √ | null |
|
|
||
1_grp | int4 | 10 | √ | null |
|
|
||
1_no_bkts | int4 | 10 | √ | null |
|
|
||
1_volume | int4 | 10 | √ | null |
|
|
||
1_Moved | bool | 1 | √ | null |
|
|
||
1_sieved | timestamp | 29,6 | √ | null |
|
|
||
1_drying | timestamp | 29,6 | √ | null |
|
|
||
1_complete | varchar | 50 | √ | null |
|
|
||
1_PX box | int4 | 10 | √ | null |
|
|
||
2_CTX | int4 | 10 | √ | null |
|
|
||
2_thickness | float8 | 17,17 | √ | null |
|
|
||
2_grp | int4 | 10 | √ | null |
|
|
||
2_no_bkts | int4 | 10 | √ | null |
|
|
||
2_volume | int4 | 10 | √ | null |
|
|
||
2_Moved | bool | 1 | √ | null |
|
|
||
2_sieved | timestamp | 29,6 | √ | null |
|
|
||
2_drying | timestamp | 29,6 | √ | null |
|
|
||
2_complete | varchar | 50 | √ | null |
|
|
||
2_PX box | int4 | 10 | √ | null |
|
|
||
3_CTX | varchar | 50 | √ | null |
|
|
||
3_thickness | float8 | 17,17 | √ | null |
|
|
||
3_grp | int4 | 10 | √ | null |
|
|
||
3_no_bkts | int4 | 10 | √ | null |
|
|
||
3_volume | int4 | 10 | √ | null |
|
|
||
3_Moved | bool | 1 | √ | null |
|
|
||
3_sieved | timestamp | 29,6 | √ | null |
|
|
||
3_drying | timestamp | 29,6 | √ | null |
|
|
||
3_complete | varchar | 50 | √ | null |
|
|
||
3_PX box | int4 | 10 | √ | null |
|
|
||
4_CTX | int4 | 10 | √ | null |
|
|
||
4_thickness | float8 | 17,17 | √ | null |
|
|
||
4_grp | int4 | 10 | √ | null |
|
|
||
4_no_bkts | int4 | 10 | √ | null |
|
|
||
4_volume | int4 | 10 | √ | null |
|
|
||
4_Moved | bool | 1 | √ | null |
|
|
||
4_sieved | timestamp | 29,6 | √ | null |
|
|
||
4_drying | timestamp | 29,6 | √ | null |
|
|
||
4_complete | varchar | 50 | √ | null |
|
|
||
4_PX box | int4 | 10 | √ | null |
|
|
||
5_CTX | int4 | 10 | √ | null |
|
|
||
5_thickness | float8 | 17,17 | √ | null |
|
|
||
5_grp | int4 | 10 | √ | null |
|
|
||
5_no_bkts | int4 | 10 | √ | null |
|
|
||
5_volume | int4 | 10 | √ | null |
|
|
||
5_Moved | bool | 1 | √ | null |
|
|
||
5_sieved | timestamp | 29,6 | √ | null |
|
|
||
5_drying | timestamp | 29,6 | √ | null |
|
|
||
5_complete | varchar | 50 | √ | null |
|
|
||
5_PX box | int4 | 10 | √ | null |
|
|
||
6_CTX | int4 | 10 | √ | null |
|
|
||
6_thickness | float8 | 17,17 | √ | null |
|
|
||
6_grp | int4 | 10 | √ | null |
|
|
||
6_no_bkts | int4 | 10 | √ | null |
|
|
||
6_volume | int4 | 10 | √ | null |
|
|
||
6_Moved | bool | 1 | √ | null |
|
|
||
6_sieved | timestamp | 29,6 | √ | null |
|
|
||
6_drying | timestamp | 29,6 | √ | null |
|
|
||
6_complete | varchar | 50 | √ | null |
|
|
||
6_PX box | int4 | 10 | √ | null |
|
|
||
7_CTX | int4 | 10 | √ | null |
|
|
||
7_thickness | float8 | 17,17 | √ | null |
|
|
||
7_grp | int4 | 10 | √ | null |
|
|
||
7_no_bkts | int4 | 10 | √ | null |
|
|
||
7_volume | int4 | 10 | √ | null |
|
|
||
7_Moved | bool | 1 | √ | null |
|
|
||
7_sieved | timestamp | 29,6 | √ | null |
|
|
||
7_drying | timestamp | 29,6 | √ | null |
|
|
||
7_complete | varchar | 50 | √ | null |
|
|
||
7_PX box | int4 | 10 | √ | null |
|
|
||
8_CTX | int4 | 10 | √ | null |
|
|
||
8_thickness | float8 | 17,17 | √ | null |
|
|
||
8_grp | int4 | 10 | √ | null |
|
|
||
8_no_bkts | int4 | 10 | √ | null |
|
|
||
8_volume | int4 | 10 | √ | null |
|
|
||
8_Moved | bool | 1 | √ | null |
|
|
||
8_sieved | timestamp | 29,6 | √ | null |
|
|
||
8_drying | timestamp | 29,6 | √ | null |
|
|
||
8_complete | varchar | 50 | √ | null |
|
|
||
8_PX box | int4 | 10 | √ | null |
|
|
||
9_CTX | int4 | 10 | √ | null |
|
|
||
9_thickness | float8 | 17,17 | √ | null |
|
|
||
9_grp | int4 | 10 | √ | null |
|
|
||
9_no_bkts | int4 | 10 | √ | null |
|
|
||
9_volume | int4 | 10 | √ | null |
|
|
||
9_Moved | bool | 1 | √ | null |
|
|
||
9_sieved | timestamp | 29,6 | √ | null |
|
|
||
9_drying | timestamp | 29,6 | √ | null |
|
|
||
9_complete | varchar | 50 | √ | null |
|
|
||
9_PX box | int4 | 10 | √ | null |
|
|
||
10_CTX | int4 | 10 | √ | null |
|
|
||
10_thickness | float8 | 17,17 | √ | null |
|
|
||
10_grp | int4 | 10 | √ | null |
|
|
||
10_no_bkts | int4 | 10 | √ | null |
|
|
||
10_volume | int4 | 10 | √ | null |
|
|
||
10_Moved | bool | 1 | √ | null |
|
|
||
10_sieved | timestamp | 29,6 | √ | null |
|
|
||
10_drying | timestamp | 29,6 | √ | null |
|
|
||
10_complete | varchar | 50 | √ | null |
|
|
||
10_PX box | int4 | 10 | √ | null |
|
|
||
sampletracking_id | serial | 10 | √ | nextval('tbl_sampletracking_sampletracking_id_seq'::regclass) |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
pkey_sampletracking | Primary key | Asc | sampletracking_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors