| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| pth_pk_id |
bigserial |
19 |
|
√ |
nextval('pub_tracking_history_pth_pk_id_seq'::regclass) |
|
|
| pth_pub_zdb_id |
text |
2147483647 |
|
|
|
|
|
| pth_status_id |
int8 |
19 |
|
|
|
|
|
| pth_location_id |
int8 |
19 |
√ |
|
null |
|
|
| pth_status_set_by |
text |
2147483647 |
|
|
|
|
| person.zdb_id
|
pth_status_set_by_fk R |
|
| pth_claimed_by |
text |
2147483647 |
√ |
|
null |
|
| person.zdb_id
|
pth_claimed_by_foreign_key R |
|
| pth_status_insert_date |
timestamp |
29,6 |
|
|
now() |
|
|
| pth_status_is_current |
bool |
1 |
|
|
false |
|
|
| pth_status_made_non_current_date |
timestamp |
29,6 |
√ |
|
null |
|
|
| pth_days_in_status |
int4 |
10 |
√ |
|
null |
|
|
Table contained 161,431 rows at Wed Sep 15 00:41 PDT 2021
|
