ad_table

1443 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_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_detail.ad_table_id adtable_adpackageimpdetail R
ad_package_uuid_map.ad_table_id adtable_adpackageuuidmap R
ad_pinstance.ad_table_id adtable_adpinstance 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_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_tablepartition.ad_table_id adtable_adtablepartition R
ad_tablevalrule.ad_table_id adtable_adtablevalrule 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_cobranca_pix.ad_table_id adtable_cofcobrancapix R
cof_historicoconsultas.ad_table_id adtable_cofhistoricoconsultas R
cof_label.ad_table_id adtable_coflabel 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_answer.ad_table_id adtable_cofrsurveyanswer R
cof_testequalidade.ad_table_id adtable_coftestequalidade 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
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 60 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
ispartition bpchar 1 'N'::bpchar
createpartition bpchar 1 √ NULL::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_isview_check ((isview = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_isdeleteable_check ((isdeleteable = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_ishighvolume_check ((ishighvolume = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_isshowindrilloptions_check ((isshowindrilloptions = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_iscentrallymaintained_check ((iscentrallymaintained = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_ispartition_check ((ispartition = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_issecurityenabled_check ((issecurityenabled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_table_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation