| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| pubcre_pk_id |
bigserial |
19 |
|
√ |
nextval('pub_correspondence_received_email_pubcre_pk_id_seq'::regclass) |
|
|
| pubcre_correspondence_from_first_name |
text |
2147483647 |
√ |
|
null |
|
|
| pubcre_correspondence_from_last_name |
text |
2147483647 |
√ |
|
null |
|
|
| pubcre_correspondence_from_email_address |
text |
2147483647 |
|
|
|
|
|
| pubcre_correspondence_from_person_zdb_id |
text |
2147483647 |
√ |
|
null |
|
| person.zdb_id
|
pub_correspondence_received_email_from_person_fk R |
|
| pubcre_pub_zdb_id |
text |
2147483647 |
|
|
|
|
| publication.zdb_id
|
pub_correspondence_received_email_pub_fk_odc C |
|
| pubcre_received_date |
timestamp |
29,6 |
|
|
now() |
|
|
| pubcre_text |
text |
2147483647 |
√ |
|
null |
|
|
| pubcre_subject |
text |
2147483647 |
|
|
|
|
|
| pubcre_received_by |
text |
2147483647 |
√ |
|
null |
|
|
Table contained 4,051 rows at Wed Sep 15 00:41 PDT 2021
|
