SchemaSpy - Table zfindb.informix.transcript

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

tscriptt_pk_id

serial8

√

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

tscriptt_display

varchar

tscriptt_definition

lvarchar

2048

√

null

tscriptt_order

int

√

null

tscriptt_indent

boolean

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