Table idempiere9.adempiere.cm_webproject
A web project is the main data container for Containers, URLs, Ads, Media etc.

 Generated by
Quality Systems & Solutions
Legend:
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
cm_webproject_id numeric 10
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
A web project is the main data container for Containers, URLs, Ads, Media etc.
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
meta_copyright varchar 2000 Contains Copyright information for the content
meta_publisher varchar 2000 Meta Publisher defines the publisher of the content
meta_robotstag varchar 2000 RobotsTag defines how search robots should handle this content
meta_author varchar 2000 Author of the content
meta_content varchar 2000 Defines the type of content i.e. "text/html; charset=UTF-8"
ad_treecmc_id numeric 10
ad_tree.ad_tree_id adtreecmc_cmwebproject R
Container Tree
ad_treecms_id numeric 10
ad_tree.ad_tree_id adtreecms_cmwebproject R
Stage Tree
ad_treecmm_id numeric 10
ad_tree.ad_tree_id adtreecmm_cmwebproject R
Media Tree
ad_treecmt_id numeric 10
ad_tree.ad_tree_id adtreecmt_cmwebproject R
Template Tree
cm_webproject_uu varchar 36  √  NULL::character varying CM_WebProject_UU

Table contained 1 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.