ad_column

39404 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_column_id numeric 10 null
ad_accesslog.ad_column_id adcolumn_adaccesslog C
ad_changelog.ad_column_id adcolumn_adchangelog C
ad_column_access.ad_column_id adcolumn_adcolumnaccess R
ad_column_trl.ad_column_id adcolumn_adcolumntrl C
ad_field.ad_column_id ad_column_field R
ad_find.ad_column_id adcolumn_adfind R
ad_impformat_row.ad_column_id adcolumn_adimpformatrow R
ad_indexcolumn.ad_column_id adcolumn_adindexcolumn R
ad_package_imp_backup.ad_column_id adcolumn_adpackageimpbackup R
ad_printformatitem.ad_column_id adcolumn_adprintformatitem R
ad_printlabelline.ad_column_id adcolumn_adprintlabelline R
ad_ref_table.ad_display ad_column_reftable_display R
ad_ref_table.ad_key ad_column_reftable_id R
ad_reportview_col.ad_column_id adcolumn_adreportviewcol R
ad_reportview_column.ad_column_id adcolumn_adreportviewcolumn R
ad_searchdefinition.ad_column_id adcolumn_adsearchdefinition R
ad_tab.ad_column_id ad_column_ad_tab R
ad_tab.ad_columnsortorder_id adcolumn_adtabsortorder R
ad_tab.ad_columnsortyesno_id adcolumn_adtabsortyesno R
ad_tab.parent_column_id parentcolumn_adtab R
ad_tablepartition.ad_column_id adcolumn_adtablepartition R
ad_tree.parent_column_id parentcolumn_adtree R
ad_verifymigration.ad_column_id adcolumn_adverifymigration R
ad_wf_nextcondition.ad_column_id adcolumn_adwfnextcondition R
ad_wf_node.ad_column_id adcolumn_adwfnode R
ad_workbench.ad_column_id adcolumn_adworkbench R
c_acctschema_element.ad_column_id adcolumn_cacctschemaelement R
cof_c_acct_ignoreelement.ad_column_id adcolumn_cofcacctignoreelement R
cof_labelfield.cof_productbarcodecolumn_id cofproductbarcodecolumn_coflab R
exp_formatline.ad_column_id adcolumn_expformatline R
i_elementvalue.ad_column_id adcolumn_ielementvalue N
pp_order_node.ad_column_id adcolumn_ppordernode R
ws_webservicefieldinput.ad_column_id adcolumn_wswebservicefieldinpu R
ws_webservicefieldoutput.ad_column_id adcolumn_wswebservicefieldoutp R
ad_client_id numeric 10 null
ad_client.ad_client_id columnclient R
ad_org_id numeric 10 null
ad_org.ad_org_id columnorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
updated timestamp 29,6 now()
createdby numeric 10 null
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
version numeric 0 null
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adcolumn R
columnname varchar 63 null
ad_table_id numeric 10 null
ad_table.ad_table_id ad_table_column C
ad_reference_id numeric 10 null
ad_reference.ad_reference_id ad_reference_columndatatype R
ad_reference_value_id numeric 10 √ null
ad_reference.ad_reference_id ad_reference_columnvalue R
ad_val_rule_id numeric 10 √ null
ad_val_rule.ad_val_rule_id ad_valrule_column R
fieldlength numeric 10 √ null
defaultvalue varchar 2000 √ null
iskey bpchar 1 'N'::bpchar
isparent bpchar 1 'N'::bpchar
ismandatory bpchar 1 'N'::bpchar
isupdateable bpchar 1 'Y'::bpchar
readonlylogic varchar 2000 √ null
isidentifier bpchar 1 'N'::bpchar
seqno numeric 10 √ null
istranslated bpchar 1 'N'::bpchar
isencrypted bpchar 1 'N'::bpchar
callout varchar 255 √ null
vformat varchar 255 √ null
valuemin varchar 20 √ null
valuemax varchar 20 √ null
isselectioncolumn bpchar 1 'N'::bpchar
ad_element_id numeric 10 √ null
ad_element.ad_element_id ad_element_ad_column R
ad_process_id numeric 10 √ null
ad_process.ad_process_id adprocess_adcolumn N
issyncdatabase bpchar 1 √ 'N'::bpchar
isalwaysupdateable bpchar 1 'N'::bpchar
columnsql varchar 4000 √ null
mandatorylogic varchar 2000 √ null
infofactoryclass varchar 255 √ null
isautocomplete bpchar 1 'N'::bpchar
isallowlogging bpchar 1 √ 'Y'::bpchar
formatpattern varchar 22 √ null
ad_column_uu varchar 36 √ NULL::character varying
isallowcopy bpchar 1 'Y'::bpchar
seqnoselection numeric 10 √ NULL::numeric
istoolbarbutton bpchar 1 'Y'::bpchar
issecure bpchar 1 'N'::bpchar
ad_chart_id numeric 10 √ NULL::numeric
ad_chart.ad_chart_id adchart_adcolumn R
fkconstraintname varchar 63 √ null
fkconstrainttype bpchar 1 √ 'N'::bpchar
pa_dashboardcontent_id numeric 10 √ NULL::numeric
pa_dashboardcontent.pa_dashboardcontent_id padashboardcontent_adcolumn R
placeholder varchar 255 √ NULL::character varying
ishtml bpchar 1 √ 'N'::bpchar
ad_val_rule_lookup_id numeric 10 √ null
ad_val_rule.ad_val_rule_id advalrulelookup_adcolumn R
ad_infowindow_id numeric 10 √ null
ad_infowindow.ad_infowindow_id adinfowindow_adcolumn N
alwaysupdatablelogic varchar 2000 √ NULL::character varying
fkconstraintmsg_id numeric 10 √ NULL::numeric
ad_message.ad_message_id fkconstraintmsg_adcolumn R
partitioningmethod varchar 2 √ NULL::character varying
ispartitionkey bpchar 1 'N'::bpchar
seqnopartition numeric 10 √ NULL::numeric
rangepartitioninterval varchar 30 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_column_pkey Primary key Asc ad_column_id
ad_column_fkconstraintname Must be unique
ad_column_name Must be unique Asc ad_table_id
ad_column_process Performance Asc ad_process_id
ad_column_uu_idx Must be unique Asc ad_column_uu

Check Constraints

Constraint Name Constraint
ad_column_isupdateable_check ((isupdateable = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_ishtml_check ((ishtml = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_isidentifier_check ((isidentifier = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_ismandatory_check ((ismandatory = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_istranslated_check ((istranslated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_issyncdatabase_check ((issyncdatabase = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_iskey_check ((iskey = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_isparent_check ((isparent = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_isselectioncolumn_check ((isselectioncolumn = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_ispartitionkey_check ((ispartitionkey = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_isallowlogging_check ((isallowlogging = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_isencrypted_check ((isencrypted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_isautocomplete_check ((isautocomplete = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_issecure_check ((issecure = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_column_isallowcopy_check ((isallowcopy = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation