Table idempiere9.adempiere.test
Test ID

 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
test_id numeric 10 Test ID
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
t_integer numeric 10  √  null Integer
t_number numeric 0  √  0 Number
t_date timestamp 29,6  √  null Date
t_datetime timestamp 29,6  √  null DateTime
c_uom_id numeric 10  √  null Unit of Measure
t_qty numeric 0  √  0 Qty
c_currency_id numeric 10  √  null The Currency for this record
t_amount numeric 0  √  0 Amount
c_location_id numeric 10  √  null Location or Address
account_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_account_test R
Account_Acct
c_payment_id numeric 10  √  null Payment identifier
m_product_id numeric 10  √  null Product, Service, Item
c_bpartner_id numeric 10  √  null Identifies a Business Partner
m_locator_id numeric 10  √  null Warehouse Locator
processing bpchar 1  √  null Process Now
binarydata bytea 2147483647  √  null Binary Data
processed bpchar 1  √  'N'::bpchar The document has been processed
characterdata text 2147483647  √  null Long Character Field
test_uu varchar 36  √  NULL::character varying Test_UU
color varchar 7  √  NULL::character varying Color

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

Indexes:
Column(s) Type Sort Constraint Name
test_id Primary key Asc test_pkey
test_uu Must be unique Asc test_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.