SchemaSpy - Table zfindb.public.pub_correspondence_sent

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

pubcse_pk_id

bigserial

√

nextval('pub_correspondence_sent_email_pubcse_pk_id_seq'::regclass)

pub_correspondence_recipient.pubcr_recipient_sent_email_id	pub_corresspondence_recipient_sent_email_id_fk R
pub_correspondence_sent_tracker.pubcst_sent_email_id	pub_correspondence_sent_tracker_sent_email_id_fk R

pubcse_date_composed

timestamp

29,6

now()

pubcse_sent_by

text

2147483647

person.zdb_id

pubcse_sent_by_foreign_key R

pubcse_text

text

2147483647

pubcse_subject

text

2147483647

pubcse_recipient_group

text

2147483647

pubcse_pub_zdb_id

text

2147483647

publication.zdb_id

pubcse_pub_zdb_id_foreign_key_odc C

Table contained 5,255 rows at Wed Sep 15 00:41 PDT 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
pubcse_pk_id	Primary key	Asc	pub_correspondence_sent_email_pk
pubcse_sent_by + pubcse_subject + pubcse_recipient_group + pubcse_date_composed + pubcse_pub_zdb_id	Must be unique	Asc/Asc/Asc/Asc/Asc	pub_correspondence_sent_email_ak_index
pubcse_pub_zdb_id	Performance	Asc	pubcse_pub_foreign_key_index
pubcse_recipient_group	Performance	Asc	pubcse_recipient_group_id_foreign_key_index
pubcse_sent_by	Performance	Asc	pubcse_sent_by_foreign_key_index