Table idempiere11.adempiere.cm_container
Web Container contains content like images, text 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_container_id numeric 10
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
Web Container contains content like images, text etc.
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
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 2000  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
cm_webproject_id numeric 10
cm_webproject.cm_webproject_id cmwebproject_cmcontainer C
A web project is the main data container for Containers, URLs, Ads, Media etc.
cm_template_id numeric 10  √  null
cm_template.cm_template_id cmtemplate_cmcontainer R
Template defines how content is displayed
title varchar 60  √  null Name this entity is referred to as
notice varchar 2000  √  null Contains last write notice
containertype bpchar 1  √  null Web Container Type
containerlinkurl varchar 60  √  null External Link (URL) for the Container
relativeurl varchar 120  √  null Contains the relative URL for the container
priority numeric 10  √  0 Indicates if this request is of a high, medium or low priority.
isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
issecure bpchar 1 'Y'::bpchar Defines whether content must be treated as secure
meta_robotstag varchar 2000  √  null RobotsTag defines how search robots should handle this content
meta_author varchar 2000  √  null Author of the content
meta_copyright varchar 2000  √  null Contains Copyright information for the content
meta_content varchar 2000  √  null Defines the type of content i.e. "text/html; charset=UTF-8"
meta_description varchar 2000  √  null Meta info describing the contents of the page
meta_keywords varchar 2000  √  null Contains the keywords for the content
meta_publisher varchar 2000  √  null Meta Publisher defines the publisher of the content
structurexml varchar 2000  √  null Autogenerated Container definition as XML Code
containerxml varchar 2000  √  null Autogenerated Container definition as XML Code
cm_containerlink_id numeric 10  √  null
cm_container.cm_container_id cmcontainer_cmcontainerlink N
Link to another Container in the Web Project
issummary bpchar 1 'N'::bpchar This is a summary entity
meta_language bpchar 2  √  null Language HTML Meta Tag
isvalid bpchar 1 'Y'::bpchar Element is valid
cm_container_uu varchar 36  √  NULL::character varying CM_Container_UU

Table contained 5 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort Constraint Name
cm_container_id Primary key Asc cm_container_pkey
cm_container_uu Must be unique Asc cm_container_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.