ad_table

1363 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_table_id numeric 10 null
ad_accesslog.ad_table_id adtable_adacceslog R
ad_alertrule.ad_table_id adtable_adaltertrule R
ad_archive.ad_table_id adtable_adarchive R
ad_attachment.ad_table_id adtable_adattachment R
ad_attribute.ad_table_id adtable_adattribute C
ad_changelog.ad_table_id adtable_adchangelog C
ad_chartdatasource.ad_table_id adtable_adchartdatasource R
ad_clientshare.ad_table_id adtable_adclientshare R
ad_column.ad_table_id ad_table_column C
ad_column_access.ad_table_id adtable_adcolumnaccess R
ad_ctxhelp.ad_table_id Implied Constraint R
ad_field_v.ad_table_id Implied Constraint R
ad_field_vt.ad_table_id Implied Constraint R
ad_housekeeping.ad_table_id adtable_adhousekeeping R
ad_impformat.ad_table_id adtable_adimpformat R
ad_infowindow.ad_table_id adtable_adinfowindow R
ad_labelassignment.ad_table_id adtable_adlabelassignment R
ad_labelcategorytable.ad_table_id adtable_adlabelcategorytable R
ad_note.ad_table_id adtable_adnote R
ad_package_exp_common.ad_table_id adtable_adpackageexpcommon R
ad_package_exp_detail.ad_table_id adtable_adpackageexpdetail R
ad_package_imp_backup.ad_table_id Implied Constraint R
ad_package_imp_detail.ad_table_id adtable_adpackageimpdetail R
ad_package_uuid_map.ad_table_id adtable_adpackageuuidmap R
ad_pinstance_log.ad_table_id adtable_adpinstancelog R
ad_postit.ad_table_id adtable_adpostit R
ad_printformat.ad_table_id adtable_adprintformat R
ad_printlabel.ad_table_id adtable_adprintlabel R
ad_private_access.ad_table_id adtable_adprivateaccess R
ad_process_drillrule.ad_table_id adtable_addrillrule R
ad_recentitem.ad_table_id adtable_adrecentitem C
ad_record_access.ad_table_id adtable_adrecordaccess R
ad_ref_table.ad_table_id add_table_reftable R
ad_replicationdocument.ad_table_id adtable_adreplicationdocument R
ad_replicationtable.ad_table_id adtable_adreplicationtable C
ad_reportview.ad_table_id adtable_adreportview C
ad_scheduler.ad_table_id adtable_adscheduler R
ad_searchdefinition.ad_table_id adtable_adsearchdefinition R
ad_sequence_audit.ad_table_id adtable_adsequenceaudit C
ad_statuslineusedin.ad_table_id adtable_adstatuslineusedin R
ad_tab.ad_table_id ad_table_tab R
ad_tab_v.ad_table_id Implied Constraint R
ad_tab_vt.ad_table_id Implied Constraint R
ad_table_access.ad_table_id adtable_adtableaccess C
ad_table_scriptvalidator.ad_table_id adtable_adtablescriptvalidator R
ad_table_trl.ad_table_id adtable_adtabletrl C
ad_tableindex.ad_table_id adtable_adtableindex R
ad_tree.ad_table_id adtable_adtree R
ad_userquery.ad_table_id adtable_aduserquery C
ad_verifymigration.ad_table_id adtable_adverifymigration R
ad_viewcomponent.ad_table_id adtable_adviewcomponent R
ad_viewcomponent.referenced_table_id referencedtable_adviewcomponen R
ad_wf_activity.ad_table_id adtable_adwfactivity R
ad_wf_eventaudit.ad_table_id adtable_adwfeventaudit R
ad_wf_process.ad_table_id adtable_adwfprocess R
ad_workflow.ad_table_id adtable_adworkflow R
ad_zoomcondition.ad_table_id adtable_adzoomcondition R
c_acctprocessor.ad_table_id adtable_cacctprocessor R
c_onlinetrxhistory.ad_table_id adtable_conlinetrxhistory R
cm_chat.ad_table_id adtable_cmchat C
cm_chattype.ad_table_id adtable_cmchattype C
cm_templatetable.ad_table_id adtable_cmtemplatetable R
cm_wikitoken.ad_table_id adtable_cmwikitoken R
cof_chamadapbx.ad_table_id adtable_cofchamadapbx R
cof_labelentry.ad_table_id adtable_coflabelentry R
cof_labelwindow.ad_table_id adtable_coflabelwindow R
cof_pesagem.ad_table_id adtable_cofpesagem R
cof_r_survey.ad_table_id Implied Constraint R
cof_r_survey_answer.ad_table_id adtable_cofrsurveyanswer R
cof_rv_entrieslabel.ad_table_id Implied Constraint R
cof_rv_requestpartner.ad_table_id Implied Constraint R
exp_format.ad_table_id adtable_expformat R
fact_acct.ad_table_id adtable_factacct R
k_index.ad_table_id adtable_kindex C
lbr_tax.ad_table_id adtable_lbrtax R
m_attributesetexclude.ad_table_id adtable_mattributesetexclude R
m_lotctlexclude.ad_table_id adtable_mlotctlexclude R
m_sernoctlexclude.ad_table_id adtable_msernoctlexclude R
m_storagereservationlog.ad_table_id adtable_mstoragereservationlog R
pa_documentstatus.ad_table_id adtable_padocumentstatus R
pa_measurecalc.ad_table_id adtable_pameasurecalc R
pa_sla_measure.ad_table_id adtable_paslameasure R
pp_order_workflow.ad_table_id adtable_pporderworkflow R
r_request.ad_table_id adtable_rrequest R
r_request_v.ad_table_id Implied Constraint R
rv_fact_acct.ad_table_id Implied Constraint R
rv_printformatdetail.ad_table_id Implied Constraint R
t_invoicegl_v.fact_acct_ad_table_id Implied Constraint R
t_rv_reconciliation.ad_table_id Implied Constraint R
t_trialbalance.ad_table_id Implied Constraint R
test.ad_table_id adtable_test R
ws_webservicetype.ad_table_id adtable_wswebservicetype R
ad_client_id numeric 10 null
ad_client.ad_client_id tableclient R
ad_org_id numeric 10 null
ad_org.ad_org_id tableorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
tablename varchar 40 null
isview bpchar 1 'N'::bpchar
accesslevel bpchar 1 null
entitytype varchar 40 'D'::character varying
ad_entitytype.entitytype entityt_adtable R
ad_window_id numeric 10 √ null
ad_window.ad_window_id ad_window_table N
ad_val_rule_id numeric 10 √ null
ad_val_rule.ad_val_rule_id ad_valrule_table R
loadseq numeric 10 √ null
issecurityenabled bpchar 1 'N'::bpchar
isdeleteable bpchar 1 'Y'::bpchar
ishighvolume bpchar 1 'N'::bpchar
importtable bpchar 1 √ null
ischangelog bpchar 1 'N'::bpchar
replicationtype bpchar 1 'L'::bpchar
po_window_id numeric 10 √ null
ad_window.ad_window_id adwindowpo_adtable R
copycolumnsfromtable varchar 1 √ null
iscentrallymaintained bpchar 1 √ 'Y'::bpchar
ad_table_uu varchar 36 √ NULL::character varying
processing bpchar 1 √ NULL::bpchar
databaseviewdrop bpchar 1 √ NULL::bpchar
ispersonallock bpchar 1 √ null
cof_processing bpchar 1 √ NULL::bpchar
copycomponentsfromview bpchar 1 √ NULL::bpchar
createwindowfromtable bpchar 1 √ NULL::bpchar
isshowindrilloptions bpchar 1 √ 'Y'::bpchar

Indexes

Constraint Name Type Sort Column(s)
ad_table_pkey Primary key Asc ad_table_id
ad_table_name Must be unique
ad_table_uu_idx Must be unique Asc ad_table_uu

Check Constraints

Constraint Name Constraint
ad_table_ishighvolume_check ((ishighvolume = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_issecurityenabled_check ((issecurityenabled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_iscentrallymaintained_check ((iscentrallymaintained = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_isdeleteable_check ((isdeleteable = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_isview_check ((isview = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_isshowindrilloptions_check ((isshowindrilloptions = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation