Table webco_4.7.public.custom_property 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
obj_oid int8 19
custom_property_booleans.custom_property_oid custom_property_booleans_custom_property_oid_fkey
custom_property_integers.custom_property_oid custom_property_integers_custom_property_oid_fkey
custom_property_money.custom_property_oid custom_property_money_custom_property_oid_fkey
custom_property_strings.custom_property_oid custom_property_strings_custom_property_oid_fkey
custom_property_timestamps.custom_property_oid custom_property_timestamps_custom_property_oid_fkey
entity_class cl_class 2147483647
property_name varchar 2147483647
sort_order int4 10  √  null
label varchar 2147483647
property_type wcof_property_type 2147483647
query_terms bool 1  √  null
result_column bool 1  √  null
less_equal_term varchar 2147483647  √  null
greater_equal_term varchar 2147483647  √  null
equal_term varchar 2147483647  √  null
substring_term varchar 2147483647  √  null

Table contained 0 rows at Thu Feb 14 09:20 CST 2019

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc custom_property_pkey
entity_class + property_name Must be unique Asc/Asc custom_property_entity_class_property_name_key

Close relationships: