cm_cstage

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cm_cstage_id numeric 10 null
cm_accessstage.cm_cstage_id cmcstage_cmaccessstage C
cm_cstage.cm_cstagelink_id cmcstage_cmcstagelink N
cm_cstage_element.cm_cstage_id cmcstage_cmcstageelement C
cm_cstage_trl.cm_cstage_id cmcstage_cmcstagetrl C
cm_cstagettable.cm_cstage_id cmstage_cmcstagettable 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_cmcstage C
cm_template_id numeric 10 √ null
cm_template.cm_template_id cmtemplate_cmcstage C
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_cstagelink_id numeric 10 √ null
cm_cstage.cm_cstage_id cmcstage_cmcstagelink N
ismodified bpchar 1 null
processing bpchar 1 √ null
issummary bpchar 1 'N'::bpchar
meta_language bpchar 2 √ null
isvalid bpchar 1 √ 'N'::bpchar
cm_cstage_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
cm_cstage_pkey Primary key Asc cm_cstage_id
cm_cstage_uu_idx Must be unique Asc cm_cstage_uu

Check Constraints

Constraint Name Constraint
cm_cstage_isindexed_check ((isindexed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cm_cstage_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cm_cstage_issecure_check ((issecure = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation