Noodle Help Site

Index of database - noodledb

Table: any_change_history

any_change_history Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
any_oid numeric(18,0) NOT NULL
users.object_id user_oid numeric(18,0) NOT NULL
change_time timestamp without time zone NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif453any_change_history any_oid xif454any_change_history user_oid xif455any_change_history site_oid xif456any_change_history change_time

Index - Schema public

Table: app_bb_message_details

app_bb_message_details Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
app_bb_message_details.item_oid response_to_oid numeric(18,0)
app_bb_message_details.item_oid root_message_oid numeric(18,0) NOT NULL
is_approved boolean NOT NULL DEFAULT false
is_disabled boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif126app_bb_message_details response_to_oid xif202app_bb_message_details site_oid xif279app_bb_message_details root_message_oid

Index - Schema public

Table: app_bb_viewed

app_bb_viewed Structure
F-Key Name Type Description
users.object_id user_oid numeric(18,0) PRIMARY KEY
app_bb_message_details.item_oid item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif145app_bb_viewed user_oid xif146app_bb_viewed item_oid xif203app_bb_viewed site_oid

Index - Schema public

Table: app_blog

app_blog Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) NOT NULL
object_id numeric(18,0) PRIMARY KEY
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif419app_blog site_oid

Index - Schema public

Table: app_cal_event_option_fields

app_cal_event_option_fields Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
field_name character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif371app_cal_event_option_fie site_oid

Index - Schema public

Table: app_cal_event_option_values

app_cal_event_option_values Structure
F-Key Name Type Description
app_calendar_events.item_oid event_oid numeric(18,0) PRIMARY KEY
app_cal_event_option_fields.object_id event_option_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) NOT NULL
value character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif373app_cal_event_option_val site_oid xif385app_cal_event_option_val event_oid xif386app_cal_event_option_val event_option_oid

Index - Schema public

Table: app_cal_location_assignments

app_cal_location_assignments Structure
F-Key Name Type Description
app_calendar_events.item_oid event_oid numeric(18,0) PRIMARY KEY
app_calendar_locations.object_id location_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0)
xif389app_cal_location_assignm site_oid xif395app_cal_location_assignm event_oid xif396app_cal_location_assignm location_oid

Index - Schema public

Table: app_calendar_event_types

app_calendar_event_types Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
name character varying(255) UNIQUE#1
icon oid
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) UNIQUE#1 NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif212app_calendar_event_types site_oid

Index - Schema public

Table: app_calendar_events

app_calendar_events Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
app_calendar_event_types.object_id event_type_oid numeric(18,0)
app_calendar_recurring_events.item_oid recurring_event_oid numeric(18,0)
timezone_code character varying(255) NOT NULL
event_date timestamp without time zone NOT NULL
end_date timestamp without time zone
duration integer
is_completed boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif163app_calendar_events recurring_event_oid xif210app_calendar_events site_oid xif92app_calendar_events event_type_oid

Index - Schema public

Table: app_calendar_locations

app_calendar_locations Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
name character varying(255) NOT NULL
description character varying(255)
address character varying(255)
contact_name character varying(255)
phone character varying(255)
image oid
content_types.object_id content_type_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0)

Tables referencing this one via Foreign Key Constraints:

xif387app_calendar_locations site_oid xif398app_calendar_locations content_type_oid

Index - Schema public

Table: app_calendar_recurring_events

app_calendar_recurring_events Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
period integer NOT NULL
frequency character(1) NOT NULL
begin_date timestamp without time zone NOT NULL
end_date timestamp without time zone NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif211app_calendar_recurring_e site_oid

Index - Schema public

Table: app_contact_assignments

app_contact_assignments Structure
F-Key Name Type Description
app_contact_groups.object_id group_oid numeric(18,0) PRIMARY KEY
app_contacts.item_oid contact_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif115app_contact_assignments group_oid xif116app_contact_assignments contact_oid xif206app_contact_assignments site_oid

Index - Schema public

Table: app_contact_field_values

app_contact_field_values Structure
F-Key Name Type Description
app_contact_fields.object_id field_oid numeric(18,0) PRIMARY KEY
app_contacts.item_oid contact_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
value character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif117app_contact_field_values field_oid xif118app_contact_field_values contact_oid xif209app_contact_field_values site_oid

Index - Schema public

Table: app_contact_fields

app_contact_fields Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
field_name character varying(255) UNIQUE#1 NOT NULL
is_mandatory boolean NOT NULL DEFAULT false
is_system boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) UNIQUE#1 NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif208app_contact_fields site_oid

Index - Schema public

Table: app_contact_groups

app_contact_groups Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
name character varying(255) NOT NULL
description character varying(255)
folders.object_id folder_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif112app_contact_groups folder_oid xif205app_contact_groups site_oid

Index - Schema public

Table: app_contacts

app_contacts Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif207app_contacts site_oid

Index - Schema public

Table: app_document_list

app_document_list Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif130app_document_list folder_oid xif219app_document_list site_oid

Index - Schema public

Table: app_document_versions

app_document_versions Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
date_locked timestamp without time zone
version_description character varying(255)
version_number integer NOT NULL
description character varying(255)
app_document_list.object_id list_oid numeric(18,0) NOT NULL
users.object_id locked_by_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif129app_document_versions list_oid xif169app_document_versions locked_by_oid xif220app_document_versions site_oid

Index - Schema public

Table: app_document_view_components

app_document_view_components Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) NOT NULL
component_order integer NOT NULL
component_name character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif369app_document_view_compon folder_oid xif370app_document_view_compon site_oid

Index - Schema public

Table: app_email_accounts

app_email_accounts Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
account_name character varying(255) NOT NULL
folders.object_id folder_oid numeric(18,0) NOT NULL
user_name character varying(255) NOT NULL
user_password character varying(255) NOT NULL
incoming_server character varying(255) NOT NULL
incoming_port integer NOT NULL
incoming_uses_ssl boolean NOT NULL DEFAULT false
outgoing_server character varying(255) NOT NULL
outgoing_port integer NOT NULL
outgoing_uses_ssl boolean NOT NULL DEFAULT false
server_type character varying(255) NOT NULL
leave_on_server boolean NOT NULL DEFAULT false
check_interval integer
full_name character varying(255) NOT NULL
email_address character varying(255) NOT NULL
reply_to_address character varying(255) NOT NULL
signature character varying(2000)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif105app_email_accounts folder_oid xif216app_email_accounts site_oid

Index - Schema public

Table: app_email_addresses

app_email_addresses Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
e_address character varying(255) NOT NULL
opt_name character varying(255)
opt_comment character varying(255)
address_type character(1) NOT NULL
app_email_details.item_oid email_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif174app_email_addresses email_oid xif218app_email_addresses site_oid

Index - Schema public

Table: app_email_contacts

app_email_contacts Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) NOT NULL
first_name character varying(255)
last_name character varying(255)
email_address character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif104app_email_contacts folder_oid xif213app_email_contacts site_oid

Index - Schema public

Table: app_email_deleted

app_email_deleted Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
unique_id character varying(255) NOT NULL
app_email_accounts.object_id account_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif182app_email_deleted account_oid xif215app_email_deleted site_oid

Index - Schema public

Table: app_email_details

app_email_details Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
app_email_accounts.object_id account_oid numeric(18,0) NOT NULL
unique_id character varying(255)
date_sent timestamp without time zone
date_received timestamp without time zone
is_new boolean NOT NULL DEFAULT false
charset_encoding character varying(255)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif179app_email_details account_oid xif217app_email_details site_oid

Index - Schema public

Table: app_email_filters

app_email_filters Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) NOT NULL
filter_name character varying(255) NOT NULL
check_field character varying(255) NOT NULL
filter_rule character(3) NOT NULL
pattern character varying(255) NOT NULL
is_case_sensitive boolean NOT NULL DEFAULT false
action character(3) NOT NULL
folders.object_id destination_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif175app_email_filters folder_oid xif176app_email_filters destination_oid xif214app_email_filters site_oid

Index - Schema public

Table: app_fm_attributes

app_fm_attributes Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
attr_name character varying(255) NOT NULL
attr_index integer NOT NULL
attr_value character varying(255) NOT NULL
app_fm_form_elements.object_id form_element_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif290app_fm_attributes site_oid xif293app_fm_attributes form_element_oid

Index - Schema public

Table: app_fm_binary_field_values

app_fm_binary_field_values Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
app_fm_form_elements.object_id form_element_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) NOT NULL
name character varying(255)
binary_data oid
content_types.object_id content_type_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif414app_fm_binary_field_valu content_type_oid xif415app_fm_binary_field_valu item_oid xif416app_fm_binary_field_valu form_element_oid xif418app_fm_binary_field_valu site_oid

Index - Schema public

Table: app_fm_columns

app_fm_columns Structure
F-Key Name Type Description
app_fm_reports.object_id report_oid numeric(18,0) PRIMARY KEY
app_fm_form_elements.object_id form_element_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
col_order integer NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif292app_fm_columns site_oid xif304app_fm_columns report_oid xif305app_fm_columns form_element_oid

Index - Schema public

Table: app_fm_field_values

app_fm_field_values Structure
F-Key Name Type Description
app_fm_forms.item_oid item_oid numeric(18,0) PRIMARY KEY
app_fm_form_elements.object_id form_element_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
field_value character varying(2000)
app_fm_attributes.object_id value_origin_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif285app_fm_field_values item_oid xif286app_fm_field_values form_element_oid xif289app_fm_field_values site_oid xif297app_fm_field_values value_origin_oid

Index - Schema public

Table: app_fm_form_elements

app_fm_form_elements Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
element_order integer NOT NULL
has_predefined_values boolean NOT NULL DEFAULT false
is_data_field boolean NOT NULL DEFAULT false
folders.object_id folder_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif282app_fm_form_elements folder_oid xif291app_fm_form_elements site_oid

Index - Schema public

Table: app_fm_forms

app_fm_forms Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
form_id integer UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif281app_fm_forms site_oid

Index - Schema public

Table: app_fm_idcounters

app_fm_idcounters Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
idcounter integer NOT NULL
idstring character(3)
folders.object_id folder_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif298app_fm_idcounters site_oid xif299app_fm_idcounters folder_oid

Index - Schema public

Table: app_fm_item_name_components

app_fm_item_name_components Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
leading_chars character varying(32)
trailing_chars character varying(32)
component_order integer NOT NULL
app_fm_form_elements.object_id form_element_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif306app_fm_item_name_compone site_oid xif307app_fm_item_name_compone form_element_oid

Index - Schema public

Table: app_fm_reports

app_fm_reports Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
report_name character varying(255) NOT NULL
has_id boolean NOT NULL DEFAULT false
has_date_created boolean NOT NULL DEFAULT false
has_date_modified boolean NOT NULL DEFAULT false
app_fm_form_elements.object_id sort_by_form_element_oid numeric(18,0)
app_fm_form_elements.object_id group_by_form_element_oid numeric(18,0)
wrap_columns boolean NOT NULL DEFAULT false
show_grid_lines boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif301app_fm_reports site_oid xif340app_fm_reports sort_by_form_element_oid xif341app_fm_reports group_by_form_element_oid

Index - Schema public

Table: app_headlines

app_headlines Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif223app_headlines site_oid

Index - Schema public

Table: app_image_details

app_image_details Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif221app_image_details site_oid

Index - Schema public

Table: app_links

app_links Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
url character varying(255) NOT NULL
in_new_window boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif222app_links site_oid

Index - Schema public

Table: app_mcal_calendars

app_mcal_calendars Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
color character(6) NOT NULL
object_id numeric(18,0) UNIQUE NOT NULL
folders.object_id folder_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif277app_mcal_calendars folder_oid xif278app_mcal_calendars site_oid

Index - Schema public

Table: app_memo_broadcast_times

app_memo_broadcast_times Structure
F-Key Name Type Description
app_memos.item_oid item_oid numeric(18,0) NOT NULL
object_id numeric(18,0) PRIMARY KEY
broadcast_time timestamp without time zone NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif316app_memo_broadcast_times site_oid xif320app_memo_broadcast_times item_oid

Index - Schema public

Table: app_memo_recipients

app_memo_recipients Structure
F-Key Name Type Description
app_memos.item_oid item_oid numeric(18,0) NOT NULL
users.object_id user_oid numeric(18,0)
object_id numeric(18,0) PRIMARY KEY
groups.object_id group_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif310app_memo_recipients site_oid xif317app_memo_recipients group_oid xif318app_memo_recipients user_oid xif319app_memo_recipients item_oid

Index - Schema public

Table: app_memos

app_memos Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
folders.object_id referred_folder numeric(18,0)
begin_date timestamp without time zone NOT NULL
sent_from character varying(255)
end_date timestamp without time zone NOT NULL
period integer
is_recurring boolean NOT NULL DEFAULT false
frequency character(1)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
timezone_code character varying(255) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif308app_memos site_oid xif323app_memos referred_folder

Index - Schema public

Table: app_messages

app_messages Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
users.object_id to_user_oid numeric(18,0) NOT NULL
users.object_id from_user_oid numeric(18,0) NOT NULL
seen_by_sender boolean
seen_by_recever boolean
deleted_by_sender boolean
deleted_by_recever boolean
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif426app_messages site_oid xif427app_messages to_user_oid xif428app_messages from_user_oid

Index - Schema public

Table: app_poll_option_votes

app_poll_option_votes Structure
F-Key Name Type Description
app_poll_options.object_id poll_option_oid numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif365app_poll_option_votes poll_option_oid xif366app_poll_option_votes user_oid xif367app_poll_option_votes site_oid

Index - Schema public

Table: app_poll_options

app_poll_options Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
app_polls.object_id poll_oid numeric(18,0) NOT NULL
poll_option character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif363app_poll_options poll_oid xif368app_poll_options site_oid

Index - Schema public

Table: app_polls

app_polls Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
app_portlets.object_id portlet_oid numeric(18,0) NOT NULL
poll_name character varying(255) NOT NULL
poll_question character varying(255) NOT NULL
poll_expiration timestamp without time zone
results_hidden_until_expired boolean NOT NULL DEFAULT false
results_are_anonymous boolean NOT NULL DEFAULT true
results_are_changeable boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif360app_polls portlet_oid xif361app_polls site_oid

Index - Schema public

Table: app_portal_layouts

app_portal_layouts Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
layout_id integer NOT NULL
folders.object_id folder_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif345app_portal_layouts folder_oid xif353app_portal_layouts site_oid

Index - Schema public

Table: app_portlet_attributes

app_portlet_attributes Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
app_portlets.object_id portlet_oid numeric(18,0)
attribute_name character varying(255)
attribute_value character varying(255)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif352app_portlet_attributes portlet_oid xif355app_portlet_attributes site_oid

Index - Schema public

Table: app_portlet_headline_details

app_portlet_headline_details Structure
F-Key Name Type Description
app_headlines.item_oid item_oid numeric(18,0) PRIMARY KEY
app_portlets.object_id portlet_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif347app_portlet_headline_det item_oid xif351app_portlet_headline_det portlet_oid xif356app_portlet_headline_det site_oid

Index - Schema public

Table: app_portlets

app_portlets Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
container_id integer NOT NULL
folders.object_id section_oid numeric(18,0) NOT NULL
portlet_order integer NOT NULL
portlet_type character varying(255) NOT NULL
folders.object_id folder_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif354app_portlets site_oid xif357app_portlets section_oid xif359app_portlets folder_oid

Index - Schema public

Table: app_props

app_props Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
pname character varying(255) NOT NULL
pvalue character varying(255) NOT NULL
pnamespace character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif460app_props item_oid xif461app_props site_oid xif462app_props pname

Index - Schema public

Table: app_question_lists

app_question_lists Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif429app_question_lists site_oid

Index - Schema public

Table: app_questions

app_questions Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
users.object_id user_oid numeric(18,0) NOT NULL
app_questions.object_id answer_oid numeric(18,0)
app_question_lists.object_id list_oid numeric(18,0)
q_or_a boolean NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif430app_questions site_oid xif431app_questions q_or_a xif432app_questions list_oid

Index - Schema public

Table: app_status

app_status Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
users.object_id user_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif425app_status site_oid

Index - Schema public

Table: app_tags

app_tags Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
name character varying(255) UNIQUE#1 NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) UNIQUE#1 NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif437app_tags site_oid xif438app_tags name

Index - Schema public

Table: app_task_lists

app_task_lists Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif433app_task_lists site_oid

Index - Schema public

Table: app_tasks

app_tasks Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
users.object_id from_user_oid numeric(18,0) NOT NULL
users.object_id to_user_oid numeric(18,0)
app_task_lists.object_id list_oid numeric(18,0)
complete character(1) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif434app_tasks site_oid xif435app_tasks to_user_oid xif436app_tasks list_oid

Index - Schema public

Table: app_wave_members

app_wave_members Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) NOT NULL
folders.object_id folder_oid numeric(18,0) NOT NULL
serial integer NOT NULL
site_oid numeric(18,0) NOT NULL
xif437app_wave_members site_oid xif438app_wave_members folder_oid

Index - Schema public

Table: app_wave_topics

app_wave_topics Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif436app_wave_topics site_oid

Index - Schema public

Table: app_waves

app_waves Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
app_wave_topics.object_id topic_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif434app_waves site_oid xif435app_waves topic_oid

Index - Schema public

Table: applications

applications Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
name character varying(255) NOT NULL
content_name character varying(255) NOT NULL
is_system_app boolean NOT NULL DEFAULT false
is_main_app boolean NOT NULL DEFAULT false
run_string character varying(255) NOT NULL
icons.object_id icon_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif224applications site_oid xif60applications icon_oid

Index - Schema public

Table: change_history

change_history Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
users.object_id user_oid numeric(18,0) NOT NULL
folders.object_id folder_oid numeric(18,0)
change_time timestamp without time zone NOT NULL
change_type character(1) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xie1change_history change_time xif270change_history item_oid xif271change_history folder_oid xif272change_history user_oid xif274change_history site_oid

Index - Schema public

Table: content_types

content_types Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
content_type character varying(255) NOT NULL
small_icon oid
large_icon oid
is_unshowable boolean NOT NULL DEFAULT false
is_embeddable boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif227content_types site_oid

Index - Schema public

Table: errorlog

errorlog Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
applications.object_id application_oid numeric(18,0)
users.object_id user_oid numeric(18,0)
log_time timestamp without time zone NOT NULL
code character varying(255)
description character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif332errorlog user_oid xif333errorlog application_oid xif334errorlog site_oid

Index - Schema public

Table: folder_settings

folder_settings Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) UNIQUE#1 NOT NULL
name character varying(255) UNIQUE#1 NOT NULL
value character varying(255)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) UNIQUE#1 NOT NULL
xif197folder_settings folder_oid xif226folder_settings site_oid

Index - Schema public

Table: folders

folders Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
folders.object_id parent_folder_oid numeric(18,0)
icons.object_id icon_oid numeric(18,0) NOT NULL
applications.object_id application_oid numeric(18,0) NOT NULL
users.object_id created_by_user_oid numeric(18,0) NOT NULL
users.object_id modified_by_user_oid numeric(18,0) NOT NULL
users.object_id trashed_by_user_oid numeric(18,0)
name character varying(255) NOT NULL
date_created timestamp without time zone NOT NULL
date_modified timestamp without time zone NOT NULL
date_trashed timestamp without time zone
f_order numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif225folders site_oid xif24folders application_oid xif42folders created_by_user_oid xif43folders modified_by_user_oid xif44folders trashed_by_user_oid xif59folders icon_oid xif71folders parent_folder_oid

Index - Schema public

Table: global_app_settings

global_app_settings Structure
F-Key Name Type Description
applications.object_id application_oid numeric(18,0) PRIMARY KEY
name character varying(255) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
value character varying(255)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif234global_app_settings site_oid xif32global_app_settings application_oid

Index - Schema public

Table: group_access

group_access Structure
F-Key Name Type Description
folders.object_id folder_oid numeric(18,0) PRIMARY KEY
groups.object_id group_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
can_read boolean NOT NULL DEFAULT false
can_post boolean NOT NULL DEFAULT false
can_modify boolean NOT NULL DEFAULT false
can_route boolean NOT NULL DEFAULT false
is_administrator boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif233group_access site_oid xif27group_access folder_oid xif28group_access group_oid

Index - Schema public

Table: group_memberships

group_memberships Structure
F-Key Name Type Description
users.object_id user_oid numeric(18,0) PRIMARY KEY
groups.object_id group_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif10group_memberships user_oid xif11group_memberships group_oid xif231group_memberships site_oid

Index - Schema public

Table: group_notifications

group_notifications Structure
F-Key Name Type Description
groups.object_id group_oid numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
notify_when_created boolean NOT NULL DEFAULT false
notify_when_modified boolean NOT NULL DEFAULT false
notify_when_moved boolean NOT NULL DEFAULT false
notify_when_routed boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif324group_notifications group_oid xif326group_notifications folder_oid xif328group_notifications site_oid

Index - Schema public

Table: groups

groups Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
group_name character varying(255) NOT NULL
parent_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif232groups site_oid

Index - Schema public

Table: icons

icons Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
small_icon oid
large_icon oid
is_system boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif235icons site_oid

Index - Schema public

Table: index_queue

index_queue Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
serial integer NOT NULL
items.object_id item_oid numeric(18,0) NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif261index_queue item_oid xif262index_queue site_oid

Index - Schema public

Table: index_table

index_table Structure
F-Key Name Type Description
main_dictionary.object_id dictionary_oid numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
word_repetition integer NOT NULL DEFAULT 1
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif180index_table dictionary_oid xif181index_table item_oid xif237index_table site_oid

Index - Schema public

Table: item_priority

item_priority Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
priority numeric(18,0) NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
serial integer NOT NULL
xif450item_priority item_oid xif451item_priority priority xif452item_priority site_oid

Index - Schema public

Table: items

items Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id parent_item_oid numeric(18,0)
item_class character(3) NOT NULL
name character varying(255)
file_name character varying(255)
binary_data oid
content_types.object_id content_type_oid numeric(18,0)
item_data_size integer NOT NULL
folders.object_id folder_oid numeric(18,0) NOT NULL
users.object_id created_by_user_oid numeric(18,0) NOT NULL
users.object_id modified_by_user_oid numeric(18,0) NOT NULL
users.object_id trashed_by_user_oid numeric(18,0)
date_created timestamp without time zone NOT NULL
date_modified timestamp without time zone NOT NULL
date_trashed timestamp without time zone
expiry_date timestamp without time zone
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xie1items_created date_created xie2items_modified date_modified xie3items_trashed date_trashed xif164items parent_item_oid xif165items content_type_oid xif236items site_oid xif30items folder_oid xif443items expiry_date xif46items created_by_user_oid xif47items modified_by_user_oid xif48items trashed_by_user_oid

Index - Schema public

Table: keywords

keywords Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
keyword character varying(255) NOT NULL
items.object_id item_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif135keywords item_oid xif238keywords site_oid

Index - Schema public

Table: language_keywords

language_keywords Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
keyword_code character varying(255) UNIQUE#1 NOT NULL
languages.object_id language_oid numeric(18,0) UNIQUE#1 NOT NULL
keyword_value character varying(255)
serial integer NOT NULL
xif66language_keywords language_oid

Index - Schema public

Table: languages

languages Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
language_code character varying(255) UNIQUE NOT NULL
native_language_name character varying(255) NOT NULL
english_language_name character varying(255) NOT NULL
last_updated timestamp without time zone NOT NULL
serial integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: main_dictionary

main_dictionary Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
dict_entry character varying(255) UNIQUE NOT NULL
serial integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: notification_messages

notification_messages Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) NOT NULL
action character(1) NOT NULL
message character varying(2000)
subject character varying(255)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif335notification_messages folder_oid xif336notification_messages site_oid

Index - Schema public

Table: quick_links

quick_links Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
name character varying(255) NOT NULL
folders.object_id folder_oid numeric(18,0)
quick_sections.object_id quick_section_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif152quick_links folder_oid xif155quick_links quick_section_oid xif244quick_links site_oid

Index - Schema public

Table: quick_sections

quick_sections Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
name character varying(255) NOT NULL
is_default boolean NOT NULL DEFAULT false
users.object_id user_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif154quick_sections user_oid xif243quick_sections site_oid

Index - Schema public

Table: ratings

ratings Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
value integer NOT NULL
date_voted timestamp without time zone
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif264ratings item_oid xif265ratings user_oid xif275ratings site_oid

Index - Schema public

Table: reminder_broadcast_times

reminder_broadcast_times Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
reminders.object_id reminder_oid numeric(18,0) NOT NULL
broadcast_time timestamp without time zone NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
serial integer NOT NULL
xif406reminder_broadcast_times reminder_oid xif407reminder_broadcast_times site_oid

Index - Schema public

Table: reminder_recipients

reminder_recipients Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
reminders.object_id reminder_oid numeric(18,0) NOT NULL
users.object_id user_oid numeric(18,0)
groups.object_id group_oid numeric(18,0)
sites.object_id site_oid numeric(18,0) NOT NULL
serial integer NOT NULL
rsvp character(2)
xif402reminder_recipients reminder_oid xif403reminder_recipients user_oid xif404reminder_recipients group_oid xif405reminder_recipients site_oid xif463reminder_recipients rsvp

Index - Schema public

Table: reminders

reminders Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id referred_item_oid numeric(18,0)
users.object_id from_user_oid numeric(18,0) NOT NULL
begin_date timestamp without time zone NOT NULL
end_date timestamp without time zone NOT NULL
is_recurring character(1) NOT NULL DEFAULT '0'::bpchar
period integer
frequency character(1)
timezone_code character varying(255) NOT NULL
message character varying(2000)
sites.object_id site_oid numeric(18,0) NOT NULL
serial integer NOT NULL

 

reminders Constraints
Name Constraint
reminders_is_recurring_check CHECK ((is_recurring = ANY (ARRAY['0'::bpchar, '1'::bpchar])))

Tables referencing this one via Foreign Key Constraints:

xif399reminders from_user_oid xif400reminders referred_item_oid xif401reminders site_oid

Index - Schema public

Table: routes

routes Structure
F-Key Name Type Description
folders.object_id source_folder_oid numeric(18,0) PRIMARY KEY
folders.object_id destination_folder_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
description character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif267routes source_folder_oid xif269routes destination_folder_oid xif273routes site_oid

Index - Schema public

Table: sessions

sessions Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
last_session_id character varying(255) NOT NULL
users.object_id user_oid numeric(18,0) NOT NULL
ip_address character(15) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif199sessions user_oid xif239sessions site_oid

Index - Schema public

Table: site_field_values

site_field_values Structure
F-Key Name Type Description
sites.object_id site_oid numeric(18,0) PRIMARY KEY
site_fields.object_id site_field_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
value character varying(255) NOT NULL
serial integer NOT NULL
xif253site_field_values site_oid xif254site_field_values site_field_oid

Index - Schema public

Table: site_fields

site_fields Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
field_name character varying(255) UNIQUE NOT NULL
is_mandatory boolean NOT NULL DEFAULT false
is_system boolean NOT NULL DEFAULT false
serial integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: sites

sites Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
site_name character varying(255) NOT NULL
date_created timestamp without time zone NOT NULL
date_deleted timestamp without time zone
is_disabled boolean NOT NULL DEFAULT false
is_registered boolean NOT NULL DEFAULT false
serial integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: spelling_dictionary

spelling_dictionary Structure
F-Key Name Type Description
object_id numeric(18,0) NOT NULL
acceptable_word character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif263spelling_dictionary site_oid

Index - Schema public

Table: subfolders

subfolders Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) NOT NULL
folders.object_id subfolder_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif441subfolders folder_oid xif442subfolders subfolder_oid xif443subfolders site_oid

Index - Schema public

Table: sync_clients

sync_clients Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
client_type character varying(255) UNIQUE#1 NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) UNIQUE#1 NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif241sync_clients site_oid

Index - Schema public

Table: synchronized_items

synchronized_items Structure
F-Key Name Type Description
items.object_id item_oid numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) PRIMARY KEY
sync_clients.object_id sync_client_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
sync_id character varying(255)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif188synchronized_items item_oid xif189synchronized_items user_oid xif195synchronized_items sync_client_oid xif242synchronized_items site_oid

Index - Schema public

Table: syslog

syslog Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0)
applications.object_id application_oid numeric(18,0)
log_time timestamp without time zone NOT NULL
ip_address character(15) NOT NULL
code character varying(255)
description character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xie1syslog log_time xif150syslog application_oid xif151syslog user_oid xif240syslog site_oid

Index - Schema public

Table: system_settings

system_settings Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
key_name character varying(255) UNIQUE#1 NOT NULL
category character varying(255)
is_critical_setting boolean NOT NULL DEFAULT false
type character(1) NOT NULL
value character varying(255)
binary_data oid
content_types.object_id content_type_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) UNIQUE#1 NOT NULL
subcategory character varying(256)
xif166system_settings content_type_oid xif245system_settings site_oid xif464system_settings subcategory

Index - Schema public

Table: tagged_items

tagged_items Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
app_tags.object_id tag_oid numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif460tagged_items item_oid xif461tagged_items tag_oid xif462tagged_items site_oid

Index - Schema public

Table: template_user_details

template_user_details Structure
F-Key Name Type Description
users.object_id user_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
name character varying(255) NOT NULL
description character varying(255)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif343template_user_details site_oid

Index - Schema public

Table: user_access

user_access Structure
F-Key Name Type Description
folders.object_id folder_oid numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
can_read boolean NOT NULL DEFAULT false
can_post boolean NOT NULL DEFAULT false
can_modify boolean NOT NULL DEFAULT false
can_route boolean NOT NULL DEFAULT false
is_administrator boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif251user_access site_oid xif25user_access folder_oid xif26user_access user_oid

Index - Schema public

Table: user_app_settings

user_app_settings Structure
F-Key Name Type Description
applications.object_id application_oid numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) PRIMARY KEY
name character varying(255) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
value character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif252user_app_settings site_oid xif33user_app_settings application_oid xif34user_app_settings user_oid

Index - Schema public

Table: user_expertise

user_expertise Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) NOT NULL
user_expertise_types.object_id expertise_type numeric(18,0) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0)

Index - Schema public

Table: user_expertise_types

user_expertise_types Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
name character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
group_oid numeric(18,0)

Tables referencing this one via Foreign Key Constraints:

xif420user_expertise_types site_oid

Index - Schema public

Table: user_field_values

user_field_values Structure
F-Key Name Type Description
user_fields.object_id user_field_oid numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
value character varying(255) NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif248user_field_values site_oid xif8user_field_values user_oid xif9user_field_values user_field_oid

Index - Schema public

Table: user_fields

user_fields Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
field_name character varying(255) UNIQUE#1 NOT NULL
is_mandatory boolean NOT NULL DEFAULT false
is_system boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) UNIQUE#1 NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif247user_fields site_oid

Index - Schema public

Table: user_folder_settings

user_folder_settings Structure
F-Key Name Type Description
users.object_id user_oid numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) PRIMARY KEY
name character varying(255) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
value character varying(255)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif255user_folder_settings user_oid xif256user_folder_settings folder_oid xif258user_folder_settings site_oid

Index - Schema public

Table: user_group_members

user_group_members Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) NOT NULL
user_groups.object_id user_group_oid numeric(18,0) NOT NULL
serial integer NOT NULL
site_oid numeric(18,0) NOT NULL
xif440user_group_members site_oid

Index - Schema public

Table: user_groups

user_groups Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
group_name character varying(255) NOT NULL
users.object_id owner numeric(18,0) NOT NULL
is_system character(1) NOT NULL DEFAULT '0'::bpchar
serial integer NOT NULL
site_oid numeric(18,0) NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif439user_groups site_oid

Index - Schema public

Table: user_notifications

user_notifications Structure
F-Key Name Type Description
users.object_id user_oid numeric(18,0) PRIMARY KEY
folders.object_id folder_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
notify_when_created boolean NOT NULL DEFAULT false
notify_when_modified boolean NOT NULL DEFAULT false
notify_when_moved boolean NOT NULL DEFAULT false
notify_when_routed boolean NOT NULL DEFAULT false
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif325user_notifications user_oid xif327user_notifications folder_oid xif329user_notifications site_oid

Index - Schema public

Table: users

users Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
username character varying(255) UNIQUE#1 NOT NULL
password character varying(255)
last_login timestamp without time zone
is_locked boolean NOT NULL DEFAULT false
is_removed boolean NOT NULL DEFAULT false
image oid
languages.object_id language_oid numeric(18,0) NOT NULL
content_types.object_id content_type_oid numeric(18,0)
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) UNIQUE#1 NOT NULL
last_changed timestamp without time zone

Tables referencing this one via Foreign Key Constraints:

xif132users content_type_oid xif250users site_oid xif55users language_oid

Index - Schema public

Table: whatsnew_links

whatsnew_links Structure
F-Key Name Type Description
folders.object_id folder_oid numeric(18,0) PRIMARY KEY
users.object_id user_oid numeric(18,0) PRIMARY KEY
object_id numeric(18,0) UNIQUE NOT NULL
serial integer NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
xif193whatsnew_links folder_oid xif194whatsnew_links user_oid xif249whatsnew_links site_oid

Index - Schema public

Table: word_hits

word_hits Structure
F-Key Name Type Description
main_dictionary.object_id dictionary_oid numeric(18,0) PRIMARY KEY
hits numeric(18,0) NOT NULL
sites.object_id site_oid numeric(18,0) PRIMARY KEY
xif457word_hits dictionary_oid xif458word_hits hits xif459word_hits site_oid

Index - Schema public

Table: workflow

workflow Structure
F-Key Name Type Description
name character varying(255) NOT NULL
folders.object_id folder_oid numeric(18,0) NOT NULL
object_id numeric(18,0) PRIMARY KEY
sites.object_id site_oid numeric(18,0) NOT NULL
serial integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif439workflow folder_oid xif440workflow site_oid

Index - Schema public

Table: workflow_items

workflow_items Structure
F-Key Name Type Description
object_id numeric(18,0) PRIMARY KEY
items.object_id item_oid numeric(18,0) NOT NULL
step_oid numeric(18,0) NOT NULL
data character varying(255) NOT NULL
state integer NOT NULL
wdate timestamp without time zone NOT NULL
sites.object_id site_oid numeric(18,0) NOT NULL
serial integer NOT NULL
xif446workflow_items item_oid xif447workflow_items state xif448workflow_items step_oid xif449workflow_items site_oid

Index - Schema public

Table: workflow_steps

workflow_steps Structure
F-Key Name Type Description
name character varying(255) NOT NULL
workflow.object_id workflow_oid numeric(18,0) NOT NULL
choice_type integer NOT NULL
data character varying(255) NOT NULL
workflow_steps.object_id yes_step_oid numeric(18,0)
workflow_steps.object_id no_step_oid numeric(18,0)
choice_logic integer NOT NULL
users.object_id user_oid numeric(18,0)
groups.object_id group_oid numeric(18,0)
object_id numeric(18,0) PRIMARY KEY
sites.object_id site_oid numeric(18,0) NOT NULL
serial integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

xif441workflow_steps workflow_oid xif442workflow_steps choice_type xif443workflow_steps user_oid xif444workflow_steps group_oid xif445workflow_steps site_oid

Index - Schema public

Function: lo_manage()

Returns: trigger

Language: C

lo_manage

Function: lo_oid(public.lo)

Returns: oid

Language: SQL

SELECT $1::pg_catalog.oid

Function: make_triggers()

Returns: void

Language: PLPGSQL

BEGIN  IF EXISTS(	SELECT  proname	FROM    pg_catalog.pg_namespace n	JOIN    pg_catalog.pg_proc p	ON      pronamespace = n.oid	WHERE   nspname = 'public'	AND proname='lo_manage'  ) THEN	CREATE TRIGGER T_ICONS_SMALL_ICON BEFORE UPDATE OR DELETE ON ICONS FOR EACH ROW EXECUTE PROCEDURE lo_manage(SMALL_ICON);	CREATE TRIGGER T_ICONS_LARGE_ICON BEFORE UPDATE OR DELETE ON ICONS FOR EACH ROW EXECUTE PROCEDURE lo_manage(LARGE_ICON);	CREATE TRIGGER T_CONTENT_TYPES_SMALL_ICON BEFORE UPDATE OR DELETE ON CONTENT_TYPES FOR EACH ROW EXECUTE PROCEDURE lo_manage(SMALL_ICON);	CREATE TRIGGER T_CONTENT_TYPES_LARGE_ICON BEFORE UPDATE OR DELETE ON CONTENT_TYPES FOR EACH ROW EXECUTE PROCEDURE lo_manage(LARGE_ICON);	CREATE TRIGGER T_USERS_IMAGE BEFORE UPDATE OR DELETE ON USERS FOR EACH ROW EXECUTE PROCEDURE lo_manage(IMAGE);	CREATE TRIGGER T_ITEMS_BINARY_DATA BEFORE UPDATE OR DELETE ON ITEMS FOR EACH ROW EXECUTE PROCEDURE lo_manage(BINARY_DATA);	CREATE TRIGGER T_SYSTEM_SETTINGS_BINARY_DATA BEFORE UPDATE OR DELETE ON SYSTEM_SETTINGS FOR EACH ROW EXECUTE PROCEDURE lo_manage(BINARY_DATA);	CREATE TRIGGER T_APP_CALENDAR_EVENT_TYPES_ICON BEFORE UPDATE OR DELETE ON APP_CALENDAR_EVENT_TYPES FOR EACH ROW EXECUTE PROCEDURE lo_manage(ICON);	CREATE TRIGGER T_APP_FM_BINARY_FIELD_VALUES_BINARY_DATA BEFORE UPDATE OR DELETE ON APP_FM_BINARY_FIELD_VALUES FOR EACH ROW EXECUTE PROCEDURE lo_manage(BINARY_DATA);	CREATE TRIGGER T_APP_CALENDAR_LOCATIONS_IMAGE BEFORE UPDATE OR DELETE ON APP_CALENDAR_LOCATIONS FOR EACH ROW EXECUTE PROCEDURE lo_manage(IMAGE); END IF;END;