Table idempiere9.adempiere.ad_system
System Definition

 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_system_id numeric 10
ad_registration.ad_system_id adsystem_adregistration R
System Definition
ad_client_id numeric 10
ad_registration.ad_client_id adsystem_adregistration R
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
username varchar 60 User Name
info varchar 255  √  null Information
version varchar 20  √  null Version of the table definition
releaseno varchar 10  √  null Internal Release Number
supportunits numeric 10  √  null Number of Internal Users for iDempiere Support
password varchar 20  √  null Password of any length (case sensitive)
replicationtype bpchar 1 'L'::bpchar Type of Data Replication
idrangestart numeric 0  √  null Start of the ID Range used
idrangeend numeric 0  √  null End if the ID Range used
ldaphost varchar 60  √  null Connection String to LDAP server starting with ldap://
customprefix varchar 60  √  null Prefix for Custom entities
isjustmigrated bpchar 1  √  'N'::bpchar Value set by Migration for post-Migration tasks.
dbinstance varchar 60  √  null Database Name
dbaddress varchar 255  √  null JDBC URL of the database server
noprocessors numeric 10  √  null Number of Database Processors
summary varchar 255  √  null Textual summary of this request
encryptionkey varchar 255  √  null Encryption Class used for securing data content
ldapdomain varchar 255  √  null Directory service domain name - e.g. idempiere.org
isautoerrorreport bpchar 1 'Y'::bpchar Automatically report Errors
record_id numeric 10  √  null Direct internal record ID
supportexpdate timestamp 29,6  √  null Date when the iDempiere support expires
processing bpchar 1  √  null Process Now
supportemail varchar 60  √  null EMail address to send support information and updates to
isallowstatistics bpchar 1 'Y'::bpchar Maintain general statistics
statisticsinfo varchar 60  √  null Information to help profiling the system for solving support issues
profileinfo varchar 255  √  null Information to help profiling the system for solving support issues
oldname varchar 60  √  null Old Name
description varchar 255  √  null Optional short description of the record
systemstatus bpchar 1 'E'::bpchar Status of the system - Support priority depends on system status
isfailonmissingmodelvalidator bpchar 1 'Y'::bpchar Fail on Missing Model Validator
lastbuildinfo varchar 255  √  null Last Build Info
isfailonbuilddiffer bpchar 1 'N'::bpchar Fail if Build Differ
ad_system_uu varchar 36  √  NULL::character varying AD_System_UU
lastmigrationscriptapplied varchar 255  √  NULL::character varying Register of the filename for the last migration script applied on this database

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

Indexes:
Column(s) Type Sort Constraint Name
ad_system_id + ad_client_id Primary key Asc/Asc ad_system_pkey
ad_system_uu Must be unique Asc ad_system_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.