Table alter.public.acs_objects
The root table for the acs object heirarchy. It all starts here folks.

 Generated by
SchemaSpy
Implied relationships Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
object_id int4 10
acs_objects.context_id acs_objects_context_id_fk
apm_packages.package_id apm_packages_package_id_fk
auth_authorities.auth_impl_id auth_authority_auth_impl_fk
auth_authorities.authority_id auth_authorities_aid_fk
auth_authorities.get_doc_impl_id auth_authority_getdoc_impl_fk
auth_authorities.process_doc_impl_id auth_authority_procdoc_impl_fk
auth_authorities.pwd_impl_id auth_authority_pwd_impl_fk
auth_authorities.register_impl_id auth_authority_reg_impl_fk
auth_authorities.user_info_impl_id auth_authority_userinf_impl_fk
categories.category_id cat_category_id_fk
category_trees.tree_id cat_trees_tree_id_fk
mis_accounts.account_id mis_accounts_account_id_fkey
mis_accounts_view.object_id Implied Constraint
mis_acct_mov.document_id mis_acct_mov_document_id_fkey
mis_active_products.object_id Implied Constraint
mis_all_orders.object_id Implied Constraint
mis_bid_lines.line_id mis_bid_lines_line_id_fkey
mis_bids.bid_id mis_bids_bid_id_fkey
mis_centers_view.object_id Implied Constraint
mis_contract_lines.object_id Implied Constraint
mis_customers.object_id Implied Constraint
mis_delivery_note_lines.delivery_line_id mis_delivery_note_lines_delivery_line_id_fkey
mis_delivery_note_lines.reference_id mis_delivery_note_lines_reference_id_fkey
mis_delivery_notes.delivery_id mis_delivery_notes_delivery_id_fkey
mis_fast_bid_lines.object_id Implied Constraint
mis_fast_bids.object_id Implied Constraint
mis_fast_customers.object_id Implied Constraint
mis_fast_delivery_note_lines.object_id Implied Constraint
mis_fast_delivery_notes.object_id Implied Constraint
mis_fast_mr_lines.object_id Implied Constraint
mis_fast_mrs.object_id Implied Constraint
mis_fast_order_lines.object_id Implied Constraint
mis_fast_orders.object_id Implied Constraint
mis_fast_parties.object_id Implied Constraint
mis_fast_po_lines.object_id Implied Constraint
mis_fast_pos.object_id Implied Constraint
mis_fast_products.object_id Implied Constraint
mis_fast_purc_invoice_lines.object_id Implied Constraint
mis_fast_purc_invoices.object_id Implied Constraint
mis_fast_rec_note_lines.object_id Implied Constraint
mis_fast_rec_notes.object_id Implied Constraint
mis_fast_sale_invoice_lines.object_id Implied Constraint
mis_fast_sale_invoices.object_id Implied Constraint
mis_fast_vendors.object_id Implied Constraint
mis_mr_lines.line_id mis_mr_lines_line_id_fk
mis_mrs.mr_id mis_mrs_mr_id_fk
mis_order_lines.line_id mis_order_lines_line_id_fkey
mis_orders.order_id mis_orders_order_id_fkey
mis_parties.party_id mis_parties_party_id_fkey
mis_party_mod.party_id mis_party_mod_party_id_fkey
mis_po_lines.line_id mis_po_lines_line_id_fk
mis_pos.po_id mis_pos_po_id_fk
mis_products.product_id mis_products_product_id_fkey
mis_projects_view.object_id Implied Constraint
mis_purc_invoice_lines.purc_invoice_line_id mis_purc_invoice_lines_purc_invoice_line_id_fkey
mis_purc_invoices.purc_invoice_id mis_purc_invoices_purc_invoice_id_fkey
mis_rec_note_lines.rec_line_id mis_rec_note_lines_rec_line_id_fkey
mis_rec_note_lines_view.object_id Implied Constraint
mis_rec_notes.rec_id mis_rec_notes_rec_id_fkey
mis_sale_invoice_lines.sale_invoice_line_id mis_sale_invoice_lines_sale_invoice_line_id_fkey
mis_sale_invoices.sale_invoice_id mis_sale_invoices_sale_invoice_id_fkey
mis_sale_invoices_view.object_id Implied Constraint
mis_scripts.script_id mis_scripts_script_id_fkey
mis_vendors.object_id Implied Constraint
parties.party_id parties_party_id_fk
object_type varchar 100
acs_object_types.object_type acs_objects_object_type_fk
title varchar 1000  √  null Title of the object if applicable.
Please note that in mid-term this column will replace all
titles or object_names of package specific tables.
package_id int4 10  √  null
apm_packages.package_id acs_objects_package_id_fk
Which package instance this object belongs to.
Please note that in mid-term this column will replace all
package_ids of package specific tables.
context_id int4 10  √  null
acs_objects.object_id acs_objects_context_id_fk
The context_id column points to an object that provides a context for
this object. Often this will reflect an observed hierarchy in a site,
for example a bboard message would probably list a bboard topic as
it's context, and a bboard topic might list a sub-site as it's
context. Whenever we ask a question of the form "can user X perform
action Y on object Z", the acs security model will defer to an
object's context if there is no information about user X's
permission to perform action Y on object Z.
security_inherit_p bool 1 true
creation_user int4 10  √  null
users.user_id acs_objects_creation_user_fk
Who created the object; may be null since objects can be created by
automated processes
creation_date timestamptz 35,6 now()
creation_ip varchar 50  √  null
last_modified timestamptz 35,6 now()
modifying_user int4 10  √  null
users.user_id acs_objects_modifying_user_fk
Who last modified the object
modifying_ip varchar 50  √  null
tree_sortkey varbit 2147483647
max_child_sortkey varbit 2147483647  √  null

Table contained 25,102 rows at Fri Feb 29 12:05 CET 2008

Indexes:
Column(s) Type Sort Constraint Name
object_id Primary key Asc acs_objects_pk
context_id + object_id Must be unique Asc/Asc acs_objects_context_object_un
creation_user Performance Asc acs_objects_creation_user_idx
modifying_user Performance Asc acs_objects_modify_user_idx
object_type Performance Asc acs_objects_object_type_idx
package_id + object_id Performance Asc/Asc acs_objects_package_object_idx
title Performance Asc acs_objects_title_idx
tree_sortkey Must be unique Asc acs_objects_tree_sortkey_un

Close relationships  within one two degrees of separation :