SchemaSpy - Table zfindb.informix.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

serial8

√

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

datetime year to second

current

pubcse_sent_by

varchar

person.zdb_id

pubcse_sent_by_foreign_key R

pubcse_text

lvarchar

10000

pubcse_subject

varchar

100

pubcse_recipient_group

varchar

100

pubcse_pub_zdb_id

varchar

publication.zdb_id

pubcse_pub_zdb_id_foreign_key_odc C

Table contained 753 rows at Thu Jun 22 08:42 PDT 2017

Indexes:

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