Table JiveCore900.public.eapisjabmodules Generated by
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
id int8 19
eapisjabmodulecontent.moduleid jabmodulecontent_mid_fk R
eapisjaburlpatterns.moduleid jaburlpatterns_mid_fk R Implied Constraint R
modulename varchar 20
moduledisplayname varchar 255
creator int8 19
ispublished int4 10
ext_key varchar 255  √  null

Table contained 0 rows at Fri Jan 13 13:20 PST 2017

Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc jabmodules_pk  
ext_key Must be unique Asc eapisjabmodules_ext_key_key This unique column is also nullable
modulename Must be unique Asc eapisjabmodules_modulename_key  

Close relationships: