cm_webproject

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cm_webproject_id numeric 10 null
cm_ad_cat.cm_webproject_id cmwebproject_cmadcat C
cm_broadcastserver.cm_webproject_id cmwebproject_cmbroadcastserver N
cm_container.cm_webproject_id cmwebproject_cmcontainer C
cm_cstage.cm_webproject_id cmwebproject_cmcstage C
cm_media.cm_webproject_id cmwebproject_cmmedia R
cm_media_server.cm_webproject_id cmwebproject_cmmediaserver C
cm_newschannel.cm_webproject_id cmwebproject_cmnewschannel C
cm_template.cm_webproject_id cmwebproject_cmtemplate C
cm_webaccesslog.cm_webproject_id cmwebproject_cmwebaccesslog R
cm_webproject_domain.cm_webproject_id cmwebproject_cmwpdomain C
k_index.cm_webproject_id cmwebproject_kindex C
k_indexstop.cm_webproject_id cmwebproject_kindexstop 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 255 √ null
help varchar 2000 √ null
meta_copyright varchar 2000 null
meta_publisher varchar 2000 null
meta_robotstag varchar 2000 null
meta_author varchar 2000 null
meta_content varchar 2000 null
ad_treecmc_id numeric 10 null
ad_tree.ad_tree_id adtreecmc_cmwebproject R
ad_treecms_id numeric 10 null
ad_tree.ad_tree_id adtreecms_cmwebproject R
ad_treecmm_id numeric 10 null
ad_tree.ad_tree_id adtreecmm_cmwebproject R
ad_treecmt_id numeric 10 null
ad_tree.ad_tree_id adtreecmt_cmwebproject R
cm_webproject_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
cm_webproject_pkey Primary key Asc cm_webproject_id
cm_webproject_uu_idx Must be unique Asc cm_webproject_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation