Table idempiere11.adempiere.cm_cstage
Container Stage contains the staging 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_cstage_id numeric 10
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
Web Container Stage contains the staging 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_cmcstage 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_cmcstage C
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_cstagelink_id numeric 10  √  null
cm_cstage.cm_cstage_id cmcstage_cmcstagelink N
Stage Link to another Container in the Web Project
ismodified bpchar 1 The record is modified
processing bpchar 1  √  null Process Now
issummary bpchar 1 'N'::bpchar This is a summary entity
meta_language bpchar 2  √  null Language HTML Meta Tag
isvalid bpchar 1  √  'N'::bpchar Element is valid
cm_cstage_uu varchar 36  √  NULL::character varying CM_CStage_UU

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

Indexes:
Column(s) Type Sort Constraint Name
cm_cstage_id Primary key Asc cm_cstage_pkey
cm_cstage_uu Must be unique Asc cm_cstage_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.