Created on 2014-06-27

Index of database - crm


Table: access

access Structure
F-Key Name Type Description
user_id integer PRIMARY KEY DEFAULT nextval('access_user_id_seq'::regclass)
username character varying(80) NOT NULL
password character varying(80)
contact_id integer DEFAULT (-1)
role_id integer DEFAULT (-1)
manager_id integer DEFAULT (-1)
startofday integer DEFAULT 8
endofday integer DEFAULT 18
locale character varying(255)
timezone character varying(255) DEFAULT 'America/New_York'::character varying
last_ip character varying(40)
last_login timestamp(3) without time zone NOT NULL DEFAULT now()
enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
expires timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
alias integer DEFAULT (-1)
assistant integer DEFAULT (-1)
enabled boolean NOT NULL DEFAULT true
currency character varying(5)
language character varying(20)
webdav_password character varying(80)
hidden boolean DEFAULT false
lookup_site_id.code site_id integer
allow_webdav_access boolean NOT NULL DEFAULT true
allow_httpapi_access boolean NOT NULL DEFAULT true
temp_password character varying(80)
temp_webdav_password character varying(80)
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

access_instance_id instance_id

Index - Schema public


Table: access_log

access_log Structure
F-Key Name Type Description
id serial PRIMARY KEY
access.user_id user_id integer NOT NULL
username character varying(80) NOT NULL
ip character varying(40)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
browser character varying(255)
instance_id bigint NOT NULL
access_log_instance_id instance_id

Index - Schema public


Table: account_type_levels

account_type_levels Structure
F-Key Name Type Description
organization.org_id org_id integer NOT NULL
lookup_account_types.code type_id integer NOT NULL
level integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
account_type_levels_instance_id instance_id

Index - Schema public


Table: action_item

action_item Structure
F-Key Name Type Description
item_id integer PRIMARY KEY DEFAULT nextval('action_item_code_seq'::regclass)
action_list.action_id action_id integer NOT NULL
link_item_id integer NOT NULL
completedate timestamp(3) without time zone
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_item_instance_id instance_id

Index - Schema public


Table: action_item_log

action_item_log Structure
F-Key Name Type Description
log_id integer PRIMARY KEY DEFAULT nextval('action_item_log_code_seq'::regclass)
action_item.item_id item_id integer NOT NULL
link_item_id integer DEFAULT (-1)
type integer NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
action_item_log_instance_id instance_id

Index - Schema public


Table: action_item_work

action_item_work Structure
F-Key Name Type Description
item_work_id serial PRIMARY KEY
action_phase_work.phase_work_id phase_work_id integer NOT NULL
action_step.step_id action_step_id integer NOT NULL
status_id integer
access.user_id owner integer
start_date timestamp(3) without time zone
end_date timestamp(3) without time zone
action_plan_constants.map_id link_module_id integer
link_item_id integer
level integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_item_work_instance_id instance_id

Index - Schema public


Table: action_item_work_notes

action_item_work_notes Structure
F-Key Name Type Description
note_id serial PRIMARY KEY
action_item_work.item_work_id item_work_id integer NOT NULL
description character varying(4096) NOT NULL
submitted timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id submittedby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
action_item_work_notes_instance_id instance_id

Index - Schema public


Table: action_item_work_selection

action_item_work_selection Structure
F-Key Name Type Description
selection_id serial PRIMARY KEY
action_item_work.item_work_id item_work_id integer NOT NULL
action_step_lookup.code selection integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
action_item_work_selection_instance_id instance_id

Index - Schema public


Table: action_list

action_list Structure
F-Key Name Type Description
action_id integer PRIMARY KEY DEFAULT nextval('action_list_code_seq'::regclass)
description character varying(255) NOT NULL
access.user_id owner integer NOT NULL
completedate timestamp(3) without time zone
link_module_id integer NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_list_instance_id instance_id

Index - Schema public


Table: action_phase

action_phase Structure
F-Key Name Type Description
phase_id serial PRIMARY KEY
action_phase.phase_id parent_id integer
action_plan.plan_id plan_id integer NOT NULL
phase_name character varying(255) NOT NULL
description character varying(2048)
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
random boolean DEFAULT false
global boolean DEFAULT false
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_phase_instance_id instance_id

Index - Schema public


Table: action_phase_work

action_phase_work Structure
F-Key Name Type Description
phase_work_id serial PRIMARY KEY
action_plan_work.plan_work_id plan_work_id integer NOT NULL
action_phase.phase_id action_phase_id integer NOT NULL
status_id integer
start_date timestamp(3) without time zone
end_date timestamp(3) without time zone
level integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_phase_work_instance_id instance_id

Index - Schema public


Table: action_plan

action_plan Structure
F-Key Name Type Description
plan_id serial PRIMARY KEY
plan_name character varying(255) NOT NULL
description character varying(2048)
enabled boolean NOT NULL DEFAULT true
approved timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
archive_date timestamp(3) without time zone
action_plan_category.id cat_code integer
action_plan_category.id subcat_code1 integer
action_plan_category.id subcat_code2 integer
action_plan_category.id subcat_code3 integer
action_plan_constants.map_id link_object_id integer
lookup_site_id.code site_id integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_plan_instance_id instance_id

Index - Schema public


Table: action_plan_category

action_plan_category Structure
F-Key Name Type Description
id serial PRIMARY KEY
cat_level integer NOT NULL
parent_cat_code integer NOT NULL
description character varying(300) NOT NULL
full_description text NOT NULL DEFAULT ''::text
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
lookup_site_id.code site_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_plan_category_instance_id instance_id

Index - Schema public


Table: action_plan_category_draft

action_plan_category_draft Structure
F-Key Name Type Description
id serial PRIMARY KEY
link_id integer DEFAULT (-1)
cat_level integer NOT NULL
parent_cat_code integer NOT NULL
description character varying(300) NOT NULL
full_description text NOT NULL DEFAULT ''::text
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
lookup_site_id.code site_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
action_plan_category_draft_instance_id instance_id

Index - Schema public


Table: action_plan_constants

action_plan_constants Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
constant_id integer NOT NULL
description character varying(300)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_plan_constant_id constant_id action_plan_constants_instance_id instance_id

Index - Schema public


Table: action_plan_editor_lookup

action_plan_editor_lookup Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('action_plan_editor_loo_id_seq'::regclass)
permission_category.category_id module_id integer NOT NULL
action_plan_constants.map_id constant_id integer NOT NULL
level integer
description text
entered timestamp(3) without time zone DEFAULT now()
category_id integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
action_plan_editor_lookup_instance_id instance_id

Index - Schema public


Table: action_plan_work

action_plan_work Structure
F-Key Name Type Description
plan_work_id serial PRIMARY KEY
action_plan.plan_id action_plan_id integer NOT NULL
manager integer
access.user_id assignedto integer NOT NULL
action_plan_constants.map_id link_module_id integer NOT NULL
link_item_id integer NOT NULL
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
action_phase.phase_id current_phase integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_plan_work_instance_id instance_id

Index - Schema public


Table: action_plan_work_notes

action_plan_work_notes Structure
F-Key Name Type Description
note_id serial PRIMARY KEY
action_plan_work.plan_work_id plan_work_id integer NOT NULL
description character varying(4096) NOT NULL
submitted timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id submittedby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
action_plan_work_notes_instance_id instance_id

Index - Schema public


Table: action_step

action_step Structure
F-Key Name Type Description
step_id serial PRIMARY KEY
action_step.step_id parent_id integer
action_phase.phase_id phase_id integer NOT NULL
description character varying(2048)
lookup_duration_type.code duration_type_id integer
estimated_duration integer
custom_field_category.category_id category_id integer
custom_field_info.field_id field_id integer
permission_type integer
role.role_id role_id integer
lookup_department.code department_id integer
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
allow_skip_to_here boolean NOT NULL DEFAULT false
label character varying(80)
action_required boolean NOT NULL DEFAULT false
user_group.group_id group_id integer
target_relationship character varying(80)
action_id integer
allow_update boolean NOT NULL DEFAULT true
campaign_component.component_id campaign_component_id integer
allow_duplicate_recipient boolean NOT NULL DEFAULT false
display_in_plan_list boolean NOT NULL DEFAULT false
plan_list_label character varying(300)
quick_complete boolean NOT NULL DEFAULT false
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_step_instance_id instance_id

Index - Schema public


Table: action_step_account_types

action_step_account_types Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('action_step_account_types_id_seq'::regclass)
action_step.step_id step_id integer NOT NULL
lookup_account_types.code type_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
action_step_account_types_instance_id instance_id

Index - Schema public


Table: action_step_lookup

action_step_lookup Structure
F-Key Name Type Description
code serial PRIMARY KEY
action_step.step_id step_id integer NOT NULL
description character varying(255) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

action_step_lookup_instance_id instance_id

Index - Schema public


Table: active_campaign_groups

active_campaign_groups Structure
F-Key Name Type Description
id serial PRIMARY KEY
campaign.campaign_id campaign_id integer NOT NULL
campaign_component.component_id component_id integer NOT NULL
groupname character varying(80) NOT NULL
groupcriteria text
instance_id bigint NOT NULL
active_campaign_groups_instance_id instance_id

Index - Schema public


Table: active_survey

active_survey Structure
F-Key Name Type Description
active_survey_id integer PRIMARY KEY DEFAULT nextval('active_survey_active_survey_seq'::regclass)
campaign.campaign_id campaign_id integer NOT NULL
name character varying(80) NOT NULL
description character varying(255)
intro text
outro text
itemlength integer DEFAULT (-1)
lookup_survey_types.code type integer NOT NULL
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
campaign_component.component_id component_id integer NOT NULL
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

active_survey_instance_id instance_id

Index - Schema public


Table: active_survey_answer_avg

active_survey_answer_avg Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('active_survey_answer_avg_id_seq'::regclass)
active_survey_questions.question_id question_id integer NOT NULL
active_survey_items.item_id item_id integer NOT NULL
total integer NOT NULL
instance_id bigint NOT NULL
active_survey_answer_avg_instance_id instance_id

Index - Schema public


Table: active_survey_answer_items

active_survey_answer_items Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('active_survey_answer_ite_id_seq'::regclass)
active_survey_items.item_id item_id integer NOT NULL
active_survey_answers.answer_id answer_id integer NOT NULL
comments text
instance_id bigint NOT NULL
active_survey_answer_items_instance_id instance_id

Index - Schema public


Table: active_survey_answers

active_survey_answers Structure
F-Key Name Type Description
answer_id integer PRIMARY KEY DEFAULT nextval('active_survey_ans_answer_id_seq'::regclass)
active_survey_responses.response_id response_id integer NOT NULL
active_survey_questions.question_id question_id integer NOT NULL
comments text
quant_ans integer DEFAULT (-1)
text_ans text
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

active_survey_answers_instance_id instance_id

Index - Schema public


Table: active_survey_items

active_survey_items Structure
F-Key Name Type Description
item_id integer PRIMARY KEY DEFAULT nextval('active_survey_items_item_id_seq'::regclass)
active_survey_questions.question_id question_id integer NOT NULL
type integer DEFAULT (-1)
description character varying(255)
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

active_survey_items_instance_id instance_id

Index - Schema public


Table: active_survey_questions

active_survey_questions Structure
F-Key Name Type Description
question_id integer PRIMARY KEY DEFAULT nextval('active_survey_q_question_id_seq'::regclass)
active_survey.active_survey_id active_survey_id integer
lookup_survey_types.code type integer NOT NULL
description character varying(255)
required boolean NOT NULL DEFAULT false
position integer NOT NULL
average double precision DEFAULT 0.00
total1 integer
total2 integer
total3 integer
total4 integer
total5 integer
total6 integer
total7 integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

active_survey_questions_instance_id instance_id

Index - Schema public


Table: active_survey_responses

active_survey_responses Structure
F-Key Name Type Description
response_id integer PRIMARY KEY DEFAULT nextval('active_survey_r_response_id_seq'::regclass)
active_survey.active_survey_id active_survey_id integer NOT NULL
contact_id integer NOT NULL DEFAULT (-1)
unique_code character varying(255)
ip_address character varying(30) NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
address_updated integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

active_survey_responses_instance_id instance_id

Index - Schema public


Table: asset

asset Structure
F-Key Name Type Description
asset_id serial PRIMARY KEY
organization.org_id account_id integer
service_contract.contract_id contract_id integer
date_listed timestamp(3) without time zone
asset_tag character varying(30)
status integer
location character varying(256)
asset_category.id level1 integer
asset_category.id level2 integer
asset_category.id level3 integer
serial_number character varying(30)
model_version character varying(30)
description text
expiration_date timestamp(3) without time zone
inclusions text
exclusions text
purchase_date timestamp(3) without time zone
po_number character varying(30)
purchased_from character varying(30)
contact.contact_id contact_id integer
notes text
lookup_response_model.code response_time integer
lookup_phone_model.code telephone_service_model integer
lookup_onsite_model.code onsite_service_model integer
lookup_email_model.code email_service_model integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
enabled boolean DEFAULT true
purchase_cost double precision
date_listed_timezone character varying(255)
expiration_date_timezone character varying(255)
purchase_date_timezone character varying(255)
trashed_date timestamp(3) without time zone
asset.asset_id parent_id integer
lookup_asset_vendor.code vendor_code integer
lookup_asset_manufacturer.code manufacturer_code integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

asset_instance_id instance_id

Index - Schema public


Table: asset_category

asset_category Structure
F-Key Name Type Description
id serial PRIMARY KEY
cat_level integer NOT NULL
parent_cat_code integer NOT NULL
description character varying(300) NOT NULL
full_description text NOT NULL DEFAULT ''::text
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
lookup_site_id.code site_id integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

asset_category_instance_id instance_id

Index - Schema public


Table: asset_category_draft

asset_category_draft Structure
F-Key Name Type Description
id serial PRIMARY KEY
link_id integer DEFAULT (-1)
cat_level integer NOT NULL
parent_cat_code integer NOT NULL
description character varying(300) NOT NULL
full_description text NOT NULL DEFAULT ''::text
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
lookup_site_id.code site_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
asset_category_draft_instance_id instance_id

Index - Schema public


Table: asset_materials_map

asset_materials_map Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
asset.asset_id asset_id integer NOT NULL
lookup_asset_materials.code code integer NOT NULL
quantity double precision
entered timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
asset_materials_map_instance_id instance_id

Index - Schema public


Table: business_process

business_process Structure
F-Key Name Type Description
process_id serial PRIMARY KEY
process_name character varying(255) NOT NULL
description character varying(510)
type_id integer NOT NULL
permission_category.category_id link_module_id integer NOT NULL
component_start_id integer
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

business_process_instance_id instance_id

Index - Schema public


Table: business_process_component

business_process_component Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('business_process_compone_id_seq'::regclass)
business_process.process_id process_id integer NOT NULL
business_process_component_library.component_id component_id integer NOT NULL
business_process_component.id parent_id integer
parent_result_id integer
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

business_process_component_instance_id instance_id

Index - Schema public


Table: business_process_component_library

business_process_component_library Structure
F-Key Name Type Description
component_id integer PRIMARY KEY DEFAULT nextval('business_process_com_lb_id_seq'::regclass)
component_name character varying(255) NOT NULL
type_id integer NOT NULL
class_name character varying(255) NOT NULL
description character varying(510)
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

business_process_component_library_instance_id instance_id

Index - Schema public


Table: business_process_component_parameter

business_process_component_parameter Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('business_process_comp_pa_id_seq'::regclass)
business_process_component.id component_id integer NOT NULL
business_process_parameter_library.parameter_id parameter_id integer NOT NULL
param_value text
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL
business_process_component_parameter_instance_id instance_id

Index - Schema public


Table: business_process_component_result_lookup

business_process_component_result_lookup Structure
F-Key Name Type Description
result_id integer PRIMARY KEY DEFAULT nextval('business_process_comp_re_id_seq'::regclass)
business_process_component_library.component_id component_id integer NOT NULL
return_id integer NOT NULL
description character varying(255)
level integer NOT NULL
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL
business_process_component_result_lookup_instance_id instance_id

Index - Schema public


Table: business_process_events

business_process_events Structure
F-Key Name Type Description
event_id integer PRIMARY KEY DEFAULT nextval('business_process_e_event_id_seq'::regclass)
second character varying(64) DEFAULT '0'::character varying
minute character varying(64) DEFAULT '*'::character varying
hour character varying(64) DEFAULT '*'::character varying
dayofmonth character varying(64) DEFAULT '*'::character varying
month character varying(64) DEFAULT '*'::character varying
dayofweek character varying(64) DEFAULT '*'::character varying
year character varying(64) DEFAULT '*'::character varying
task character varying(255)
extrainfo character varying(255)
businessdays character varying(6) DEFAULT 'true'::character varying
enabled boolean DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()
business_process.process_id process_id integer NOT NULL
instance_id bigint NOT NULL
business_process_events_instance_id instance_id

Index - Schema public


Table: business_process_hook

business_process_hook Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('business_process_ho_hook_id_seq'::regclass)
business_process_hook_triggers.trigger_id trigger_id integer NOT NULL
business_process.process_id process_id integer NOT NULL
enabled boolean DEFAULT false
priority integer NOT NULL
instance_id bigint NOT NULL
business_process_hook_instance_id instance_id

Index - Schema public


Table: business_process_hook_library

business_process_hook_library Structure
F-Key Name Type Description
hook_id integer PRIMARY KEY DEFAULT nextval('business_process_hl_hook_id_seq'::regclass)
permission_category.category_id link_module_id integer NOT NULL
hook_class character varying(255) NOT NULL
enabled boolean DEFAULT false
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

business_process_hook_library_instance_id instance_id

Index - Schema public


Table: business_process_hook_triggers

business_process_hook_triggers Structure
F-Key Name Type Description
trigger_id integer PRIMARY KEY DEFAULT nextval('business_process_ho_trig_id_seq'::regclass)
action_type_id integer NOT NULL
business_process_hook_library.hook_id hook_id integer NOT NULL
enabled boolean DEFAULT false
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

business_process_hook_triggers_instance_id instance_id

Index - Schema public


Table: business_process_log

business_process_log Structure
F-Key Name Type Description
process_name character varying(255) NOT NULL
anchor timestamp(3) without time zone NOT NULL
instance_id bigint NOT NULL
business_process_log_instance_id instance_id

Index - Schema public


Table: business_process_parameter

business_process_parameter Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('business_process_param_id_seq'::regclass)
business_process.process_id process_id integer NOT NULL
param_name character varying(255)
param_value text
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL
business_process_parameter_instance_id instance_id

Index - Schema public


Table: business_process_parameter_library

business_process_parameter_library Structure
F-Key Name Type Description
parameter_id integer PRIMARY KEY DEFAULT nextval('business_process_pa_lib_id_seq'::regclass)
component_id integer
param_name character varying(255)
description character varying(510)
default_value text
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

business_process_parameter_library_instance_id instance_id

Index - Schema public


Table: call_log

call_log Structure
F-Key Name Type Description
call_id serial PRIMARY KEY
organization.org_id org_id integer
contact.contact_id contact_id integer
opportunity_header.opp_id opp_id integer
lookup_call_types.code call_type_id integer
length integer
subject character varying(255)
notes text
alertdate timestamp(3) without time zone
followup_notes text
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
alert character varying(255) DEFAULT NULL::character varying
lookup_call_types.code alert_call_type_id integer
call_log.call_id parent_id integer
access.user_id owner integer
access.user_id assignedby integer
assign_date timestamp(3) without time zone DEFAULT now()
access.user_id completedby integer
complete_date timestamp(3) without time zone
lookup_call_result.result_id result_id integer
lookup_call_priority.code priority_id integer
status_id integer NOT NULL DEFAULT 1
reminder_value integer
lookup_call_reminder.code reminder_type_id integer
alertdate_timezone character varying(255)
trashed_date timestamp(3) without time zone
contact.contact_id followup_contact_id integer
followup_end_date timestamp(3) without time zone
followup_end_date_timezone character varying(255)
followup_location character varying(255)
followup_length integer
lookup_call_reminder.code followup_length_duration integer
call_start_date timestamp(3) without time zone
call_start_date_timezone character varying(255)
call_end_date timestamp(3) without time zone
call_end_date_timezone character varying(255)
call_location character varying(255)
lookup_call_reminder.code call_length_duration integer
email_participants boolean DEFAULT false
email_followup_participants boolean DEFAULT false
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

call_contact_id_idx contact_id call_fcontact_id_idx followup_contact_id call_log_cidx alertdate, enteredby call_log_entered_idx entered call_log_instance_id instance_id call_opp_id_idx opp_id call_org_id_idx org_id

Index - Schema public


Table: call_log_participant

call_log_participant Structure
F-Key Name Type Description
participant_id integer PRIMARY KEY DEFAULT nextval('call_log_participant_participant_id_seq'::regclass)
call_log.call_id call_id integer NOT NULL
contact.contact_id contact_id integer NOT NULL
is_available integer DEFAULT 1
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
access.user_id modifiedby integer NOT NULL
is_followup integer
instance_id bigint NOT NULL
call_log_participant_instance_id instance_id

Index - Schema public


Table: campaign

campaign Structure
F-Key Name Type Description
campaign_id serial PRIMARY KEY
name character varying(80) NOT NULL
description character varying(255)
list_id integer
enabled boolean NOT NULL DEFAULT true
type integer DEFAULT 1
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
trashed_date timestamp(3) without time zone
actual_cost double precision
budget double precision
instance_id bigint NOT NULL
auto_responder boolean DEFAULT false

Tables referencing this one via Foreign Key Constraints:

campaign_instance_id instance_id

Index - Schema public


Table: campaign_component

campaign_component Structure
F-Key Name Type Description
component_id serial PRIMARY KEY
campaign_component_types.code component_type integer NOT NULL
campaign.campaign_id campaign_id integer NOT NULL
link_object_id integer NOT NULL
name character varying(80) NOT NULL
note text
status_id integer
status character varying(255)
active boolean DEFAULT false
active_date timestamp(3) without time zone
active_date_timezone character varying(255)
approval_date timestamp(3) without time zone
access.user_id approvedby integer
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
trashed_date timestamp(3) without time zone
budget double precision NOT NULL
allow_reuse boolean DEFAULT false
campaign_component.component_id copied_from integer
campaign_component.component_id linked_to integer
level integer
instance_id bigint NOT NULL
new_records boolean NOT NULL DEFAULT false

Tables referencing this one via Foreign Key Constraints:

campaign_component_instance_id instance_id

Index - Schema public


Table: campaign_component_types

campaign_component_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('campaign_component_typ_code_seq'::regclass)
description character varying(50) NOT NULL
constant integer NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
icelet_configurator_class character varying(300) NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

campaign_component_types_instance_id instance_id

Index - Schema public


Table: campaign_cpt_connect_invite

campaign_cpt_connect_invite Structure
F-Key Name Type Description
connect_invite_id serial PRIMARY KEY
name character varying(80) NOT NULL
description character varying(255)
subject character varying(255)
message text
custom_text text
status_id integer
status character varying(255)
active boolean DEFAULT false
active_date timestamp(3) without time zone
active_date_timezone character varying(255)
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL
campaign_cpt_connect_invite_instance_id instance_id

Index - Schema public


Table: campaign_cpt_connect_marketing

campaign_cpt_connect_marketing Structure
F-Key Name Type Description
connect_marketing_id serial PRIMARY KEY
name character varying(80) NOT NULL
description character varying(255)
criteria text
message_id integer DEFAULT (-1)
subject character varying(255)
message text
status_id integer
status character varying(255)
active boolean DEFAULT false
active_date timestamp(3) without time zone
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
active_date_timezone character varying(255)
instance_id bigint NOT NULL
campaign_cpt_connect_marketing_instance_id instance_id

Index - Schema public


Table: campaign_cpt_electronic_mail

campaign_cpt_electronic_mail Structure
F-Key Name Type Description
electronic_mail_id serial PRIMARY KEY
name character varying(80) NOT NULL
description character varying(255)
list_id integer
message_id integer DEFAULT (-1)
reply_addr character varying(255)
subject character varying(255)
message text
status_id integer
status character varying(255)
active boolean DEFAULT false
active_date timestamp(3) without time zone
send_method_id integer NOT NULL DEFAULT (-1)
inactive_date timestamp(3) without time zone
approval_date timestamp(3) without time zone
access.user_id approvedby integer
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
active_date_timezone character varying(255)
cc character varying(1024)
bcc character varying(1024)
trashed_date timestamp(3) without time zone
instance_id bigint NOT NULL
archive_url character varying(255)
archive_id character varying(255)
campaign_cpt_electronic_mail_instance_id instance_id

Index - Schema public


Table: campaign_cpt_promo_mail

campaign_cpt_promo_mail Structure
F-Key Name Type Description
special_mail_id serial PRIMARY KEY
name character varying(80) NOT NULL
description character varying(255)
promo_item_id integer DEFAULT (-1)
status_id integer
status character varying(255)
active boolean DEFAULT false
active_date timestamp(3) without time zone
active_date_timezone character varying(255)
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL
campaign_cpt_promo_mail_instance_id instance_id

Index - Schema public


Table: campaign_cpt_web_url

campaign_cpt_web_url Structure
F-Key Name Type Description
web_url_id serial PRIMARY KEY
name character varying(80) NOT NULL
description character varying(255)
status_id integer
status character varying(255)
active boolean DEFAULT false
active_date timestamp(3) without time zone
active_date_timezone character varying(255)
enabled boolean NOT NULL DEFAULT true
web_url character varying(300)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL
campaign_cpt_web_url_instance_id instance_id

Index - Schema public


Table: campaign_group_map

campaign_group_map Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
campaign.campaign_id campaign_id integer NOT NULL
user_group.group_id user_group_id integer NOT NULL
instance_id bigint NOT NULL
campaign_group_map_instance_id instance_id

Index - Schema public


Table: campaign_list_groups

campaign_list_groups Structure
F-Key Name Type Description
campaign.campaign_id campaign_id integer NOT NULL
saved_criterialist.id group_id integer NOT NULL
campaign_component.component_id component_id integer NOT NULL
instance_id bigint NOT NULL
campaign_list_groups_instance_id instance_id

Index - Schema public


Table: campaign_run

campaign_run Structure
F-Key Name Type Description
id serial PRIMARY KEY
campaign.campaign_id campaign_id integer NOT NULL
campaign_component.component_id component_id integer NOT NULL
status integer NOT NULL
run_date timestamp(3) without time zone NOT NULL DEFAULT now()
total_contacts integer
total_sent integer
total_replied integer
total_bounced integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
campaign_run_instance_id instance_id

Index - Schema public


Table: campaign_survey_link

campaign_survey_link Structure
F-Key Name Type Description
campaign.campaign_id campaign_id integer
survey.survey_id survey_id integer
campaign_component.component_id component_id integer NOT NULL
instance_id bigint NOT NULL
campaign_survey_link_instance_id instance_id

Index - Schema public


Table: category_editor_lookup

category_editor_lookup Structure
F-Key Name Type Description
id serial PRIMARY KEY
permission_category.category_id module_id integer NOT NULL
constant_id integer NOT NULL
table_name character varying(60)
level integer
description text
entered timestamp(3) without time zone DEFAULT now()
category_id integer NOT NULL
max_levels integer NOT NULL
instance_id bigint NOT NULL
category_editor_lookup_instance_id instance_id

Index - Schema public


Table: cfsinbox_message

cfsinbox_message Structure
F-Key Name Type Description
id serial PRIMARY KEY
subject character varying(255) DEFAULT NULL::character varying
body text NOT NULL
reply_id integer
access.user_id enteredby integer
sent timestamp(3) without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
type integer NOT NULL DEFAULT (-1)
access.user_id modifiedby integer
delete_flag boolean DEFAULT false
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

cfsinbox_message_instance_id instance_id

Index - Schema public


Table: cfsinbox_messagelink

cfsinbox_messagelink Structure
F-Key Name Type Description
cfsinbox_message.id id integer NOT NULL
contact.contact_id sent_to integer
status integer NOT NULL
viewed timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
enabled boolean NOT NULL DEFAULT true
access.user_id sent_from integer
sent_to_mail_id character varying(255)
sent_from_mail_id character varying(255)
email_account.email_id email_account_id integer
replied_to_message_id integer
item_id integer
last_action integer
replyto character varying(255)
instance_id bigint NOT NULL
cfsinbox_messagelink_instance_id instance_id

Index - Schema public


Table: connect_instances

connect_instances Structure
F-Key Name Type Description
connect_instance_id serial PRIMARY KEY
domain_name character varying(255)
context character varying(255)
title character varying(255)
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

connect_instances_instance_id instance_id

Index - Schema public


Table: contact

contact Structure
F-Key Name Type Description
contact_id serial PRIMARY KEY
access.user_id user_id integer
organization.org_id org_id integer
company character varying(255)
title character varying(80)
lookup_department.code department integer
contact.contact_id super integer
namesalutation character varying(80)
namelast character varying(80) NOT NULL
namefirst character varying(80) NOT NULL
namemiddle character varying(80)
namesuffix character varying(80)
contact.contact_id assistant integer
birthdate date
notes text
site integer
locale integer
employee_id character varying(80)
employmenttype integer
startofday character varying(10)
endofday character varying(10)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
enabled boolean DEFAULT true
access.user_id owner integer
custom1 integer DEFAULT (-1)
url character varying(100)
primary_contact boolean DEFAULT false
employee boolean NOT NULL DEFAULT false
org_name character varying(255)
lookup_access_types.code access_type integer
status_id integer
import_id integer
information_update_date timestamp(3) without time zone DEFAULT now()
lead boolean DEFAULT false
lead_status integer
lookup_contact_source.code source integer
lookup_contact_rating.code rating integer
comments character varying(255)
conversion_date timestamp(3) without time zone
additional_names character varying(255)
nickname character varying(80)
role character varying(255)
trashed_date timestamp(3) without time zone
secret_word character varying(255)
account_number character varying(50)
revenue double precision
lookup_industry.code industry_temp_code integer
potential double precision
no_email boolean DEFAULT false
no_mail boolean DEFAULT false
no_phone boolean DEFAULT false
no_textmessage boolean DEFAULT false
no_im boolean DEFAULT false
no_fax boolean DEFAULT false
lookup_site_id.code site_id integer
assigned_date timestamp(3) without time zone
lead_trashed_date timestamp(3) without time zone
employees integer
duns_type character varying(300)
duns_number character varying(30)
business_name_two character varying(300)
lookup_sic_codes.code sic_code integer
sic_text character varying(8)
year_started integer
sic_description character varying(300)
lookup_contact_stage.code stage integer
instance_id bigint NOT NULL
connect_unique_id character varying(300)
connect_instances.connect_instance_id connect_instance_id integer

Tables referencing this one via Foreign Key Constraints:

contact_access_type access_type contact_assistant assistant contact_connect_unique_id_idx connect_unique_id contact_department department contact_employee_id employee_id contact_entered entered contact_enteredby enteredby contact_import_id_idx import_id contact_industry_temp_code industry_temp_code contact_instance_id instance_id contact_islead_idx lead) WHERE (lead = true contact_modifiedby modifiedby contact_org_id org_id contact_org_id_idx org_id) WHERE ((org_id IS NOT NULL) AND (org_id > 0) contact_owner owner contact_rating rating contact_site_id site_id contact_source source contact_stage_idx stage contact_super super contact_user_id user_id contact_user_id_idx user_id contactlist_company company, namelast, namefirst contactlist_namecompany namelast, namefirst, company

Index - Schema public


Table: contact_account_source

contact_account_source Structure
F-Key Name Type Description
source_id serial PRIMARY KEY
import.import_id import_id integer NOT NULL
lookup_contact_source.code link_source_code integer
link_item_id integer NOT NULL
link_module_id integer NOT NULL
vendor_code integer NOT NULL
expiration_date timestamp(3) without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
contact_account_source_instance_id instance_id

Index - Schema public


Table: contact_address

contact_address Structure
F-Key Name Type Description
address_id serial PRIMARY KEY
contact.contact_id contact_id integer
lookup_contactaddress_types.code address_type integer
addrline1 character varying(80)
addrline2 character varying(80)
addrline3 character varying(80)
city character varying(80)
state character varying(80)
country character varying(80)
postalcode character varying(12)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
primary_address boolean NOT NULL DEFAULT false
addrline4 character varying(80)
county character varying(80)
latitude double precision
longitude double precision
instance_id bigint NOT NULL
contact_address_contact_id_idx contact_id contact_address_instance_id instance_id contact_address_postalcode_idx postalcode contact_address_prim_idx primary_address contact_city_idx city

Index - Schema public


Table: contact_data

contact_data Structure
F-Key Name Type Description
record_id serial PRIMARY KEY
contact.contact_id contact_id integer NOT NULL
contact_types text
contact_email_address text
contact_phone text
contact_postal_code text
contact_city text
contact_state text
contact_country text
contact_projects text
has_projects boolean DEFAULT false
instance_id bigint NOT NULL
custom_search_data text

Index - Schema public


Table: contact_emailaddress

contact_emailaddress Structure
F-Key Name Type Description
emailaddress_id integer PRIMARY KEY DEFAULT nextval('contact_email_emailaddress__seq'::regclass)
contact.contact_id contact_id integer
lookup_contactemail_types.code emailaddress_type integer
email character varying(256)
bounced timestamp(3) without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
primary_email boolean NOT NULL DEFAULT false
instance_id bigint NOT NULL
contact_email_contact_id_idx contact_id contact_email_prim_idx primary_email contact_emailaddress_instance_id instance_id

Index - Schema public


Table: contact_imaddress

contact_imaddress Structure
F-Key Name Type Description
address_id serial PRIMARY KEY
contact.contact_id contact_id integer
lookup_im_types.code imaddress_type integer
lookup_im_services.code imaddress_service integer
imaddress character varying(256)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
primary_im boolean NOT NULL DEFAULT false
instance_id bigint NOT NULL
contact_imaddress_instance_id instance_id

Index - Schema public


Table: contact_lead_read_map

contact_lead_read_map Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
access.user_id user_id integer NOT NULL
contact.contact_id contact_id integer NOT NULL
instance_id bigint NOT NULL
contact_lead_read_c_idx contact_id contact_lead_read_map_instance_id instance_id contact_lead_read_u_idx user_id

Index - Schema public


Table: contact_lead_skipped_map

contact_lead_skipped_map Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
access.user_id user_id integer NOT NULL
contact.contact_id contact_id integer NOT NULL
instance_id bigint NOT NULL
contact_lead_skip_u_idx user_id contact_lead_skipped_map_instance_id instance_id

Index - Schema public


Table: contact_message

contact_message Structure
F-Key Name Type Description
id serial PRIMARY KEY
message.id message_id integer NOT NULL
received_date timestamp(3) without time zone NOT NULL
contact.contact_id received_from integer NOT NULL
access.user_id received_by integer NOT NULL
instance_id bigint NOT NULL
contact_message_instance_id instance_id

Index - Schema public


Table: contact_phone

contact_phone Structure
F-Key Name Type Description
phone_id serial PRIMARY KEY
contact.contact_id contact_id integer
lookup_contactphone_types.code phone_type integer
number character varying(30)
extension character varying(10)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
primary_number boolean NOT NULL DEFAULT false
instance_id bigint NOT NULL
contact_phone_contact_id_idx contact_id contact_phone_instance_id instance_id

Index - Schema public


Table: contact_socialnetwork_name

contact_socialnetwork_name Structure
F-Key Name Type Description
socialnetwork_id serial PRIMARY KEY
contact.contact_id contact_id integer
socialnetwork_name character varying(512)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
primary_socialnetwork_name boolean NOT NULL DEFAULT false
lookup_socialnetwork_types.code socialnetwork_name_type integer
instance_id bigint NOT NULL
contact_socialnetwork_name_instance_id instance_id

Index - Schema public


Table: contact_textmessageaddress

contact_textmessageaddress Structure
F-Key Name Type Description
address_id serial PRIMARY KEY
contact.contact_id contact_id integer
textmessageaddress character varying(256)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
primary_textmessage_address boolean NOT NULL DEFAULT false
lookup_textmessage_types.code textmessageaddress_type integer
instance_id bigint NOT NULL
contact_textmessageaddress_instance_id instance_id

Index - Schema public


Table: contact_type_levels

contact_type_levels Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('contact_type_levels_id_seq'::regclass)
contact.contact_id contact_id integer NOT NULL
lookup_contact_types.code type_id integer NOT NULL
level integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
contact_type_levels_instance_id instance_id tcontactlevels_level level

Index - Schema public


Table: credit_card

credit_card Structure
F-Key Name Type Description
creditcard_id serial PRIMARY KEY
lookup_creditcard_types.code card_type integer
card_number character varying(300)
card_security_code character varying(300)
expiration_month integer
expiration_year integer
name_on_card character varying(300)
company_name_on_card character varying(300)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL
credit_card_instance_id instance_id

Index - Schema public


Table: custom_field_category

custom_field_category Structure
F-Key Name Type Description
module_id integer NOT NULL
category_id integer PRIMARY KEY DEFAULT nextval('custom_field_ca_category_id_seq'::regclass)
category_name character varying(255) NOT NULL
level integer
description text
start_date timestamp(3) without time zone DEFAULT now()
end_date timestamp(3) without time zone
default_item boolean DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean DEFAULT true
multiple_records boolean DEFAULT false
read_only boolean DEFAULT false
modified timestamp(3) without time zone DEFAULT now()
instance_id bigint NOT NULL
inline boolean DEFAULT false

Tables referencing this one via Foreign Key Constraints:

custom_field_cat_idx module_id custom_field_category_instance_id instance_id

Index - Schema public


Table: custom_field_data

custom_field_data Structure
F-Key Name Type Description
custom_field_record.record_id record_id integer NOT NULL
custom_field_info.field_id field_id integer NOT NULL
selected_item_id integer
entered_value text
entered_number integer
entered_float double precision
entered timestamp(3) without time zone DEFAULT now()
modified timestamp(3) without time zone DEFAULT now()
data_id integer PRIMARY KEY DEFAULT nextval('custom_field_data_data_id_seq'::regclass)
instance_id bigint NOT NULL
custom_field_dat_idx record_id, field_id custom_field_data_instance_id instance_id

Index - Schema public


Table: custom_field_group

custom_field_group Structure
F-Key Name Type Description
custom_field_category.category_id category_id integer NOT NULL
group_id integer PRIMARY KEY DEFAULT nextval('custom_field_group_group_id_seq'::regclass)
group_name character varying(255) NOT NULL
level integer
description text
start_date timestamp(3) without time zone DEFAULT now()
end_date timestamp(3) without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean DEFAULT true
modified timestamp(3) without time zone DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

custom_field_group_instance_id instance_id custom_field_grp_idx category_id

Index - Schema public


Table: custom_field_info

custom_field_info Structure
F-Key Name Type Description
custom_field_group.group_id group_id integer NOT NULL
field_id serial PRIMARY KEY
field_name character varying(255) NOT NULL
level integer
field_type integer NOT NULL
validation_type integer
required boolean DEFAULT false
parameters text
start_date timestamp(3) without time zone DEFAULT now()
end_date timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
entered timestamp(3) without time zone DEFAULT now()
enabled boolean DEFAULT true
additional_text character varying(255)
modified timestamp(3) without time zone DEFAULT now()
default_value text
instance_id bigint NOT NULL
searchable boolean DEFAULT false

Tables referencing this one via Foreign Key Constraints:

custom_field_inf_idx group_id custom_field_info_instance_id instance_id

Index - Schema public


Table: custom_field_lookup

custom_field_lookup Structure
F-Key Name Type Description
custom_field_info.field_id field_id integer NOT NULL
code serial PRIMARY KEY
description character varying(255) NOT NULL
default_item boolean DEFAULT false
level integer
start_date timestamp(3) without time zone DEFAULT now()
end_date timestamp without time zone
entered timestamp(3) without time zone DEFAULT now()
enabled boolean DEFAULT true
modified timestamp(3) without time zone DEFAULT now()
instance_id bigint NOT NULL
custom_field_lookup_instance_id instance_id

Index - Schema public


Table: custom_field_record

custom_field_record Structure
F-Key Name Type Description
link_module_id integer NOT NULL
link_item_id integer NOT NULL
custom_field_category.category_id category_id integer NOT NULL
record_id integer PRIMARY KEY DEFAULT nextval('custom_field_reco_record_id_seq'::regclass)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
enabled boolean DEFAULT true
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

custom_field_rec_idx link_module_id, link_item_id, category_id custom_field_record_instance_id instance_id

Index - Schema public


Table: custom_list_view

custom_list_view Structure
F-Key Name Type Description
view_id serial PRIMARY KEY
custom_list_view_editor.editor_id editor_id integer NOT NULL
name character varying(80) NOT NULL
description text
is_default boolean DEFAULT false
entered timestamp(3) without time zone DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

custom_list_view_instance_id instance_id

Index - Schema public


Table: custom_list_view_editor

custom_list_view_editor Structure
F-Key Name Type Description
editor_id serial PRIMARY KEY
permission_category.category_id module_id integer NOT NULL
constant_id integer NOT NULL
description text
level integer
category_id integer NOT NULL
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

custom_list_view_editor_instance_id instance_id

Index - Schema public


Table: custom_list_view_field

custom_list_view_field Structure
F-Key Name Type Description
field_id serial PRIMARY KEY
custom_list_view.view_id view_id integer NOT NULL
name character varying(80) NOT NULL
instance_id bigint NOT NULL
custom_list_view_field_instance_id instance_id

Index - Schema public


Table: customer_product

customer_product Structure
F-Key Name Type Description
customer_product_id serial PRIMARY KEY
organization.org_id org_id integer NOT NULL
order_entry.order_id order_id integer
order_product.item_id order_item_id integer
description character varying(2048)
lookup_order_status.code status_id integer
status_date timestamp(3) without time zone DEFAULT now()
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
enabled boolean DEFAULT true
contact_id integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

customer_product_instance_id instance_id

Index - Schema public


Table: customer_product_history

customer_product_history Structure
F-Key Name Type Description
history_id serial PRIMARY KEY
customer_product.customer_product_id customer_product_id integer NOT NULL
organization.org_id org_id integer NOT NULL
order_entry.order_id order_id integer NOT NULL
product_start_date timestamp(3) without time zone
product_end_date timestamp(3) without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
order_product.item_id order_item_id integer NOT NULL
contact_id integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

customer_product_history_instance_id instance_id

Index - Schema public


Table: database_version

database_version Structure
F-Key Name Type Description
version_id serial PRIMARY KEY
script_filename character varying(255) NOT NULL
script_version character varying(255) NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()

Index - Schema public


Table: document_accounts

document_accounts Structure
F-Key Name Type Description
id serial PRIMARY KEY
document_store.document_store_id document_store_id integer NOT NULL
organization.org_id org_id integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
instance_id bigint NOT NULL
document_accounts_instance_id instance_id

Index - Schema public


Table: document_store

document_store Structure
F-Key Name Type Description
document_store_id serial PRIMARY KEY
template_id integer
title character varying(100) NOT NULL
shortdescription character varying(200) NOT NULL
requestedby character varying(50)
requesteddept character varying(50)
requestdate timestamp(3) without time zone DEFAULT now()
requestdate_timezone character varying(255)
approvaldate timestamp(3) without time zone
access.user_id approvalby integer
closedate timestamp(3) without time zone
entered timestamp(3) without time zone DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone DEFAULT now()
access.user_id modifiedby integer NOT NULL
trashed_date timestamp(3) without time zone
public_store boolean NOT NULL DEFAULT false
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

document_store_instance_id instance_id

Index - Schema public


Table: document_store_department_member

document_store_department_member Structure
F-Key Name Type Description
document_store.document_store_id document_store_id integer NOT NULL
lookup_department.code item_id integer NOT NULL
lookup_document_store_role.code userlevel integer NOT NULL
status integer
last_accessed timestamp(3) without time zone
entered timestamp(3) without time zone DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone DEFAULT now()
access.user_id modifiedby integer NOT NULL
lookup_site_id.code site_id integer
role_type integer
instance_id bigint NOT NULL
document_store_department_member_instance_id instance_id

Index - Schema public


Table: document_store_permissions

document_store_permissions Structure
F-Key Name Type Description
id serial PRIMARY KEY
document_store.document_store_id document_store_id integer NOT NULL
lookup_document_store_permission.code permission_id integer NOT NULL
lookup_document_store_role.code userlevel integer NOT NULL
instance_id bigint NOT NULL
document_store_permissions_instance_id instance_id

Index - Schema public


Table: document_store_role_member

document_store_role_member Structure
F-Key Name Type Description
document_store.document_store_id document_store_id integer NOT NULL
role.role_id item_id integer NOT NULL
lookup_document_store_role.code userlevel integer NOT NULL
status integer
last_accessed timestamp(3) without time zone
entered timestamp(3) without time zone DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone DEFAULT now()
access.user_id modifiedby integer NOT NULL
lookup_site_id.code site_id integer
role_type integer
instance_id bigint NOT NULL
document_store_role_member_instance_id instance_id

Index - Schema public


Table: document_store_user_member

document_store_user_member Structure
F-Key Name Type Description
document_store.document_store_id document_store_id integer NOT NULL
access.user_id item_id integer NOT NULL
lookup_document_store_role.code userlevel integer NOT NULL
status integer
last_accessed timestamp(3) without time zone
entered timestamp(3) without time zone DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone DEFAULT now()
access.user_id modifiedby integer NOT NULL
lookup_site_id.code site_id integer
role_type integer
instance_id bigint NOT NULL
document_store_user_member_instance_id instance_id

Index - Schema public


Table: email_account

email_account Structure
F-Key Name Type Description
email_id serial PRIMARY KEY
lookup_emailserver_types.code server_type integer NOT NULL
alias character varying(255) NOT NULL
description text
email_address character varying(255) NOT NULL
account_password character varying(255) NOT NULL
server_address character varying(255) NOT NULL
lookup_emailaccount_inbox_behavior.code inbox_behavior integer NOT NULL
imap_path_prefix character varying(255)
port integer NOT NULL
ssl boolean DEFAULT false
include_domain boolean DEFAULT false
schedule integer NOT NULL
module_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
enabled boolean DEFAULT false
auto_associate boolean DEFAULT false
next_schedule timestamp(3) without time zone NOT NULL DEFAULT now()
server_type_name character varying(32)
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

email_account_instance_id instance_id

Index - Schema public


Table: email_account_user_preferences

email_account_user_preferences Structure
F-Key Name Type Description
id serial PRIMARY KEY
access.user_id user_id integer
email_account.email_id email_account_id integer NOT NULL
instance_id bigint NOT NULL
email_account_user_preferences_instance_id instance_id

Index - Schema public


Table: events

events Structure
F-Key Name Type Description
event_id serial PRIMARY KEY
second character varying(64) DEFAULT '0'::character varying
minute character varying(64) DEFAULT '*'::character varying
hour character varying(64) DEFAULT '*'::character varying
dayofmonth character varying(64) DEFAULT '*'::character varying
month character varying(64) DEFAULT '*'::character varying
dayofweek character varying(64) DEFAULT '*'::character varying
year character varying(64) DEFAULT '*'::character varying
task character varying(255)
extrainfo character varying(255)
businessdays character varying(6) DEFAULT 'true'::character varying
enabled boolean DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: events_log

events_log Structure
F-Key Name Type Description
log_id serial PRIMARY KEY
events.event_id event_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
status integer
message text

Index - Schema public


Table: excluded_recipient

excluded_recipient Structure
F-Key Name Type Description
id serial PRIMARY KEY
campaign.campaign_id campaign_id integer NOT NULL
contact.contact_id contact_id integer NOT NULL
campaign_component.component_id component_id integer NOT NULL
instance_id bigint NOT NULL
excluded_recipient_instance_id instance_id

Index - Schema public


Table: field_types

field_types Structure
F-Key Name Type Description
id serial PRIMARY KEY
data_typeid integer NOT NULL DEFAULT (-1)
data_type character varying(20)
operator character varying(50)
display_text character varying(50)
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

field_types_instance_id instance_id

Index - Schema public


Table: help_business_rules

help_business_rules Structure
F-Key Name Type Description
rule_id serial PRIMARY KEY
help_contents.help_id link_help_id integer NOT NULL
description character varying(1000) NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
completedate timestamp(3) without time zone
access.user_id completedby integer
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL
help_business_rules_instance_id instance_id

Index - Schema public


Table: help_contents

help_contents Structure
F-Key Name Type Description
help_id serial PRIMARY KEY
permission_category.category_id category_id integer
help_module.module_id link_module_id integer
module character varying(255)
section character varying(255)
subsection character varying(255)
title character varying(255)
description text
help_contents.help_id nextcontent integer
help_contents.help_id prevcontent integer
help_contents.help_id upcontent integer
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean DEFAULT true
content_url text
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

help_contents_instance_id instance_id

Index - Schema public


Table: help_faqs

help_faqs Structure
F-Key Name Type Description
faq_id serial PRIMARY KEY
help_module.module_id owning_module_id integer NOT NULL
question character varying(1000) NOT NULL
answer character varying(1000) NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
completedate timestamp(3) without time zone
access.user_id completedby integer
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL
help_faqs_instance_id instance_id

Index - Schema public


Table: help_features

help_features Structure
F-Key Name Type Description
feature_id serial PRIMARY KEY
help_contents.help_id link_help_id integer NOT NULL
lookup_help_features.code link_feature_id integer
description character varying(1000) NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
completedate timestamp(3) without time zone
access.user_id completedby integer
enabled boolean NOT NULL DEFAULT true
level integer
instance_id bigint NOT NULL
help_features_instance_id instance_id

Index - Schema public


Table: help_introduction_preference

help_introduction_preference Structure
F-Key Name Type Description
access.user_id user_id integer NOT NULL
help_module.module_id module_id integer NOT NULL
instance_id bigint NOT NULL
help_introduction_preference_instance_id instance_id

Index - Schema public


Table: help_module

help_module Structure
F-Key Name Type Description
module_id serial PRIMARY KEY
permission_category.category_id category_id integer
module_brief_description text
module_detail_description text
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

help_module_instance_id instance_id

Index - Schema public


Table: help_notes

help_notes Structure
F-Key Name Type Description
note_id serial PRIMARY KEY
help_contents.help_id link_help_id integer NOT NULL
description character varying(1000) NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
completedate timestamp(3) without time zone
access.user_id completedby integer
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL
help_notes_instance_id instance_id

Index - Schema public


Table: help_related_links

help_related_links Structure
F-Key Name Type Description
relatedlink_id serial PRIMARY KEY
help_module.module_id owning_module_id integer
help_contents.help_id linkto_content_id integer
displaytext character varying(255) NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL
help_related_links_instance_id instance_id

Index - Schema public


Table: help_tableof_contents

help_tableof_contents Structure
F-Key Name Type Description
content_id serial PRIMARY KEY
displaytext character varying(255)
help_tableof_contents.content_id firstchild integer
help_tableof_contents.content_id nextsibling integer
help_tableof_contents.content_id parent integer
permission_category.category_id category_id integer
contentlevel integer NOT NULL
contentorder integer NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean DEFAULT true
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

help_tableof_contents_instance_id instance_id

Index - Schema public


Table: help_tableofcontentitem_links

help_tableofcontentitem_links Structure
F-Key Name Type Description
link_id serial PRIMARY KEY
help_tableof_contents.content_id global_link_id integer NOT NULL
help_contents.help_id linkto_content_id integer NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean DEFAULT true
instance_id bigint NOT NULL
help_tableofcontentitem_links_instance_id instance_id

Index - Schema public


Table: help_tips

help_tips Structure
F-Key Name Type Description
tip_id serial PRIMARY KEY
help_contents.help_id link_help_id integer NOT NULL
description character varying(1000) NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean NOT NULL DEFAULT true
instance_id bigint NOT NULL
help_tips_instance_id instance_id

Index - Schema public


Table: history

history Structure
F-Key Name Type Description
history_id serial PRIMARY KEY
contact.contact_id contact_id integer
organization.org_id org_id integer
link_object_id integer NOT NULL
link_item_id integer
status character varying(255)
type character varying(255)
description text
level integer DEFAULT 10
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL
history_instance_id instance_id

Index - Schema public


Table: import

import Structure
F-Key Name Type Description
import_id serial PRIMARY KEY
type integer NOT NULL
name character varying(250) NOT NULL
description text
source_type integer
source character varying(1000)
record_delimiter character varying(10)
column_delimiter character varying(10)
total_imported_records integer
total_failed_records integer
status_id integer
file_type integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
lookup_site_id.code site_id integer
lookup_contact_rating.code rating integer
comments text
do_merge boolean DEFAULT false
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

import_entered_idx entered import_instance_id instance_id import_name_idx name

Index - Schema public


Table: knowledge_base

knowledge_base Structure
F-Key Name Type Description
kb_id serial PRIMARY KEY
ticket_category.id category_id integer
title character varying(255) NOT NULL
description text
project_files.item_id item_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
lookup_kb_status.code status integer NOT NULL DEFAULT 1
portal_access_allowed boolean NOT NULL DEFAULT false
instance_id bigint NOT NULL
knowledge_base_instance_id instance_id

Index - Schema public


Table: lookup_access_types

lookup_access_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
link_module_id integer NOT NULL
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
rule_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

laccess_types_rule_id rule_id lookup_access_types_instance_id instance_id

Index - Schema public


Table: lookup_account_size

lookup_account_size Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_account_size_instance_id instance_id

Index - Schema public


Table: lookup_account_stage

lookup_account_stage Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_account_stage_instance_id instance_id

Index - Schema public


Table: lookup_account_types

lookup_account_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_account_types_instance_id instance_id

Index - Schema public


Table: lookup_asset_manufacturer

lookup_asset_manufacturer Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_asset_manufactu_code_seq'::regclass)
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_asset_manufacturer_instance_id instance_id

Index - Schema public


Table: lookup_asset_materials

lookup_asset_materials Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_asset_materials_instance_id instance_id

Index - Schema public


Table: lookup_asset_status

lookup_asset_status Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_asset_status_instance_id instance_id

Index - Schema public


Table: lookup_asset_vendor

lookup_asset_vendor Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_asset_vendor_instance_id instance_id

Index - Schema public


Table: lookup_authentication_classes

lookup_authentication_classes Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_authentication__code_seq'::regclass)
login_mode character varying(300)
login_authenticator character varying(300)
session_validator character varying(300)
level integer
description character varying(300)
enabled boolean
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_authentication_classes_instance_id instance_id

Index - Schema public


Table: lookup_call_priority

lookup_call_priority Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
weight integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_call_priority_instance_id instance_id

Index - Schema public


Table: lookup_call_reminder

lookup_call_reminder Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
base_value integer NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_call_reminder_instance_id instance_id

Index - Schema public


Table: lookup_call_result

lookup_call_result Structure
F-Key Name Type Description
result_id serial PRIMARY KEY
description character varying(100) NOT NULL
level integer
enabled boolean DEFAULT true
next_required boolean NOT NULL DEFAULT false
next_days integer NOT NULL
call_log.call_id next_call_type_id integer
canceled_type boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_call_result_instance_id instance_id

Index - Schema public


Table: lookup_call_types

lookup_call_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_call_types_instance_id instance_id

Index - Schema public


Table: lookup_claim_status

lookup_claim_status Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_claim_status_instance_id instance_id

Index - Schema public


Table: lookup_contact_rating

lookup_contact_rating Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_contact_rating_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_contact_rating_instance_id instance_id

Index - Schema public


Table: lookup_contact_source

lookup_contact_source Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_contact_source_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_contact_source_instance_id instance_id

Index - Schema public


Table: lookup_contact_stage

lookup_contact_stage Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_contact_stage_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_contact_stage_instance_id instance_id

Index - Schema public


Table: lookup_contact_types

lookup_contact_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
access.user_id user_id integer
category integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_contact_types_instance_id instance_id

Index - Schema public


Table: lookup_contactaddress_types

lookup_contactaddress_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_contactaddress__code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_contactaddress_types_instance_id instance_id

Index - Schema public


Table: lookup_contactemail_types

lookup_contactemail_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_contactemail_ty_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_contactemail_types_instance_id instance_id

Index - Schema public


Table: lookup_contactphone_types

lookup_contactphone_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_contactphone_ty_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_contactphone_types_instance_id instance_id

Index - Schema public


Table: lookup_container_menu

lookup_container_menu Structure
F-Key Name Type Description
code serial PRIMARY KEY
cname character varying(300)
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
link_module_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lkcontmenu_level_idx level lkcontmenu_lmid_idx link_module_id lkupcontmenu_code_idx code lookup_container_menu_instance_id instance_id

Index - Schema public


Table: lookup_creditcard_types

lookup_creditcard_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_creditcard_type_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_creditcard_types_instance_id instance_id

Index - Schema public


Table: lookup_currency

lookup_currency Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_currency_instance_id instance_id

Index - Schema public


Table: lookup_delivery_options

lookup_delivery_options Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_delivery_option_code_seq'::regclass)
description character varying(100) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_delivery_options_instance_id instance_id

Index - Schema public


Table: lookup_department

lookup_department Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_department_instance_id instance_id

Index - Schema public


Table: lookup_document_store_permission

lookup_document_store_permission Structure
F-Key Name Type Description
code serial PRIMARY KEY
lookup_document_store_permission_category.code category_id integer
permission character varying(300) NOT NULL
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
lookup_document_store_role.code default_role integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_document_store_permission_instance_id instance_id

Index - Schema public


Table: lookup_document_store_permission_category

lookup_document_store_permission_category Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_document_store_permission_category_instance_id instance_id

Index - Schema public


Table: lookup_document_store_role

lookup_document_store_role Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_document_store_role_instance_id instance_id

Index - Schema public


Table: lookup_duration_type

lookup_duration_type Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_duration_type_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_duration_type_instance_id instance_id

Index - Schema public


Table: lookup_email_model

lookup_email_model Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_email_model_instance_id instance_id

Index - Schema public


Table: lookup_emailaccount_inbox_behavior

lookup_emailaccount_inbox_behavior Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_emailaccount_in_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_emailaccount_inbox_behavior_instance_id instance_id

Index - Schema public


Table: lookup_emailserver_types

lookup_emailserver_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_emailserver_typ_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_emailserver_types_instance_id instance_id

Index - Schema public


Table: lookup_employment_types

lookup_employment_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_employment_type_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_employment_types_instance_id instance_id

Index - Schema public


Table: lookup_graph_type

lookup_graph_type Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_graph_type_instance_id instance_id

Index - Schema public


Table: lookup_help_features

lookup_help_features Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(1000) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_help_features_instance_id instance_id

Index - Schema public


Table: lookup_hours_reason

lookup_hours_reason Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_hours_reason_instance_id instance_id

Index - Schema public


Table: lookup_im_services

lookup_im_services Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_im_services_instance_id instance_id

Index - Schema public


Table: lookup_im_types

lookup_im_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_im_types_instance_id instance_id

Index - Schema public


Table: lookup_industry

lookup_industry Structure
F-Key Name Type Description
code serial PRIMARY KEY
order_id integer
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_industry_instance_id instance_id

Index - Schema public


Table: lookup_kb_status

lookup_kb_status Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
constant_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_kb_status_instance_id instance_id

Index - Schema public


Table: lookup_lists_lookup

lookup_lists_lookup Structure
F-Key Name Type Description
id serial PRIMARY KEY
permission_category.category_id module_id integer NOT NULL
lookup_id integer NOT NULL
class_name character varying(20)
table_name character varying(60)
level integer
description text
entered timestamp(3) without time zone DEFAULT now()
category_id integer NOT NULL
instance_id bigint NOT NULL
lookup_lists_lookup_instance_id instance_id

Index - Schema public


Table: lookup_locale

lookup_locale Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_locale_instance_id instance_id

Index - Schema public


Table: lookup_news_template

lookup_news_template Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(255) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
load_article boolean DEFAULT false
load_project_article_list boolean DEFAULT false
load_article_linked_list boolean DEFAULT false
load_public_projects boolean DEFAULT false
load_article_category_list boolean DEFAULT false
mapped_jsp character varying(255) NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_news_template_instance_id instance_id

Index - Schema public


Table: lookup_onsite_model

lookup_onsite_model Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_onsite_model_instance_id instance_id

Index - Schema public


Table: lookup_opportunity_budget

lookup_opportunity_budget Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_opportunity_bud_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_opportunity_budget_instance_id instance_id

Index - Schema public


Table: lookup_opportunity_competitors

lookup_opportunity_competitors Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_opportunity_com_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_opportunity_competitors_instance_id instance_id

Index - Schema public


Table: lookup_opportunity_environment

lookup_opportunity_environment Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_opportunity_env_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_opportunity_environment_instance_id instance_id

Index - Schema public


Table: lookup_opportunity_event_compelling

lookup_opportunity_event_compelling Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_opportunity_eve_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_opportunity_event_compelling_instance_id instance_id

Index - Schema public


Table: lookup_opportunity_types

lookup_opportunity_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_opportunity_typ_code_seq'::regclass)
order_id integer
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_opportunity_types_instance_id instance_id

Index - Schema public


Table: lookup_order_events

lookup_order_events Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp without time zone NOT NULL DEFAULT now()
modified timestamp without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_order_events_instance_id instance_id

Index - Schema public


Table: lookup_order_source

lookup_order_source Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_order_source_instance_id instance_id

Index - Schema public


Table: lookup_order_status

lookup_order_status Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_order_status_instance_id instance_id

Index - Schema public


Table: lookup_order_terms

lookup_order_terms Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_order_terms_instance_id instance_id

Index - Schema public


Table: lookup_order_type

lookup_order_type Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_order_type_instance_id instance_id

Index - Schema public


Table: lookup_orderaddress_types

lookup_orderaddress_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_orderaddress_types_instance_id instance_id

Index - Schema public


Table: lookup_orgaddress_types

lookup_orgaddress_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_orgaddress_type_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_orgaddress_types_instance_id instance_id

Index - Schema public


Table: lookup_orgemail_types

lookup_orgemail_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_orgemail_types_instance_id instance_id

Index - Schema public


Table: lookup_orgphone_types

lookup_orgphone_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_orgphone_types_instance_id instance_id

Index - Schema public


Table: lookup_payment_gateway

lookup_payment_gateway Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
constant_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_payment_gateway_instance_id instance_id

Index - Schema public


Table: lookup_payment_methods

lookup_payment_methods Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_payment_methods_instance_id instance_id

Index - Schema public


Table: lookup_payment_status

lookup_payment_status Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_payment_status_instance_id instance_id

Index - Schema public


Table: lookup_phone_model

lookup_phone_model Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_phone_model_instance_id instance_id

Index - Schema public


Table: lookup_product_category_type

lookup_product_category_type Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_product_categor_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_product_category_type_instance_id instance_id

Index - Schema public


Table: lookup_product_conf_result

lookup_product_conf_result Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_product_conf_re_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_product_conf_result_instance_id instance_id

Index - Schema public


Table: lookup_product_format

lookup_product_format Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_product_format_instance_id instance_id

Index - Schema public


Table: lookup_product_keyword

lookup_product_keyword Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_product_keyword_instance_id instance_id

Index - Schema public


Table: lookup_product_manufacturer

lookup_product_manufacturer Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_product_manufac_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_product_manufacturer_instance_id instance_id

Index - Schema public


Table: lookup_product_ship_time

lookup_product_ship_time Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_product_ship_ti_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_product_ship_time_instance_id instance_id

Index - Schema public


Table: lookup_product_shipping

lookup_product_shipping Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_product_shippin_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_product_shipping_instance_id instance_id

Index - Schema public


Table: lookup_product_tax

lookup_product_tax Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_product_tax_instance_id instance_id

Index - Schema public


Table: lookup_product_type

lookup_product_type Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_product_type_instance_id instance_id

Index - Schema public


Table: lookup_project_activity

lookup_project_activity Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_project_activit_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
template_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_project_activity_instance_id instance_id

Index - Schema public


Table: lookup_project_category

lookup_project_category Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_project_cat_code_seq'::regclass)
description character varying(80) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_project_category_instance_id instance_id

Index - Schema public


Table: lookup_project_loe

lookup_project_loe Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
base_value integer NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_project_loe_instance_id instance_id

Index - Schema public


Table: lookup_project_permission

lookup_project_permission Structure
F-Key Name Type Description
code serial PRIMARY KEY
lookup_project_permission_category.code category_id integer
permission character varying(300) NOT NULL
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
lookup_project_role.code default_role integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_project_permission_instance_id instance_id

Index - Schema public


Table: lookup_project_permission_category

lookup_project_permission_category Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_project_permission_category_instance_id instance_id

Index - Schema public


Table: lookup_project_priority

lookup_project_priority Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_project_priorit_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
graphic character varying(75)
type integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_project_priority_instance_id instance_id

Index - Schema public


Table: lookup_project_role

lookup_project_role Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_project_role_instance_id instance_id

Index - Schema public


Table: lookup_project_status

lookup_project_status Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
group_id integer NOT NULL
graphic character varying(75)
type integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_project_status_instance_id instance_id

Index - Schema public


Table: lookup_quote_condition

lookup_quote_condition Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_quote_condition_instance_id instance_id

Index - Schema public


Table: lookup_quote_delivery

lookup_quote_delivery Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_quote_delivery_instance_id instance_id

Index - Schema public


Table: lookup_quote_remarks

lookup_quote_remarks Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_quote_remarks_instance_id instance_id

Index - Schema public


Table: lookup_quote_source

lookup_quote_source Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_quote_source_instance_id instance_id

Index - Schema public


Table: lookup_quote_status

lookup_quote_status Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_quote_status_instance_id instance_id

Index - Schema public


Table: lookup_quote_terms

lookup_quote_terms Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_quote_terms_instance_id instance_id

Index - Schema public


Table: lookup_quote_type

lookup_quote_type Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_quote_type_instance_id instance_id

Index - Schema public


Table: lookup_recurring_type

lookup_recurring_type Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_recurring_type_instance_id instance_id

Index - Schema public


Table: lookup_relationship_types

lookup_relationship_types Structure
F-Key Name Type Description
type_id serial PRIMARY KEY
category_id_maps_from integer NOT NULL
category_id_maps_to integer NOT NULL
reciprocal_name_1 character varying(512)
reciprocal_name_2 character varying(512)
level integer
default_item boolean DEFAULT false
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_relationship_types_instance_id instance_id

Index - Schema public


Table: lookup_report_type

lookup_report_type Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
constant integer NOT NULL DEFAULT 1
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_report_type_instance_id instance_id

Index - Schema public


Table: lookup_response_model

lookup_response_model Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_response_model_instance_id instance_id

Index - Schema public


Table: lookup_revenue_types

lookup_revenue_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_revenue_types_instance_id instance_id

Index - Schema public


Table: lookup_revenuedetail_types

lookup_revenuedetail_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_revenuedetail_t_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_revenuedetail_types_instance_id instance_id

Index - Schema public


Table: lookup_sc_category

lookup_sc_category Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_sc_category_instance_id instance_id

Index - Schema public


Table: lookup_sc_type

lookup_sc_type Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_sc_type_instance_id instance_id

Index - Schema public


Table: lookup_segments

lookup_segments Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_segments_instance_id instance_id

Index - Schema public


Table: lookup_sic_codes

lookup_sic_codes Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
constant_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_sic_codes_instance_id instance_id

Index - Schema public


Table: lookup_site_id

lookup_site_id Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
short_description character varying(300)
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_site_id_instance_id instance_id

Index - Schema public


Table: lookup_sitechange_frequency

lookup_sitechange_frequency Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_sitechange_freq_code_seq'::regclass)
description character varying(300)
default_item boolean DEFAULT false
level integer
constant character varying(300)
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lkup_sitefreq_code_idx code lookup_sitechange_frequency_instance_id instance_id

Index - Schema public


Table: lookup_socialnetwork_types

lookup_socialnetwork_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_socialnetwork_types_instance_id instance_id

Index - Schema public


Table: lookup_stage

lookup_stage Structure
F-Key Name Type Description
code serial PRIMARY KEY
order_id integer
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_stage_instance_id instance_id

Index - Schema public


Table: lookup_step_actions

lookup_step_actions Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_step_actions_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
constant_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_step_actions_instance_id instance_id

Index - Schema public


Table: lookup_sub_segment

lookup_sub_segment Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
lookup_segments.code segment_id integer
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_sub_segment_instance_id instance_id

Index - Schema public


Table: lookup_survey_types

lookup_survey_types Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
type_constant integer NOT NULL
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_survey_types_instance_id instance_id

Index - Schema public


Table: lookup_task_category

lookup_task_category Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(255) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_task_category_instance_id instance_id

Index - Schema public


Table: lookup_task_loe

lookup_task_loe Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_task_loe_instance_id instance_id

Index - Schema public


Table: lookup_task_priority

lookup_task_priority Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_task_priority_instance_id instance_id

Index - Schema public


Table: lookup_tenant_server

lookup_tenant_server Structure
F-Key Name Type Description
tenant_server_id serial PRIMARY KEY
tenant_url character varying(255)
tenant_domain character varying(255)
tenant_code character varying(255)
tenant_client character varying(255)
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

tenant_server_instance_id instance_id

Index - Schema public


Table: lookup_textmessage_types

lookup_textmessage_types Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_textmessage_typ_code_seq'::regclass)
description character varying(50) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_textmessage_types_instance_id instance_id

Index - Schema public


Table: lookup_ticket_cause

lookup_ticket_cause Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_ticket_cause_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_ticket_cause_instance_id instance_id

Index - Schema public


Table: lookup_ticket_escalation

lookup_ticket_escalation Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_ticket_escalati_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_ticket_escalation_instance_id instance_id

Index - Schema public


Table: lookup_ticket_resolution

lookup_ticket_resolution Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_ticket_resoluti_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_ticket_resolution_instance_id instance_id

Index - Schema public


Table: lookup_ticket_state

lookup_ticket_state Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_ticket_state_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_ticket_state_instance_id instance_id

Index - Schema public


Table: lookup_ticket_status

lookup_ticket_status Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_ticket_status_instance_id instance_id

Index - Schema public


Table: lookup_ticket_task_category

lookup_ticket_task_category Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_ticket_task_cat_code_seq'::regclass)
description character varying(255) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_ticket_task_category_instance_id instance_id

Index - Schema public


Table: lookup_ticketsource

lookup_ticketsource Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lookup_ticketsource_instance_id instance_id

Index - Schema public


Table: lookup_title

lookup_title Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
lookup_title_instance_id instance_id

Index - Schema public


Table: lookup_webpage_priority

lookup_webpage_priority Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300)
default_item boolean DEFAULT false
level integer
constant double precision
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

lkupwp_code_idx code lookup_webpage_priority_instance_id instance_id

Index - Schema public


Table: merchant_payment_gateway

merchant_payment_gateway Structure
F-Key Name Type Description
merchant_payment_gateway_id serial PRIMARY KEY
lookup_payment_gateway.code gateway_id integer
merchant_id character varying(300)
merchant_code character varying(1024)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL
merchant_payment_gateway_instance_id instance_id

Index - Schema public


Table: message

message Structure
F-Key Name Type Description
id serial PRIMARY KEY
name character varying(80) NOT NULL
description character varying(255)
template_id integer
subject character varying(255) DEFAULT NULL::character varying
body text
reply_addr character varying(100)
url character varying(255)
img character varying(80)
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
lookup_access_types.code access_type integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

message_instance_id instance_id

Index - Schema public


Table: message_file_attachment

message_file_attachment Structure
F-Key Name Type Description
attachment_id serial PRIMARY KEY
link_module_id integer NOT NULL
link_item_id integer NOT NULL
project_files.item_id file_item_id integer
filename character varying(255) NOT NULL
size integer
version double precision
instance_id bigint NOT NULL
message_f_link_item_id link_item_id message_f_link_module_id link_module_id message_file_attachment_instance_id instance_id

Index - Schema public


Table: message_template

message_template Structure
F-Key Name Type Description
id serial PRIMARY KEY
name character varying(80) NOT NULL
description character varying(255)
template_file character varying(80)
num_imgs integer
num_urls integer
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL
message_template_instance_id instance_id

Index - Schema public


Table: module_field_categorylink

module_field_categorylink Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('module_field_categorylin_id_seq'::regclass)
permission_category.category_id module_id integer NOT NULL
category_id integer NOT NULL
level integer
description text
entered timestamp(3) without time zone DEFAULT now()
modified timestamp(3) without time zone DEFAULT now()
instance_id bigint NOT NULL
module_field_categorylink_instance_id instance_id

Index - Schema public


Table: news

news Structure
F-Key Name Type Description
rec_id serial PRIMARY KEY
organization.org_id org_id integer
url text
base text
headline text
body text
dateentered date
type character(1)
created timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
news_instance_id instance_id

Index - Schema public


Table: notification

notification Structure
F-Key Name Type Description
notification_id integer PRIMARY KEY DEFAULT nextval('notification_notification_i_seq'::regclass)
notify_user integer NOT NULL
module character varying(255) NOT NULL
item_id integer NOT NULL
item_modified timestamp(3) without time zone NOT NULL DEFAULT now()
attempt timestamp(3) without time zone NOT NULL DEFAULT now()
notify_type character varying(30)
subject text
message text
result integer NOT NULL
errormessage text
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
notification_instance_id instance_id

Index - Schema public


Table: opportunity_component

opportunity_component Structure
F-Key Name Type Description
id serial PRIMARY KEY
opportunity_header.opp_id opp_id integer
access.user_id owner integer NOT NULL
description character varying(80)
closedate timestamp(3) without time zone NOT NULL
closeprob double precision
terms double precision
units character(1)
lowvalue double precision
guessvalue double precision
highvalue double precision
lookup_stage.code stage integer
stagedate timestamp(3) without time zone NOT NULL DEFAULT now()
commission double precision
type character(1)
alertdate timestamp(3) without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
closed timestamp(3) without time zone
alert character varying(100) DEFAULT NULL::character varying
enabled boolean NOT NULL DEFAULT true
notes text
alertdate_timezone character varying(255)
closedate_timezone character varying(255)
trashed_date timestamp(3) without time zone
lookup_opportunity_environment.code environment integer
lookup_opportunity_competitors.code competitors integer
lookup_opportunity_event_compelling.code compelling_event integer
lookup_opportunity_budget.code budget integer
status_id integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

oppcomplist_closedate closedate oppcomplist_description description oppcomplist_header_idx opp_id opportunity_component_instance_id instance_id

Index - Schema public


Table: opportunity_component_levels

opportunity_component_levels Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('opportunity_component_levels_id_seq'::regclass)
opportunity_component.id opp_id integer NOT NULL
lookup_opportunity_types.code type_id integer NOT NULL
level integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
opportunity_component_levels_instance_id instance_id

Index - Schema public


Table: opportunity_component_log

opportunity_component_log Structure
F-Key Name Type Description
id serial NOT NULL
opportunity_component.id component_id integer
opportunity_header.opp_id header_id integer
description character varying(80)
closeprob double precision
closedate timestamp(3) without time zone NOT NULL
terms double precision
units character(1)
lowvalue double precision
guessvalue double precision
highvalue double precision
lookup_stage.code stage integer
access.user_id owner integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
closedate_timezone character varying(255)
closed timestamp(3) without time zone
modified timestamp(3) without time zone NOT NULL DEFAULT now()
instance_id bigint NOT NULL
opportunity_component_log_instance_id instance_id

Index - Schema public


Table: opportunity_header

opportunity_header Structure
F-Key Name Type Description
opp_id serial PRIMARY KEY
description character varying(80)
organization.org_id acctlink integer
contact.contact_id contactlink integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
trashed_date timestamp(3) without time zone
lookup_access_types.code access_type integer NOT NULL
access.user_id manager integer NOT NULL
lock boolean DEFAULT false
organization.org_id contact_org_id integer
custom1_integer integer
lookup_site_id.code site_id integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

opp_contactlink_idx contactlink opp_header_contact_org_id_idx contact_org_id oppheader_description_idx description opportunity_header_instance_id instance_id

Index - Schema public


Table: order_address

order_address Structure
F-Key Name Type Description
address_id serial PRIMARY KEY
order_entry.order_id order_id integer NOT NULL
lookup_orderaddress_types.code address_type integer
addrline1 character varying(300)
addrline2 character varying(300)
addrline3 character varying(300)
city character varying(300)
state character varying(300)
country character varying(300)
postalcode character varying(40)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
addrline4 character varying(300)
instance_id bigint NOT NULL
order_address_instance_id instance_id order_city_idx city

Index - Schema public


Table: order_entry

order_entry Structure
F-Key Name Type Description
order_id serial PRIMARY KEY
order_entry.order_id parent_id integer
organization.org_id org_id integer NOT NULL
quote_entry.quote_id quote_id integer
access.user_id sales_id integer
contact.contact_id orderedby integer
contact.contact_id billing_contact_id integer
lookup_order_source.code source_id integer
grand_total double precision
lookup_order_status.code status_id integer
status_date timestamp(3) without time zone DEFAULT now()
contract_date timestamp(3) without time zone
expiration_date timestamp(3) without time zone
lookup_order_terms.code order_terms_id integer
lookup_order_type.code order_type_id integer
description character varying(2048)
notes text
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
submitted timestamp(3) without time zone
approx_ship_date timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
approx_delivery_date timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
instance_id bigint NOT NULL
start_date timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
end_date timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
delivery_date timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
pickup_date timestamp(3) without time zone DEFAULT NULL::timestamp without time zone

Tables referencing this one via Foreign Key Constraints:

order_entry_instance_id instance_id

Index - Schema public


Table: order_payment

order_payment Structure
F-Key Name Type Description
payment_id serial PRIMARY KEY
order_entry.order_id order_id integer NOT NULL
lookup_payment_methods.code payment_method_id integer NOT NULL
payment_amount double precision
authorization_ref_number character varying(30)
authorization_code character varying(30)
authorization_date timestamp(3) without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
order_product.item_id order_item_id integer
customer_product_history.history_id history_id integer
date_to_process timestamp(3) without time zone
payment_creditcard.creditcard_id creditcard_id integer
payment_eft.bank_id bank_id integer
lookup_payment_status.code status_id integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

order_payment_instance_id instance_id

Index - Schema public


Table: order_payment_status

order_payment_status Structure
F-Key Name Type Description
payment_status_id serial PRIMARY KEY
order_payment.payment_id payment_id integer NOT NULL
lookup_payment_status.code status_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL
order_payment_status_instance_id instance_id

Index - Schema public


Table: order_product

order_product Structure
F-Key Name Type Description
item_id serial PRIMARY KEY
order_entry.order_id order_id integer NOT NULL
product_catalog.product_id product_id integer NOT NULL
quantity integer NOT NULL
lookup_currency.code msrp_currency integer
msrp_amount double precision NOT NULL
lookup_currency.code price_currency integer
price_amount double precision NOT NULL
lookup_currency.code recurring_currency integer
recurring_amount double precision NOT NULL
lookup_recurring_type.code recurring_type integer
extended_price double precision NOT NULL
total_price double precision NOT NULL
lookup_order_status.code status_id integer
status_date timestamp(3) without time zone DEFAULT now()
instance_id bigint NOT NULL
quote_calculator_session.session_id session_id integer

Tables referencing this one via Foreign Key Constraints:

order_product_instance_id instance_id

Index - Schema public


Table: order_product_option_boolean

order_product_option_boolean Structure
F-Key Name Type Description
order_product_options.order_product_option_id order_product_option_id integer
value boolean NOT NULL
instance_id bigint NOT NULL
order_product_option_boolean_instance_id instance_id

Index - Schema public


Table: order_product_option_float

order_product_option_float Structure
F-Key Name Type Description
order_product_options.order_product_option_id order_product_option_id integer
value double precision NOT NULL
instance_id bigint NOT NULL
order_product_option_float_instance_id instance_id

Index - Schema public


Table: order_product_option_integer

order_product_option_integer Structure
F-Key Name Type Description
order_product_options.order_product_option_id order_product_option_id integer
value integer NOT NULL
instance_id bigint NOT NULL
order_product_option_integer_instance_id instance_id

Index - Schema public


Table: order_product_option_text

order_product_option_text Structure
F-Key Name Type Description
order_product_options.order_product_option_id order_product_option_id integer
value text NOT NULL
instance_id bigint NOT NULL
order_product_option_text_instance_id instance_id

Index - Schema public


Table: order_product_option_timestamp

order_product_option_timestamp Structure
F-Key Name Type Description
order_product_options.order_product_option_id order_product_option_id integer
value timestamp(3) without time zone NOT NULL
instance_id bigint NOT NULL
order_product_option_timestamp_instance_id instance_id

Index - Schema public


Table: order_product_options

order_product_options Structure
F-Key Name Type Description
order_product_option_id serial PRIMARY KEY
order_product.item_id item_id integer NOT NULL
product_option_map.product_option_id product_option_id integer NOT NULL
quantity integer NOT NULL
lookup_currency.code price_currency integer
price_amount double precision NOT NULL
lookup_currency.code recurring_currency integer
recurring_amount double precision NOT NULL
lookup_recurring_type.code recurring_type integer
extended_price double precision NOT NULL
total_price double precision NOT NULL
lookup_order_status.code status_id integer
instance_id bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

order_product_options_instance_id instance_id

Index - Schema public


Table: order_product_status

order_product_status Structure
F-Key Name Type Description
order_product_status_id serial PRIMARY KEY
order_entry.order_id order_id integer NOT NULL
order_product.item_id item_id integer NOT NULL
lookup_order_status.code status_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
instance_id bigint NOT NULL
order_product_status_instance_id instance_id

Index - Schema public


Table: orderlog

orderlog Structure
F-Key Name Type Description
id serial PRIMARY KEY
order_entry.order_id order_id integer NOT NULL
lookup_order_source.code source_id integer
lookup_order_status.code status_id integer
lookup_order_terms.code terms_id integer
lookup_order_type.code type_id integer
lookup_order_events.code event_id integer
notes text
grand_total double precision
instance_id integer NOT NULL
access.user_id enteredby integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()

Index - Schema public


Table: organization

organization Structure
F-Key Name Type Description
org_id integer PRIMARY KEY DEFAULT nextval('organization_org_id_seq'::regclass)
name character varying(255) NOT NULL
account_number character varying(50)
account_group integer
url text
revenue double precision
employees integer
notes text
ticker_symbol character varying(10)
taxid character(80)
lead character varying(40)
sales_rep integer NOT NULL
miner_only boolean NOT NULL DEFAULT false
defaultlocale integer
fiscalmonth integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL
enabled boolean DEFAULT true
industry_temp_code smallint
access.user_id owner integer
duplicate_id integer DEFAULT (-1)
custom1 integer DEFAULT (-1)
custom2 integer DEFAULT (-1)
contract_end timestamp(3) without time zone
alertdate timestamp(3) without time zone
alert character varying(100)
custom_data text
namesalutation character varying(80)
namelast character varying(80)
namefirst character varying(80)
namemiddle character varying(80)
namesuffix character varying(80)
import_id integer
status_id integer
alertdate_timezone character varying(255)
contract_end_timezone character varying(255)
trashed_date timestamp(3) without time zone
lookup_contact_source.code source integer
lookup_contact_rating.code rating integer
potential double precision
lookup_segments.code segment_id integer
lookup_sub_segment.code sub_segment_id integer
direct_bill boolean DEFAULT false
lookup_account_size.code account_size integer
lookup_site_id.code site_id integer
duns_type character varying(300)
duns_number character varying(30)
business_name_two character varying(300)
lookup_sic_codes.code sic_code integer
sic_text character varying(8)
year_started integer
sic_description character varying(300)
lookup_account_stage.code stage_id integer
comments text
no_phone boolean DEFAULT false
no_fax boolean DEFAULT false
no_mail boolean DEFAULT false
no_email boolean DEFAULT false
instance_id bigint NOT NULL
connect_unique_id character varying(300)
connect_instances.connect_instance_id connect_instance_id integer
lookup_tenant_server.tenant_server_id tenant_server_id bigint
tenant_url character varying(255)
tenant_domain character varying(255)
tenant_code character varying(255)
tenant_client character varying(255)
lookup_claim_status.code claim_status integer
claimedby bigint

Tables referencing this one via Foreign Key Constraints: