SchemaSpy Analysis of idempiere11.adempiere - ColumnsCollaboration Management Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:47 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 264 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_table accesslevel bpchar 1 Access Level required
cm_chatentry chatentrytype bpchar 1 Type of Chat/Forum Entry
cm_chat confidentialtype bpchar 1 Type of Confidentiality
cm_chatentry confidentialtype bpchar 1 Type of Confidentiality
ad_user connectionprofile bpchar 1  √  null How a Java Tenant connects to the server(s)
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar Copy Components From View
ad_table createpartition bpchar 1  √  NULL::bpchar Process which create or update table partitions based on the table and column records
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
ad_table importtable bpchar 1  √  null Import Table Columns from Database
ad_label isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_label_trl isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_labelassignment isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_labelcategory isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_labelcategory_trl isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_labelcategorytable isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_postit isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_table isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isactive bpchar 1 'Y'::bpchar The record is active in the system
cm_chat isactive bpchar 1 'Y'::bpchar The record is active in the system
cm_chatentry isactive bpchar 1 'Y'::bpchar The record is active in the system
cm_chattype isactive bpchar 1 'Y'::bpchar The record is active in the system
cm_chattypeupdate isactive bpchar 1 'Y'::bpchar The record is active in the system
cm_chatupdate isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar The selected mail template will be automatically inserted when creating an email
ad_user isbillto bpchar 1 'N'::bpchar Business Partner Invoice/Bill Address
ad_labelcategory iscanbeusedinalltables bpchar 1  √  'Y'::bpchar Can Be Used in All Tables
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_table ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
ad_user isexpired bpchar 1 'N'::bpchar Expired
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
ad_table ishighvolume bpchar 1 'N'::bpchar Use Search instead of Pick list
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
ad_user islocked bpchar 1 'N'::bpchar Locked
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
ad_user isnoexpire bpchar 1 'N'::bpchar No Expire
ad_user isnopasswordreset bpchar 1 'N'::bpchar No Password Reset
ad_table ispartition bpchar 1 'N'::bpchar This is a partitioned table
ad_user issaleslead bpchar 1 'N'::bpchar This contact is a sales lead
ad_table issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
cm_chattypeupdate isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
cm_chatupdate isselfservice bpchar 1 'N'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
ad_table isshowindrilloptions bpchar 1  √  'Y'::bpchar This parameter enables the table to be displayed in Drill Assistant - Table tab
ad_user issupportuser bpchar 1 'N'::bpchar Support User
ad_label_trl istranslated bpchar 1 'N'::bpchar This column is translated
ad_labelcategory_trl istranslated bpchar 1 'N'::bpchar This column is translated
ad_user isvendorlead bpchar 1 'N'::bpchar This contact is a vendor lead
ad_table isview bpchar 1 'N'::bpchar This is a view
cm_chat moderationtype bpchar 1  √  null Type of moderation
cm_chattype moderationtype bpchar 1  √  null Type of moderation
cm_chatentry moderatorstatus bpchar 1  √  null Status of Moderation
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
ad_table processing bpchar 1  √  NULL::bpchar Process Now
ad_user processing bpchar 1  √  null Process Now
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
ad_label ad_client_id numeric 10  √  NULL::numeric Tenant for this installation.
ad_label_trl ad_client_id numeric 10 Tenant for this installation.
ad_labelassignment ad_client_id numeric 10  √  NULL::numeric Tenant for this installation.
ad_labelcategory ad_client_id numeric 10  √  NULL::numeric Tenant for this installation.
ad_labelcategory_trl ad_client_id numeric 10 Tenant for this installation.
ad_labelcategorytable ad_client_id numeric 10  √  NULL::numeric Tenant for this installation.
ad_postit ad_client_id numeric 10 Tenant for this installation.
ad_table ad_client_id numeric 10 Tenant for this installation.
ad_user ad_client_id numeric 10 Tenant for this installation.
cm_chat ad_client_id numeric 10 Tenant for this installation.
cm_chatentry ad_client_id numeric 10 Tenant for this installation.
cm_chattype ad_client_id numeric 10 Tenant for this installation.
cm_chattypeupdate ad_client_id numeric 10 Tenant for this installation.
cm_chatupdate ad_client_id numeric 10 Tenant for this installation.
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
ad_label ad_label_id numeric 10 NULL::numeric Record Label
ad_label_trl ad_label_id numeric 10 Record Label
ad_labelassignment ad_label_id numeric 10 Record Label
ad_labelassignment ad_labelassignment_id numeric 10 NULL::numeric Label Assignment
ad_label ad_labelcategory_id numeric 10  √  NULL::numeric Category of a Label
ad_labelcategory ad_labelcategory_id numeric 10 NULL::numeric Category of a Label
ad_labelcategory_trl ad_labelcategory_id numeric 10 Category of a Label
ad_labelcategorytable ad_labelcategory_id numeric 10 Category of a Label
ad_labelcategorytable ad_labelcategorytable_id numeric 10 NULL::numeric Label Category Table Access
ad_label ad_labelstyle_id numeric 10  √  NULL::numeric Label CSS Style
ad_labelcategory ad_labelstyle_id numeric 10  √  NULL::numeric Label CSS Style
ad_label ad_org_id numeric 10  √  NULL::numeric Organizational entity within tenant
ad_label_trl ad_org_id numeric 10 Organizational entity within tenant
ad_labelassignment ad_org_id numeric 10  √  NULL::numeric Organizational entity within tenant
ad_labelcategory ad_org_id numeric 10  √  NULL::numeric Organizational entity within tenant
ad_labelcategory_trl ad_org_id numeric 10 Organizational entity within tenant
ad_labelcategorytable ad_org_id numeric 10  √  NULL::numeric Organizational entity within tenant
ad_postit ad_org_id numeric 10 Organizational entity within tenant
ad_table ad_org_id numeric 10 Organizational entity within tenant
ad_user ad_org_id numeric 10 Organizational entity within tenant
cm_chat ad_org_id numeric 10 Organizational entity within tenant
cm_chatentry ad_org_id numeric 10 Organizational entity within tenant
cm_chattype ad_org_id numeric 10 Organizational entity within tenant
cm_chattypeupdate ad_org_id numeric 10 Organizational entity within tenant
cm_chatupdate ad_org_id numeric 10 Organizational entity within tenant
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
ad_postit ad_postit_id numeric 10 Post-it
ad_labelassignment ad_table_id numeric 10 Database Table information
ad_labelcategorytable ad_table_id numeric 10 Database Table information
ad_postit ad_table_id numeric 10  √  NULL::numeric Database Table information
ad_table ad_table_id numeric 10 Database Table information
cm_chat ad_table_id numeric 10 Database Table information
cm_chattype ad_table_id numeric 10 Database Table information
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
cm_chatentry ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
cm_chattypeupdate ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
cm_chatupdate ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_table ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_table ad_window_id numeric 10  √  null Data entry or display window
ad_user bp_location_id numeric 10  √  NULL::numeric Address of the Business Partner
ad_user c_bpartner_id numeric 10  √  null Identifies a Business Partner
ad_user c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
ad_user c_greeting_id numeric 10  √  null Greeting to print on correspondence
ad_user c_job_id numeric 10  √  null Job Position
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
cm_chat cm_chat_id numeric 10 Chat or discussion thread
cm_chatentry cm_chat_id numeric 10 Chat or discussion thread
cm_chatupdate cm_chat_id numeric 10 Chat or discussion thread
cm_chatentry cm_chatentry_id numeric 10 Individual Chat / Discussion Entry
cm_chatentry cm_chatentrygrandparent_id numeric 10  √  null Link to Grand Parent (root level)
cm_chatentry cm_chatentryparent_id numeric 10  √  null Link to direct Parent
cm_chat cm_chattype_id numeric 10  √  null Type of discussion / chat
cm_chattype cm_chattype_id numeric 10 Type of discussion / chat
cm_chattypeupdate cm_chattype_id numeric 10 Type of discussion / chat
ad_label createdby numeric 10  √  NULL::numeric User who created this records
ad_label_trl createdby numeric 10 User who created this records
ad_labelassignment createdby numeric 10  √  NULL::numeric User who created this records
ad_labelcategory createdby numeric 10  √  NULL::numeric User who created this records
ad_labelcategory_trl createdby numeric 10 User who created this records
ad_labelcategorytable createdby numeric 10  √  NULL::numeric User who created this records
ad_postit createdby numeric 10 User who created this records
ad_table createdby numeric 10 User who created this records
ad_user createdby numeric 10 User who created this records
cm_chat createdby numeric 10 User who created this records
cm_chatentry createdby numeric 10 User who created this records
cm_chattype createdby numeric 10 User who created this records
cm_chattypeupdate createdby numeric 10 User who created this records
cm_chatupdate createdby numeric 10 User who created this records
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
ad_table loadseq numeric 10  √  null Sequence
ad_table po_window_id numeric 10  √  null Purchase Order Window
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
ad_labelassignment record_id numeric 10  √  null Direct internal record ID
ad_postit record_id numeric 10  √  NULL::numeric Direct internal record ID
cm_chat record_id numeric 10  √  null Direct internal record ID
ad_user salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_label updatedby numeric 10  √  NULL::numeric User who updated this records
ad_label_trl updatedby numeric 10 User who updated this records
ad_labelassignment updatedby numeric 10  √  NULL::numeric User who updated this records
ad_labelcategory updatedby numeric 10  √  NULL::numeric User who updated this records
ad_labelcategory_trl updatedby numeric 10 User who updated this records
ad_labelcategorytable updatedby numeric 10  √  NULL::numeric User who updated this records
ad_postit updatedby numeric 10 User who updated this records
ad_table updatedby numeric 10 User who updated this records
ad_user updatedby numeric 10 User who updated this records
cm_chat updatedby numeric 10 User who updated this records
cm_chatentry updatedby numeric 10 User who updated this records
cm_chattype updatedby numeric 10 User who updated this records
cm_chattypeupdate updatedby numeric 10 User who updated this records
cm_chatupdate updatedby numeric 10 User who updated this records
cm_chatentry characterdata text 2147483647  √  null Long Character Field
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_label created timestamp 29,6  √  statement_timestamp() Date this record was created
ad_label_trl created timestamp 29,6 Date this record was created
ad_labelassignment created timestamp 29,6  √  statement_timestamp() Date this record was created
ad_labelcategory created timestamp 29,6  √  statement_timestamp() Date this record was created
ad_labelcategory_trl created timestamp 29,6 Date this record was created
ad_labelcategorytable created timestamp 29,6  √  statement_timestamp() Date this record was created
ad_postit created timestamp 29,6 Date this record was created
ad_table created timestamp 29,6 now() Date this record was created
ad_user created timestamp 29,6 now() Date this record was created
cm_chat created timestamp 29,6 now() Date this record was created
cm_chatentry created timestamp 29,6 now() Date this record was created
cm_chattype created timestamp 29,6 now() Date this record was created
cm_chattypeupdate created timestamp 29,6 now() Date this record was created
cm_chatupdate created timestamp 29,6 now() Date this record was created
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
ad_label updated timestamp 29,6  √  statement_timestamp() Date this record was updated
ad_label_trl updated timestamp 29,6 Date this record was updated
ad_labelassignment updated timestamp 29,6  √  statement_timestamp() Date this record was updated
ad_labelcategory updated timestamp 29,6  √  statement_timestamp() Date this record was updated
ad_labelcategory_trl updated timestamp 29,6 Date this record was updated
ad_labelcategorytable updated timestamp 29,6  √  statement_timestamp() Date this record was updated
ad_postit updated timestamp 29,6 Date this record was updated
ad_table updated timestamp 29,6 now() Date this record was updated
ad_user updated timestamp 29,6 now() Date this record was updated
cm_chat updated timestamp 29,6 now() Date this record was updated
cm_chatentry updated timestamp 29,6 now() Date this record was updated
cm_chattype updated timestamp 29,6 now() Date this record was updated
cm_chattypeupdate updated timestamp 29,6 now() Date this record was updated
cm_chatupdate updated timestamp 29,6 now() Date this record was updated
ad_table copycolumnsfromtable varchar 1  √  null Copy Columns From Table
ad_label_trl ad_language varchar 6 Language for this entity
ad_labelcategory_trl ad_language varchar 6 Language for this entity
ad_user authenticationtype varchar 10  √  NULL::character varying Authentication Type
ad_user leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
ad_user leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
ad_user userpin varchar 20  √  null User PIN
ad_label_trl ad_label_trl_uu varchar 36  √  NULL::character varying AD_Label_Trl_UU
ad_label ad_label_uu varchar 36  √  NULL::character varying Record Label
ad_labelassignment ad_labelassignment_uu varchar 36  √  NULL::character varying Label Assignment
ad_labelcategory_trl ad_labelcategory_trl_uu varchar 36  √  NULL::character varying AD_LabelCategory_Trl_UU
ad_labelcategory ad_labelcategory_uu varchar 36  √  NULL::character varying Category of a Label
ad_labelcategorytable ad_labelcategorytable_uu varchar 36  √  NULL::character varying Label Category Table Access
ad_postit ad_postit_uu varchar 36  √  NULL::character varying AD_PostIt_UU
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
cm_chat cm_chat_uu varchar 36  √  NULL::character varying CM_Chat_UU
cm_chatentry cm_chatentry_uu varchar 36  √  NULL::character varying CM_ChatEntry_UU
cm_chattype cm_chattype_uu varchar 36  √  NULL::character varying CM_ChatType_UU
cm_chattypeupdate cm_chattypeupdate_uu varchar 36  √  NULL::character varying CM_ChatTypeUpdate_UU
cm_chatupdate cm_chatupdate_uu varchar 36  √  NULL::character varying CM_ChatUpdate_UU
ad_labelassignment record_uu varchar 36  √  NULL::character varying Record UUID
ad_postit record_uu varchar 36  √  NULL::character varying Record UUID
cm_chat record_uu varchar 36  √  NULL::character varying Record UUID
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_user fax varchar 40  √  null Facsimile number
ad_user phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
ad_table tablename varchar 40 Name of the table in the database
ad_user title varchar 40  √  null Name this entity is referred to as
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique
ad_user bpname varchar 60  √  NULL::character varying BP Name
ad_user email varchar 60  √  null Electronic Mail Address
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
ad_label name varchar 60 Alphanumeric identifier of the entity
ad_label_trl name varchar 60 Alphanumeric identifier of the entity
ad_labelcategory name varchar 60 Alphanumeric identifier of the entity
ad_labelcategory_trl name varchar 60 Alphanumeric identifier of the entity
ad_table name varchar 60 Alphanumeric identifier of the entity
ad_user name varchar 60 Alphanumeric identifier of the entity
cm_chattype name varchar 60 Alphanumeric identifier of the entity
ad_label description varchar 255  √  NULL::character varying Optional short description of the record
ad_label_trl description varchar 255  √  NULL::character varying Optional short description of the record
ad_labelassignment description varchar 255  √  NULL::character varying Optional short description of the record
ad_labelcategory description varchar 255  √  NULL::character varying Optional short description of the record
ad_labelcategory_trl description varchar 255  √  NULL::character varying Optional short description of the record
ad_labelcategorytable description varchar 255  √  NULL::character varying Optional short description of the record
ad_table description varchar 255  √  null Optional short description of the record
ad_user description varchar 255  √  null Optional short description of the record
cm_chat description varchar 255 Optional short description of the record
cm_chattype description varchar 255  √  null Optional short description of the record
ad_user emailuserpw varchar 255  √  null Password of your email user id
ad_user lastresult varchar 255  √  null Result of last contact
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
cm_chatentry subject varchar 255  √  null Email Message Subject
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_user password varchar 1024  √  null Password of any length (case sensitive)
ad_user securityquestion varchar 1024  √  null Security Question
ad_user comments varchar 2000  √  null Comments or additional information
ad_table help varchar 2000  √  null Comment or Hint
ad_postit text varchar 2000  √  NULL::character varying Description