Table zfindb.informix.sysbldobjects 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
create_order serial8 19  √ 
bld_id char 64
sysbldregistered.bld_id Implied Constraint R
obj_kind int 10  √  0
sysbldobjkinds.obj_kind Implied Constraint R
obj_signature lvarchar 2048
obj_owner char 64  √  informix
sequence int 10  √  0
create_sql sysbldsqltext 24000  √  null
create_can_fail boolean 1  √  f
drop_sql lvarchar 2048  √  null
drop_can_fail boolean 1  √  f
alter_sql lvarchar 2048  √  null
alter_can_fail boolean 1  √  f
state char 1  √  U
temp_state char 1  √  U
final_state char 1  √  U
metadata lvarchar 2048  √  null
reserved1 varchar 255  √  null
reserved2 int 10  √  null
reserved3 int 10  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
alter_can_fail + alter_sql + create_can_fail + create_sql + drop_can_fail + drop_sql + metadata + obj_signature + create_order Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc sysbldobjindex

Close relationships: