Index of database - Concourse Suite 5.0


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(30)
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
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)

Tables referencing this one via Foreign Key Constraints:

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(30)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
browser character varying(255)

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()

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

Tables referencing this one via Foreign Key Constraints:

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()

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

Tables referencing this one via Foreign Key Constraints:

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()

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()

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

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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
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

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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

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()

Tables referencing this one via Foreign Key Constraints:

action_plan_constant_id constant_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()

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

Tables referencing this one via Foreign Key Constraints:

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()

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)
lookup_step_actions.constant_id action_id integer
allow_update boolean NOT NULL DEFAULT true
campaign.campaign_id campaign_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()

Tables referencing this one via Foreign Key Constraints:

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()

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()

Tables referencing this one via Foreign Key Constraints:

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
groupname character varying(80) NOT NULL
groupcriteria text

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

Tables referencing this one via Foreign Key Constraints:

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

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

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

Tables referencing this one via Foreign Key Constraints:

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)

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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

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()

Index - Schema public


Table: autoguide_ad_run

autoguide_ad_run Structure
F-Key Name Type Description
ad_run_id serial PRIMARY KEY
autoguide_inventory.inventory_id inventory_id integer NOT NULL
run_date timestamp(3) without time zone NOT NULL
ad_type character varying(20)
include_photo boolean DEFAULT false
complete_date timestamp(3) without time zone
completedby integer DEFAULT -1
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
modifiedby integer NOT NULL

Index - Schema public


Table: autoguide_ad_run_types

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

Index - Schema public


Table: autoguide_inventory

autoguide_inventory Structure
F-Key Name Type Description
inventory_id integer PRIMARY KEY DEFAULT nextval('autoguide_inve_inventory_id_seq'::regclass)
autoguide_vehicle.vehicle_id vehicle_id integer NOT NULL
organization.org_id account_id integer
vin character varying(20)
mileage character varying(20)
is_new boolean DEFAULT false
condition character varying(20)
comments character varying(255)
stock_no character varying(20)
ext_color character varying(20)
int_color character varying(20)
style character varying(40)
invoice_price double precision
selling_price double precision
selling_price_text character varying(100)
sold boolean DEFAULT false
status character varying(20)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
modifiedby integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: autoguide_inventory_options

autoguide_inventory_options Structure
F-Key Name Type Description
autoguide_inventory.inventory_id inventory_id integer NOT NULL
option_id integer NOT NULL

Index - Schema public


Table: autoguide_make

autoguide_make Structure
F-Key Name Type Description
make_id serial PRIMARY KEY
make_name character varying(30)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
modifiedby integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: autoguide_model

autoguide_model Structure
F-Key Name Type Description
model_id serial PRIMARY KEY
autoguide_make.make_id make_id integer NOT NULL
model_name character varying(50)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
modifiedby integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: autoguide_options

autoguide_options Structure
F-Key Name Type Description
option_id integer PRIMARY KEY DEFAULT nextval('autoguide_options_option_id_seq'::regclass)
option_name character varying(20) 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()

Index - Schema public


Table: autoguide_vehicle

autoguide_vehicle Structure
F-Key Name Type Description
vehicle_id integer PRIMARY KEY DEFAULT nextval('autoguide_vehicl_vehicle_id_seq'::regclass)
year character varying(4) NOT NULL
autoguide_make.make_id make_id integer NOT NULL
autoguide_model.model_id model_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
modifiedby integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: business_process

business_process Structure
F-Key Name Type Description
process_id serial PRIMARY KEY
process_name character varying(255) UNIQUE 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()

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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

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

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

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

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

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: business_process_log

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

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

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

Tables referencing this one via Foreign Key Constraints:

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)
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

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_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

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
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
type integer DEFAULT 1
active_date_timezone character varying(255)
cc character varying(1024)
bcc character varying(1024)
trashed_date timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

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

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

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
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()

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

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

Index - Schema public


Table: cfsinbox_message

cfsinbox_message Structure
F-Key Name Type Description
id serial PRIMARY KEY
subject character varying(255)
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

Tables referencing this one via Foreign Key Constraints:

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
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)

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) UNIQUE
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
year_started integer
sic_description character varying(300)
lookup_contact_stage.code stage integer

Tables referencing this one via Foreign Key Constraints:

contact_access_type access_type contact_assistant assistant 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_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_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
contact_address_contact_id_idx contact_id contact_address_postalcode_idx postalcode contact_address_prim_idx primary_address contact_city_idx city

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)
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
contact_email_contact_id_idx contact_id contact_email_prim_idx primary_email

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

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
contact_lead_read_c_idx contact_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
contact_lead_skip_u_idx user_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

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
contact_phone_contact_id_idx contact_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

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()
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

Index - Schema public


Table: custom_field_category

custom_field_category Structure
F-Key Name Type Description
module_field_categorylink.category_id 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()

Tables referencing this one via Foreign Key Constraints:

custom_field_cat_idx module_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)
custom_field_dat_idx record_id, field_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()

Tables referencing this one via Foreign Key Constraints:

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
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

Tables referencing this one via Foreign Key Constraints:

custom_field_inf_idx group_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()

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

Tables referencing this one via Foreign Key Constraints:

custom_field_rec_idx link_module_id, link_item_id, category_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()

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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

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

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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()

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

Tables referencing this one via Foreign Key Constraints:

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

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

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

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

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
lookup_emailaccount_processing_behavior.code processing_behavior integer NOT NULL
permission_category.constant 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

Tables referencing this one via Foreign Key Constraints:

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

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

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

Tables referencing this one via Foreign Key Constraints:

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

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

Tables referencing this one via Foreign Key Constraints:

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

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

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

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

Tables referencing this one via Foreign Key Constraints:

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

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

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

Tables referencing this one via Foreign Key Constraints:

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

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

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

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

Tables referencing this one via Foreign Key Constraints:

import_entered_idx entered 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

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()

Tables referencing this one via Foreign Key Constraints:

laccess_types_rule_id rule_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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

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()

Tables referencing this one via Foreign Key Constraints:

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) UNIQUE 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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: lookup_emailaccount_processing_behavior

lookup_emailaccount_processing_behavior Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_emailaccount_pr_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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

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()

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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

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()

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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) UNIQUE 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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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 UNIQUE NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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 UNIQUE NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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) UNIQUE 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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: lookup_ticket_status

lookup_ticket_status Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) UNIQUE 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()

Tables referencing this one via Foreign Key Constraints:

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()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: lookup_ticketsource

lookup_ticketsource Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) UNIQUE 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()

Tables referencing this one via Foreign Key Constraints:

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()

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()

Tables referencing this one via Foreign Key Constraints:

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

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)
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

Tables referencing this one via Foreign Key Constraints:

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
message_f_link_item_id link_item_id message_f_link_module_id link_module_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

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 UNIQUE NOT NULL
level integer
description text
entered timestamp(3) without time zone DEFAULT now()
modified timestamp(3) without time zone DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: netapp_contractexpiration

netapp_contractexpiration Structure
F-Key Name Type Description
expiration_id serial PRIMARY KEY
serial_number character varying(255)
agreement_number character varying(255)
services character varying(1024)
startdate timestamp(3) without time zone
enddate timestamp(3) without time zone
installed_at_company_name character varying(1024)
installed_at_site_name character varying(1024)
group_name character varying(255)
product_number character varying(255)
system_name character varying(255)
operating_system character varying(255)
no_of_shelves integer
no_of_disks integer
nvram integer
memory integer
auto_support_status character varying(255)
installed_at_address character varying(1024)
city character varying(255)
state_province character varying(255)
postal_code character varying(255)
country character varying(255)
installed_at_contact_firstname character varying(255)
contact_lastname character varying(255)
contact_email character varying(255)
agreement_company character varying(255)
quote_amount double precision
quotegenerateddate timestamp(3) without time zone
quoteaccepteddate timestamp(3) without time zone
quoterejecteddate timestamp(3) without time zone
comment text
import_id integer
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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: netapp_contractexpiration_log

netapp_contractexpiration_log Structure
F-Key Name Type Description
id serial PRIMARY KEY
netapp_contractexpiration.expiration_id expiration_id integer
quote_amount double precision
quotegenerateddate timestamp(3) without time zone
quoteaccepteddate timestamp(3) without time zone
quoterejecteddate timestamp(3) without time zone
comment 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

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()

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()

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)
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

Tables referencing this one via Foreign Key Constraints:

oppcomplist_closedate closedate oppcomplist_description description oppcomplist_header_idx opp_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()

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()

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

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

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)
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
approx_delivery_date timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

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

Tables referencing this one via Foreign Key Constraints:

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

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()

Tables referencing this one via Foreign Key Constraints:

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

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

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

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

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

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

Tables referencing this one via Foreign Key Constraints:

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

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(80) 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
year_started integer
sic_description character varying(300)
lookup_account_stage.code stage_id integer
comments text

Tables referencing this one via Foreign Key Constraints:

org_account_size_idx account_size org_enteredby_idx enteredby org_industry_temp_code_idx industry_temp_code org_modifiedby_idx modifiedby org_org_id_miner_only_idx org_id, miner_only org_owner_idx "owner" org_site_id_idx site_id org_status_id_idx status_id orglist_name name

Index - Schema public


Table: organization_address

organization_address Structure
F-Key Name Type Description
address_id integer PRIMARY KEY DEFAULT nextval('organization_add_address_id_seq'::regclass)
organization.org_id org_id integer
lookup_orgaddress_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
org_addr_org_id_idx org_id org_addr_pri_address_idx primary_address organization_address_postalcode_idx postalcode

Index - Schema public


Table: organization_emailaddress

organization_emailaddress Structure
F-Key Name Type Description
emailaddress_id integer PRIMARY KEY DEFAULT nextval('organization__emailaddress__seq'::regclass)
organization.org_id org_id integer
lookup_orgemail_types.code emailaddress_type integer
email 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_email boolean NOT NULL DEFAULT false

Index - Schema public


Table: organization_phone

organization_phone Structure
F-Key Name Type Description
phone_id integer PRIMARY KEY DEFAULT nextval('organization_phone_phone_id_seq'::regclass)
organization.org_id org_id integer
lookup_orgphone_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

Index - Schema public


Table: package

package Structure
F-Key Name Type Description
package_id serial PRIMARY KEY
product_category.category_id category_id integer
package_name character varying(255) NOT NULL
abbreviation character varying(30)
short_description text
long_description text
project_files.item_id thumbnail_image_id integer
project_files.item_id small_image_id integer
project_files.item_id large_image_id integer
list_order integer DEFAULT 10
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()
start_date timestamp(3) without time zone
expiration_date timestamp(3) without time zone
enabled boolean NOT NULL DEFAULT true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: package_products_map

package_products_map Structure
F-Key Name Type Description
id serial PRIMARY KEY
package.package_id package_id integer NOT NULL
product_catalog.product_id product_id integer NOT NULL
description text
lookup_currency.code msrp_currency integer
msrp_amount double precision NOT NULL
lookup_currency.code price_currency integer
price_amount double precision 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()
start_date timestamp(3) without time zone
expiration_date timestamp(3) without time zone

Index - Schema public


Table: payment_creditcard

payment_creditcard 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
order_entry.order_id order_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: payment_eft

payment_eft Structure
F-Key Name Type Description
bank_id serial PRIMARY KEY
bank_name character varying(300)
routing_number character varying(300)
account_number character varying(300)
name_on_account character varying(300)
company_name_on_account 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
order_entry.order_id order_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: permission

permission Structure
F-Key Name Type Description
permission_id serial PRIMARY KEY
permission_category.category_id category_id integer NOT NULL
permission character varying(80) NOT NULL
permission_view boolean NOT NULL DEFAULT false
permission_add boolean NOT NULL DEFAULT false
permission_edit boolean NOT NULL DEFAULT false
permission_delete boolean NOT NULL DEFAULT false
description character varying(255) NOT NULL DEFAULT ''::character varying
level integer NOT NULL
enabled boolean NOT NULL DEFAULT true
active boolean NOT NULL DEFAULT true
viewpoints boolean DEFAULT false
permission_offline_view boolean NOT NULL DEFAULT false
permission_offline_add boolean NOT NULL DEFAULT false
permission_offline_edit boolean NOT NULL DEFAULT false
permission_offline_delete 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()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: permission_category

permission_category Structure
F-Key Name Type Description
category_id integer PRIMARY KEY DEFAULT nextval('permission_cate_category_id_seq'::regclass)
category character varying(80)
description character varying(255)
level integer NOT NULL
enabled boolean NOT NULL DEFAULT true
active boolean NOT NULL DEFAULT true
folders boolean NOT NULL DEFAULT false
lookups boolean NOT NULL DEFAULT false
viewpoints boolean DEFAULT false
categories boolean NOT NULL DEFAULT false
scheduled_events boolean NOT NULL DEFAULT false
object_events boolean NOT NULL DEFAULT false
reports boolean NOT NULL DEFAULT false
webdav boolean NOT NULL DEFAULT false
logos boolean NOT NULL DEFAULT false
constant integer UNIQUE NOT NULL
action_plans boolean NOT NULL DEFAULT false
custom_list_views 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()
dashboards boolean NOT NULL DEFAULT false
customtabs boolean NOT NULL DEFAULT false
email_accounts boolean NOT NULL DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: portfolio_category

portfolio_category Structure
F-Key Name Type Description
category_id integer PRIMARY KEY DEFAULT nextval('portfolio_cat_y_category_id_seq'::regclass)
category_name character varying(300) NOT NULL
category_description text
portfolio_category.category_id category_position_id integer
portfolio_category.category_id parent_category_id 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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: portfolio_item

portfolio_item Structure
F-Key Name Type Description
item_id serial PRIMARY KEY
item_name character varying(300) NOT NULL
item_description text
portfolio_item.item_id item_position_id integer
project_files.item_id image_id integer
caption character varying(300)
portfolio_category.category_id portfolio_category_id 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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: process_log

process_log Structure
F-Key Name Type Description
process_id serial PRIMARY KEY
sync_system.system_id system_id integer NOT NULL
sync_client.client_id client_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
process_name character varying(255)
process_version character varying(20)
status integer
message text

Index - Schema public


Table: product_catalog

product_catalog Structure
F-Key Name Type Description
product_id serial PRIMARY KEY
product_catalog.product_id parent_id integer
product_name character varying(255) NOT NULL
abbreviation character varying(30)
short_description text
long_description text
lookup_product_type.code type_id integer
special_notes character varying(255)
sku character varying(40)
in_stock boolean NOT NULL DEFAULT true
lookup_product_format.code format_id integer
lookup_product_shipping.code shipping_id integer
lookup_product_ship_time.code estimated_ship_time integer
project_files.item_id thumbnail_image_id integer
project_files.item_id small_image_id integer
project_files.item_id large_image_id integer
list_order integer DEFAULT 10
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()
start_date timestamp(3) without time zone
expiration_date timestamp(3) without time zone
enabled boolean NOT NULL DEFAULT true
lookup_product_manufacturer.code manufacturer_id integer
trashed_date timestamp(3) without time zone
active boolean NOT NULL DEFAULT true
comments character varying(255)
import.import_id import_id integer
status_id integer

Tables referencing this one via Foreign Key Constraints:

pcatalog_enteredby enteredby pcatalog_estimated_ship_time estimated_ship_time pcatalog_format_id format_id pcatalog_import_id import_id pcatalog_large_image_id large_image_id pcatalog_manufacturer_id manufacturer_id pcatalog_modifiedby modifiedby pcatalog_name product_name pcatalog_pid parent_id pcatalog_shipping_id shipping_id pcatalog_small_image_id small_image_id pcatalog_thumbnail_image_id thumbnail_image_id pcatalog_type_id type_id

Index - Schema public


Table: product_catalog_category_map

product_catalog_category_map Structure
F-Key Name Type Description
id serial PRIMARY KEY
product_catalog.product_id product_id integer NOT NULL
product_category.category_id category_id integer NOT NULL
product_category_map_cid category_id

Index - Schema public


Table: product_catalog_pricing

product_catalog_pricing Structure
F-Key Name Type Description
price_id serial PRIMARY KEY
product_catalog.product_id product_id integer
lookup_product_tax.code tax_id integer
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
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()
start_date timestamp(3) without time zone
expiration_date timestamp(3) without time zone
enabled boolean DEFAULT false
lookup_currency.code cost_currency integer
cost_amount double precision NOT NULL
product_pricing_product_idx product_id

Index - Schema public


Table: product_category

product_category Structure
F-Key Name Type Description
category_id serial PRIMARY KEY
product_category.category_id parent_id integer
category_name character varying(255) NOT NULL
abbreviation character varying(30)
short_description text
long_description text
lookup_product_category_type.code type_id integer
project_files.item_id thumbnail_image_id integer
project_files.item_id small_image_id integer
project_files.item_id large_image_id integer
list_order integer DEFAULT 10
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()
start_date timestamp(3) without time zone
expiration_date timestamp(3) without time zone
enabled boolean NOT NULL DEFAULT true
import.import_id import_id integer
status_id integer

Tables referencing this one via Foreign Key Constraints:

pcategory_enteredby enteredby pcategory_import_id import_id pcategory_large_image_id large_image_id pcategory_modifiedby modifiedby pcategory_parent_id parent_id pcategory_small_image_id small_image_id pcategory_thumbnail_image_id thumbnail_image_id pcategory_type_id type_id

Index - Schema public


Table: product_category_map

product_category_map Structure
F-Key Name Type Description
id serial PRIMARY KEY
product_category.category_id category1_id integer NOT NULL
product_category.category_id category2_id integer NOT NULL

Index - Schema public


Table: product_keyword_map

product_keyword_map Structure
F-Key Name Type Description
product_catalog.product_id product_id integer NOT NULL
lookup_product_keyword.code keyword_id integer NOT NULL

Index - Schema public


Table: product_option

product_option Structure
F-Key Name Type Description
option_id serial PRIMARY KEY
product_option_configurator.configurator_id configurator_id integer NOT NULL
product_option.option_id parent_id integer
short_description text
long_description text
allow_customer_configure boolean NOT NULL DEFAULT false
allow_user_configure boolean NOT NULL DEFAULT false
required boolean NOT NULL DEFAULT false
start_date timestamp(3) without time zone
end_date timestamp(3) without time zone
enabled boolean DEFAULT false
option_name character varying(300)
has_range boolean DEFAULT false
has_multiplier boolean DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: product_option_boolean

product_option_boolean Structure
F-Key Name Type Description
product_option.option_id product_option_id integer NOT NULL
value boolean NOT NULL
id integer

Index - Schema public


Table: product_option_configurator

product_option_configurator Structure
F-Key Name Type Description
configurator_id serial PRIMARY KEY
short_description text
long_description text
class_name character varying(255)
lookup_product_conf_result.code result_type integer NOT NULL
configurator_name character varying(300) NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: product_option_float

product_option_float Structure
F-Key Name Type Description
product_option.option_id product_option_id integer NOT NULL
value double precision NOT NULL
id integer

Index - Schema public


Table: product_option_integer

product_option_integer Structure
F-Key Name Type Description
product_option.option_id product_option_id integer NOT NULL
value integer NOT NULL
id integer

Index - Schema public


Table: product_option_map

product_option_map Structure
F-Key Name Type Description
product_option_id serial PRIMARY KEY
product_catalog.product_id product_id integer NOT NULL
product_option.option_id option_id integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: product_option_text

product_option_text Structure
F-Key Name Type Description
product_option.option_id product_option_id integer NOT NULL
value text NOT NULL
id integer

Index - Schema public


Table: product_option_timestamp

product_option_timestamp Structure
F-Key Name Type Description
product_option.option_id product_option_id integer NOT NULL
value timestamp(3) without time zone NOT NULL
id integer

Index - Schema public


Table: product_option_values

product_option_values Structure
F-Key Name Type Description
value_id serial PRIMARY KEY
product_option.option_id option_id integer NOT NULL
result_id integer NOT NULL
description text
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