Table zfindb.informix.transcript_type Generated by
SchemaSpy
Legend: SourceForge.net
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
tscriptt_pk_id serial8 19  √ 
int_vegatype_tscripttype.ivtst_tscriptt_type_id ivtst_tscriptt_type_id_foreign_key R
transcript.tscript_type_id tscritp_type_foreign_key R
tscript_type_status_definition.ttsdef_tscript_type_id ttsdef_tscript_type_id_foreign_key_constraint R
tscriptt_type varchar 60
tscriptt_display varchar 60
tscriptt_definition lvarchar 2048  √  null
tscriptt_order int 10  √  null
tscriptt_indent boolean 1 f

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

Indexes:
Column(s) Type Sort Constraint Name
tscriptt_definition + tscriptt_indent + tscriptt_type Must be unique Asc/Asc/Asc tscriptt_type_alternate_key_index
tscriptt_definition + tscriptt_indent + tscriptt_pk_id Must be unique Asc/Asc/Asc tscriptt_type_primary_key_index

Close relationships  within of separation: