k_entry

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
k_entry_id numeric 10 null
k_comment.k_entry_id kentry_kcomment R
k_entrycategory.k_entry_id kentry_kentrycatalog R
k_entryrelated.k_entry_id kentry_kentryrelated R
k_entryrelated.k_entryrelated_id kentry_kentryrelatedid R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
k_topic_id numeric 10 null
k_topic.k_topic_id ktopic_kentry R
rating numeric 10 null
ispublic bpchar 1 'Y'::bpchar
keywords varchar 255 √ null
k_source_id numeric 10 √ null
k_source.k_source_id ksource_kentry R
descriptionurl varchar 120 √ null
validto timestamp 29,6 √ null
ad_session_id numeric 10 √ null
ad_session.ad_session_id adsession_kentry R
textmsg varchar 2000 null
k_entry_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
k_entry_pkey Primary key Asc k_entry_id
k_entry_uu_idx Must be unique Asc k_entry_uu

Check Constraints

Constraint Name Constraint
k_entry_ispublic_check ((ispublic = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
k_entry_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation