cm_container

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cm_container_id numeric 10 null
cm_accesscontainer.cm_container_id cmcontainer_cmaccesscontainer C
cm_container.cm_containerlink_id cmcontainer_cmcontainerlink N
cm_container_element.cm_container_id cmcontainer_cmcontainerelement C
cm_container_trl.cm_container_id cmcontainer_cmcontainertrl C
cm_container_url.cm_container_id cmcontainer_cmcontainerurl C
cm_containerttable.cm_container_id cmcontainer_cmcontainerttable C
cm_webproject_domain.cm_container_id cmcontainer_cmwebprojectdomain C
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
description varchar 2000 √ null
help varchar 2000 √ null
cm_webproject_id numeric 10 null
cm_webproject.cm_webproject_id cmwebproject_cmcontainer C
cm_template_id numeric 10 √ null
cm_template.cm_template_id cmtemplate_cmcontainer R
title varchar 60 √ null
notice varchar 2000 √ null
containertype bpchar 1 √ null
containerlinkurl varchar 60 √ null
relativeurl varchar 120 √ null
priority numeric 10 √ 0
isindexed bpchar 1 'Y'::bpchar
issecure bpchar 1 'Y'::bpchar
meta_robotstag varchar 2000 √ null
meta_author varchar 2000 √ null
meta_copyright varchar 2000 √ null
meta_content varchar 2000 √ null
meta_description varchar 2000 √ null
meta_keywords varchar 2000 √ null
meta_publisher varchar 2000 √ null
structurexml varchar 2000 √ null
containerxml varchar 2000 √ null
cm_containerlink_id numeric 10 √ null
cm_container.cm_container_id cmcontainer_cmcontainerlink N
issummary bpchar 1 'N'::bpchar
meta_language bpchar 2 √ null
isvalid bpchar 1 'Y'::bpchar
cm_container_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
cm_container_pkey Primary key Asc cm_container_id
cm_container_uu_idx Must be unique Asc cm_container_uu

Check Constraints

Constraint Name Constraint
cm_container_isindexed_check ((isindexed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cm_container_issecure_check ((issecure = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cm_container_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation