SchemaSpy - Table idempiere9.adempiere.ad_attribute_value

AD_Attribute_Value

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

ad_attribute_id

numeric

10

ad_attribute.ad_attribute_id

adattribute_adattributevalue C

System Attribute

record_id

numeric

10

Direct internal record ID

v_number

numeric

0

√

null

Number

v_date

timestamp

29,6

√

null

Date

v_string

varchar

2000

√

null

String

ad_attribute_value_uu

varchar

36

√

NULL::character varying

AD_Attribute_Value_UU

Table contained 0 rows at 2021-12-25 14:45 +0100

Indexes:

Column(s)	Type	Sort	Constraint Name
ad_attribute_id + record_id	Primary key	Asc/Asc	ad_attribute_value_pkey
ad_attribute_value_uu	Must be unique	Asc	ad_attribute_value_uu_idx