Table idempiere9.adempiere.m_attribute
Product Attribute

 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
m_attribute_id numeric 10
m_attributeinstance.m_attribute_id mattribute_mattributeinst R
m_attributeuse.m_attribute_id mattribute_mattributeuse R
m_attributevalue.m_attribute_id mattribute_mattributevalue C
qm_specificationline.m_attribute_id mattribute_qmspecificationline R
Product Attribute
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
ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
isinstanceattribute bpchar 1 'N'::bpchar The product attribute is specific to the instance (like Serial No, Lot or Guarantee Date)
m_attributesearch_id numeric 10  √  null
m_attributesearch.m_attributesearch_id mattributesearch_mattribute R
Common Search Attribute
attributevaluetype bpchar 1 'S'::bpchar Type of Attribute Value
m_attribute_uu varchar 36  √  NULL::character varying M_Attribute_UU
dateformat varchar 20  √  NULL::character varying Date format used in the input format
ad_reference_id numeric 10  √  NULL::numeric
ad_reference.ad_reference_id adreference_mattribute R
System Reference and Validation
ad_reference_value_id numeric 10  √  NULL::numeric
ad_reference.ad_reference_id adreferencevalue_mattribute R
Required to specify, if data type is Table or List
ad_val_rule_id numeric 10  √  NULL::numeric
ad_val_rule.ad_val_rule_id advalrule_mattribute R
Dynamic Validation Rule

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

Indexes:
Column(s) Type Sort Constraint Name
m_attribute_id Primary key Asc m_attribute_pkey
m_attribute_uu Must be unique Asc m_attribute_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.