Index of database - Centric CRM 4.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(15)
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

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

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

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

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

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)

Tables referencing this one via Foreign Key Constraints:

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

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

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

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
action_step.step_id step_id integer NOT NULL
lookup_account_types.code type_id integer NOT NULL

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

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(15) 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 character varying(4000)
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 character varying(4000)
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 character varying(4000)
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
followup_date timestamp(3) without time zone
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

Tables referencing this one via Foreign Key Constraints:

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

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 NOT NULL
access.user_id enteredby integer NOT NULL
sent timestamp(3) without time zone NOT NULL DEFAULT now()
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 NOT NULL
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 NOT NULL
status integer NOT NULL
viewed timestamp(3) without time zone
enabled boolean NOT NULL DEFAULT true
access.user_id sent_from integer NOT NULL

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

Tables referencing this one via Foreign Key Constraints:

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)

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

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

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

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

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

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

Tables referencing this one via Foreign Key Constraints:

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

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

Tables referencing this one via Foreign Key Constraints:

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)

Tables referencing this one via Foreign Key Constraints:

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

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:

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

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

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

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

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

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

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

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

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

Tables referencing this one via Foreign Key Constraints:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

Index - Schema public


Table: opportunity_component_levels

opportunity_component_levels Structure
F-Key Name Type Description
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

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:

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

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

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
sic_code character varying(40)
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

Tables referencing this one via Foreign Key Constraints:

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)

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

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
products boolean NOT NULL DEFAULT false
webdav boolean NOT NULL DEFAULT false
logos boolean NOT NULL DEFAULT false
constant integer NOT NULL
action_plans boolean NOT NULL DEFAULT false
custom_list_views boolean NOT NULL DEFAULT false

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

Tables referencing this one via Foreign Key Constraints:

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

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

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

Tables referencing this one via Foreign Key Constraints:

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
recurring_amount double precision NOT NULL
lookup_recurring_type.code recurring_type integer
enabled boolean DEFAULT true
value double precision
multiplier double precision DEFAULT 1
range_min integer DEFAULT 1
range_max integer DEFAULT 1
lookup_currency.code cost_currency integer
cost_amount double precision NOT NULL

Index - Schema public


Table: project_accounts

project_accounts Structure
F-Key Name Type Description
id serial PRIMARY KEY
projects.project_id project_id integer NOT NULL
organization.org_id org_id integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: project_assignments

project_assignments Structure
F-Key Name Type Description
assignment_id integer PRIMARY KEY DEFAULT nextval('project_assig_assignment_id_seq'::regclass)
projects.project_id project_id integer NOT NULL
project_requirements.requirement_id requirement_id integer
access.user_id assignedby integer
access.user_id user_assign_id integer
technology character varying(50)
role character varying(255)
estimated_loevalue integer
lookup_project_loe.code estimated_loetype integer
actual_loevalue integer
lookup_project_loe.code actual_loetype integer
lookup_project_priority.code priority_id integer
assign_date timestamp(3) without time zone DEFAULT now()
est_start_date timestamp(3) without time zone
start_date timestamp(3) without time zone
due_date timestamp(3) without time zone
lookup_project_status.code status_id integer
status_date timestamp(3) without time zone NOT NULL DEFAULT now()
complete_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
project_assignments_folder.folder_id folder_id integer
percent_complete integer
due_date_timezone character varying(255)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_assignments_folder

project_assignments_folder Structure
F-Key Name Type Description
folder_id integer PRIMARY KEY DEFAULT nextval('project_assignmen_folder_id_seq'::regclass)
project_assignments_folder.folder_id parent_id integer
project_requirements.requirement_id requirement_id integer NOT NULL
name character varying(255) NOT NULL
description 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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_assignments_status

project_assignments_status Structure
F-Key Name Type Description
status_id integer PRIMARY KEY DEFAULT nextval('project_assignmen_status_id_seq'::regclass)
project_assignments.assignment_id assignment_id integer NOT NULL
access.user_id user_id integer NOT NULL
description text NOT NULL
status_date timestamp(3) without time zone DEFAULT now()
percent_complete integer
lookup_project_status.code project_status_id integer
access.user_id user_assign_id integer

Index - Schema public


Table: project_files

project_files Structure
F-Key Name Type Description
item_id serial PRIMARY KEY
link_module_id integer NOT NULL
link_item_id integer NOT NULL
project_folders.folder_id folder_id integer
client_filename character varying(255) NOT NULL
filename character varying(255) NOT NULL
subject character varying(500) NOT NULL
size integer
version double precision
enabled boolean DEFAULT true
downloads 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
default_file boolean DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_files_download

project_files_download Structure
F-Key Name Type Description
project_files.item_id item_id integer NOT NULL
version double precision
access.user_id user_download_id integer
download_date timestamp(3) without time zone NOT NULL DEFAULT now()

Index - Schema public


Table: project_files_thumbnail

project_files_thumbnail Structure
F-Key Name Type Description
project_files.item_id item_id integer
filename character varying(255) NOT NULL
size integer
version double precision
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: project_files_version

project_files_version Structure
F-Key Name Type Description
project_files.item_id item_id integer
client_filename character varying(255) NOT NULL
filename character varying(255) NOT NULL
subject character varying(500) NOT NULL
size integer
version double precision
enabled boolean DEFAULT true
downloads 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: project_folders

project_folders Structure
F-Key Name Type Description
folder_id serial PRIMARY KEY
link_module_id integer NOT NULL
link_item_id integer NOT NULL
subject character varying(255) NOT NULL
description text
parent_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
display integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_issue_replies

project_issue_replies Structure
F-Key Name Type Description
reply_id integer PRIMARY KEY DEFAULT nextval('project_issue_repl_reply_id_seq'::regclass)
project_issues.issue_id issue_id integer NOT NULL
reply_to integer
subject character varying(255) NOT NULL
message text NOT NULL
importance 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: project_issues

project_issues Structure
F-Key Name Type Description
issue_id serial PRIMARY KEY
projects.project_id project_id integer NOT NULL
subject character varying(255) NOT NULL
message text NOT NULL
importance integer
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
project_issues_categories.category_id category_id integer
reply_count integer NOT NULL
last_reply_date timestamp(3) without time zone NOT NULL DEFAULT now()
last_reply_by integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_issues_categories

project_issues_categories Structure
F-Key Name Type Description
category_id integer PRIMARY KEY DEFAULT nextval('project_issue_cate_categ_id_seq'::regclass)
projects.project_id project_id integer NOT NULL
subject character varying(255) NOT NULL
description text
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
topics_count integer NOT NULL
posts_count integer NOT NULL
last_post_date timestamp(3) without time zone
last_post_by integer
allow_files boolean NOT NULL DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_news

project_news Structure
F-Key Name Type Description
news_id serial PRIMARY KEY
projects.project_id project_id integer NOT NULL
project_news_category.category_id category_id integer
subject character varying(255) NOT NULL
intro text
message text
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
start_date timestamp(3) without time zone DEFAULT now()
end_date timestamp(3) without time zone
allow_replies boolean DEFAULT false
allow_rating boolean DEFAULT false
rating_count integer NOT NULL
avg_rating double precision
priority_id integer DEFAULT 10
read_count integer NOT NULL
enabled boolean DEFAULT true
status integer
html boolean NOT NULL DEFAULT true
start_date_timezone character varying(255)
end_date_timezone character varying(255)
classification_id integer NOT NULL
lookup_news_template.code template_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_news_category

project_news_category Structure
F-Key Name Type Description
category_id serial PRIMARY KEY
projects.project_id project_id integer NOT NULL
category_name character varying(255)
entered timestamp(3) without time zone DEFAULT now()
level integer NOT NULL
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_permissions

project_permissions Structure
F-Key Name Type Description
id serial PRIMARY KEY
projects.project_id project_id integer NOT NULL
lookup_project_permission.code permission_id integer NOT NULL
lookup_project_role.code userlevel integer NOT NULL

Index - Schema public


Table: project_requirements

project_requirements Structure
F-Key Name Type Description
requirement_id integer PRIMARY KEY DEFAULT nextval('project_requi_requirement_i_seq'::regclass)
projects.project_id project_id integer NOT NULL
submittedby character varying(50)
departmentby character varying(30)
shortdescription character varying(255) NOT NULL
description text NOT NULL
datereceived timestamp(3) without time zone
estimated_loevalue integer
lookup_project_loe.code estimated_loetype integer
actual_loevalue integer
lookup_project_loe.code actual_loetype integer
deadline timestamp(3) without time zone
access.user_id approvedby integer
approvaldate timestamp(3) without time zone
access.user_id closedby integer
closedate 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
startdate timestamp(3) without time zone
startdate_timezone character varying(255)
deadline_timezone character varying(255)
due_date_timezone character varying(255)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_requirements_map

project_requirements_map Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
projects.project_id project_id integer NOT NULL
project_requirements.requirement_id requirement_id integer NOT NULL
position integer NOT NULL
indent integer NOT NULL
project_assignments_folder.folder_id folder_id integer
project_assignments.assignment_id assignment_id integer

Index - Schema public


Table: project_team

project_team Structure
F-Key Name Type Description
projects.project_id project_id integer NOT NULL
access.user_id user_id integer NOT NULL
lookup_project_role.code userlevel integer NOT NULL
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
status integer
last_accessed timestamp(3) without time zone

Index - Schema public


Table: project_ticket_count

project_ticket_count Structure
F-Key Name Type Description
projects.project_id project_id integer UNIQUE NOT NULL
key_count integer NOT NULL

Index - Schema public


Table: projects

projects Structure
F-Key Name Type Description
project_id serial PRIMARY KEY
group_id integer
lookup_department.code department_id integer
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()
approvaldate timestamp(3) without time zone
closedate timestamp(3) without time zone
owner integer
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
access.user_id approvalby integer
lookup_project_category.code category_id integer
portal boolean NOT NULL DEFAULT false
allow_guests boolean NOT NULL DEFAULT false
news_enabled boolean NOT NULL DEFAULT true
details_enabled boolean NOT NULL DEFAULT true
team_enabled boolean NOT NULL DEFAULT true
plan_enabled boolean NOT NULL DEFAULT true
lists_enabled boolean NOT NULL DEFAULT true
discussion_enabled boolean NOT NULL DEFAULT true
tickets_enabled boolean NOT NULL DEFAULT true
documents_enabled boolean NOT NULL DEFAULT true
news_label character varying(50)
details_label character varying(50)
team_label character varying(50)
plan_label character varying(50)
lists_label character varying(50)
discussion_label character varying(50)
tickets_label character varying(50)
documents_label character varying(50)
est_closedate timestamp(3) without time zone
budget double precision
budget_currency character varying(5)
requestdate_timezone character varying(255)
est_closedate_timezone character varying(255)
portal_default boolean NOT NULL DEFAULT false
portal_header character varying(255)
portal_format character varying(255)
portal_key character varying(255)
portal_build_news_body boolean NOT NULL DEFAULT false
portal_news_menu boolean NOT NULL DEFAULT false
description text
allows_user_observers boolean NOT NULL DEFAULT false
level integer NOT NULL DEFAULT 10
portal_page_type integer
calendar_enabled boolean NOT NULL DEFAULT true
calendar_label character varying(50)
accounts_enabled boolean NOT NULL DEFAULT true
accounts_label character varying(50)
trashed_date timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: quote_condition

quote_condition Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
quote_entry.quote_id quote_id integer NOT NULL
lookup_quote_condition.code condition_id integer NOT NULL

Index - Schema public


Table: quote_entry

quote_entry Structure
F-Key Name Type Description
quote_id serial PRIMARY KEY
quote_entry.quote_id parent_id integer
organization.org_id org_id integer
contact.contact_id contact_id integer
lookup_quote_source.code source_id integer
grand_total double precision
lookup_quote_status.code status_id integer
status_date timestamp(3) without time zone DEFAULT now()
expiration_date timestamp(3) without time zone
lookup_quote_terms.code quote_terms_id integer
lookup_quote_type.code quote_type_id integer
issued timestamp(3) without time zone DEFAULT now()
short_description text
notes text
ticket.ticketid ticketid 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
product_catalog.product_id product_id integer
customer_product.customer_product_id customer_product_id integer
opportunity_header.opp_id opp_id integer
version character varying(255) NOT NULL DEFAULT '0'::character varying
quote_group.group_id group_id integer NOT NULL
lookup_quote_delivery.code delivery_id integer
email_address text
phone_number text
address text
fax_number text
submit_action integer
closed timestamp(3) without time zone
show_total boolean DEFAULT true
show_subtotal boolean DEFAULT true
project_files.item_id logo_file_id integer
trashed_date timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: quote_group

quote_group Structure
F-Key Name Type Description
group_id serial PRIMARY KEY
unused character(1)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: quote_notes

quote_notes Structure
F-Key Name Type Description
notes_id serial PRIMARY KEY
quote_entry.quote_id quote_id integer
notes text
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: quote_product

quote_product Structure
F-Key Name Type Description
item_id serial PRIMARY KEY
quote_entry.quote_id quote_id integer NOT NULL
product_catalog.product_id product_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
estimated_delivery_date timestamp(3) without time zone
lookup_quote_status.code status_id integer
status_date timestamp(3) without time zone DEFAULT now()
estimated_delivery text
comment character varying(300)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: quote_product_option_boolean

quote_product_option_boolean Structure
F-Key Name Type Description
quote_product_options.quote_product_option_id quote_product_option_id integer
value boolean NOT NULL
id integer

Index - Schema public


Table: quote_product_option_float

quote_product_option_float Structure
F-Key Name Type Description
quote_product_options.quote_product_option_id quote_product_option_id integer
value double precision NOT NULL
id integer

Index - Schema public


Table: quote_product_option_integer

quote_product_option_integer Structure
F-Key Name Type Description
quote_product_options.quote_product_option_id quote_product_option_id integer
value integer NOT NULL
id integer

Index - Schema public


Table: quote_product_option_text

quote_product_option_text Structure
F-Key Name Type Description
quote_product_options.quote_product_option_id quote_product_option_id integer
value text NOT NULL
id integer

Index - Schema public


Table: quote_product_option_timestamp

quote_product_option_timestamp Structure
F-Key Name Type Description
quote_product_options.quote_product_option_id quote_product_option_id integer
value timestamp(3) without time zone NOT NULL
id integer

Index - Schema public


Table: quote_product_options

quote_product_options Structure
F-Key Name Type Description
quote_product_option_id serial PRIMARY KEY
quote_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_quote_status.code status_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: quote_remark

quote_remark Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
quote_entry.quote_id quote_id integer NOT NULL
lookup_quote_remarks.code remark_id integer NOT NULL

Index - Schema public


Table: quotelog

quotelog Structure
F-Key Name Type Description
id serial PRIMARY KEY
quote_entry.quote_id quote_id integer NOT NULL
lookup_quote_source.code source_id integer
lookup_quote_status.code status_id integer
lookup_quote_terms.code terms_id integer
lookup_quote_type.code type_id integer
lookup_quote_delivery.code delivery_id integer
notes text
grand_total double precision
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()
issued_date timestamp(3) without time zone
submit_action integer
closed timestamp(3) without time zone

Index - Schema public


Table: relationship

relationship Structure
F-Key Name Type Description
relationship_id serial PRIMARY KEY
lookup_relationship_types.type_id type_id integer
object_id_maps_from integer NOT NULL
category_id_maps_from integer NOT NULL
object_id_maps_to integer NOT NULL
category_id_maps_to 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
trashed_date timestamp(3) without time zone

Index - Schema public


Table: report

report Structure
F-Key Name Type Description
report_id serial PRIMARY KEY
permission_category.category_id category_id integer NOT NULL
permission.permission_id permission_id integer
filename character varying(300) NOT NULL
type integer NOT NULL DEFAULT 1
title character varying(300) NOT NULL
description character varying(1024) 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 true
custom boolean DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: report_criteria

report_criteria Structure
F-Key Name Type Description
criteria_id serial PRIMARY KEY
report.report_id report_id integer NOT NULL
access.user_id owner integer NOT NULL
subject character varying(512) 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 true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: report_criteria_parameter

report_criteria_parameter Structure
F-Key Name Type Description
parameter_id serial PRIMARY KEY
report_criteria.criteria_id criteria_id integer NOT NULL
parameter character varying(255) NOT NULL
value text

Index - Schema public


Table: report_queue

report_queue Structure
F-Key Name Type Description
queue_id serial PRIMARY KEY
report.report_id report_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
processed timestamp(3) without time zone
status integer NOT NULL
filename character varying(256)
filesize integer DEFAULT -1
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: report_queue_criteria

report_queue_criteria Structure
F-Key Name Type Description
criteria_id serial PRIMARY KEY
report_queue.queue_id queue_id integer NOT NULL
parameter character varying(255) NOT NULL
value text

Index - Schema public


Table: revenue

revenue Structure
F-Key Name Type Description
id serial PRIMARY KEY
organization.org_id org_id integer
transaction_id integer DEFAULT -1
month integer DEFAULT -1
year integer DEFAULT -1
amount double precision
lookup_revenue_types.code type integer
access.user_id owner integer
description character varying(255)
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: revenue_detail

revenue_detail Structure
F-Key Name Type Description
id serial PRIMARY KEY
revenue.id revenue_id integer
amount double precision
lookup_revenue_types.code type integer
access.user_id owner integer
description character varying(255)
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: role

role Structure
F-Key Name Type Description
role_id serial PRIMARY KEY
role character varying(80) NOT NULL
description character varying(255) NOT NULL DEFAULT ''::character varying
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
role_type integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: role_permission

role_permission Structure
F-Key Name Type Description
id serial PRIMARY KEY
role.role_id role_id integer NOT NULL
permission.permission_id permission_id integer NOT NULL
role_view boolean NOT NULL DEFAULT false
role_add boolean NOT NULL DEFAULT false
role_edit boolean NOT NULL DEFAULT false
role_delete boolean NOT NULL DEFAULT false

Index - Schema public


Table: saved_criteriaelement

saved_criteriaelement Structure
F-Key Name Type Description
saved_criterialist.id id integer NOT NULL
search_fields.id field integer NOT NULL
operator character varying(50) NOT NULL
field_types.id operatorid integer NOT NULL
value character varying(80) NOT NULL
source integer NOT NULL DEFAULT -1
value_id integer
site_id integer

Index - Schema public


Table: saved_criterialist

saved_criterialist Structure
F-Key Name Type Description
id serial PRIMARY KEY
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
access.user_id owner integer NOT NULL
name character varying(80) NOT NULL
contact_source integer DEFAULT -1
enabled boolean NOT NULL DEFAULT true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: scheduled_recipient

scheduled_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
run_id integer DEFAULT -1
status_id integer
status character varying(255)
status_date timestamp(3) without time zone DEFAULT now()
scheduled_date timestamp(3) without time zone DEFAULT now()
sent_date timestamp(3) without time zone
reply_date timestamp(3) without time zone
bounce_date timestamp(3) without time zone

Index - Schema public


Table: search_fields

search_fields Structure
F-Key Name Type Description
id serial PRIMARY KEY
field character varying(80)
description character varying(255)
searchable boolean NOT NULL DEFAULT true
field_typeid integer NOT NULL DEFAULT -1
table_name character varying(80)
object_class character varying(80)
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: service_contract

service_contract Structure
F-Key Name Type Description
contract_id serial PRIMARY KEY
contract_number character varying(30)
organization.org_id account_id integer NOT NULL
initial_start_date timestamp(3) without time zone NOT NULL
current_start_date timestamp(3) without time zone
current_end_date timestamp(3) without time zone
lookup_sc_category.code category integer
lookup_sc_type.code type integer
contact.contact_id contact_id integer
description text
contract_billing_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
contract_value double precision
total_hours_remaining double precision
service_model_notes text
initial_start_date_timezone character varying(255)
current_start_date_timezone character varying(255)
current_end_date_timezone character varying(255)
trashed_date timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: service_contract_hours

service_contract_hours Structure
F-Key Name Type Description
history_id serial PRIMARY KEY
service_contract.contract_id link_contract_id integer
adjustment_hours double precision
lookup_hours_reason.code adjustment_reason integer
adjustment_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

Index - Schema public


Table: service_contract_products

service_contract_products Structure
F-Key Name Type Description
id serial PRIMARY KEY
service_contract.contract_id link_contract_id integer
product_catalog.product_id link_product_id integer

Index - Schema public


Table: state

state Structure
F-Key Name Type Description
state_code character(2) PRIMARY KEY
state character varying(80) NOT NULL

Index - Schema public


Table: step_action_map

step_action_map Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
action_plan_constants.map_id constant_id integer NOT NULL
lookup_step_actions.constant_id action_constant_id integer NOT NULL

Index - Schema public


Table: survey

survey Structure
F-Key Name Type Description
survey_id serial PRIMARY KEY
name character varying(80) NOT NULL
description character varying(255)
intro text
outro text
itemlength integer DEFAULT -1
type integer DEFAULT -1
enabled boolean NOT NULL DEFAULT true
status integer NOT NULL DEFAULT -1
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: survey_items

survey_items Structure
F-Key Name Type Description
item_id serial PRIMARY KEY
survey_questions.question_id question_id integer NOT NULL
type integer DEFAULT -1
description character varying(255)

Index - Schema public


Table: survey_questions

survey_questions Structure
F-Key Name Type Description
question_id integer PRIMARY KEY DEFAULT nextval('survey_question_question_id_seq'::regclass)
survey.survey_id survey_id integer NOT NULL
lookup_survey_types.code type integer NOT NULL
description character varying(255)
required boolean NOT NULL DEFAULT false
position integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: sync_client

sync_client Structure
F-Key Name Type Description
client_id serial PRIMARY KEY
type character varying(100)
version 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
anchor timestamp(3) without time zone
enabled boolean DEFAULT false
code character varying(255)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: sync_conflict_log

sync_conflict_log Structure
F-Key Name Type Description
sync_client.client_id client_id integer NOT NULL
sync_table.table_id table_id integer NOT NULL
record_id integer NOT NULL
status_date timestamp(3) without time zone NOT NULL DEFAULT now()

Index - Schema public


Table: sync_log

sync_log Structure
F-Key Name Type Description
log_id serial PRIMARY KEY
sync_system.system_id system_id integer NOT NULL
sync_client.client_id client_id integer NOT NULL
ip character varying(15)
entered timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: sync_map

sync_map Structure
F-Key Name Type Description
sync_client.client_id client_id integer NOT NULL
sync_table.table_id table_id integer NOT NULL
record_id integer NOT NULL
cuid integer NOT NULL
complete boolean DEFAULT false
status_date timestamp(3) without time zone

Index - Schema public


Table: sync_system

sync_system Structure
F-Key Name Type Description
system_id serial PRIMARY KEY
application_name character varying(255)
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: sync_table

sync_table Structure
F-Key Name Type Description
table_id serial PRIMARY KEY
sync_system.system_id system_id integer NOT NULL
element_name character varying(255)
mapped_class_name character varying(255)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
create_statement text
order_id integer DEFAULT -1
sync_item boolean DEFAULT false
object_key character varying(50)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: sync_transaction_log

sync_transaction_log Structure
F-Key Name Type Description
transaction_id integer PRIMARY KEY DEFAULT nextval('sync_transact_transaction_i_seq'::regclass)
sync_log.log_id log_id integer NOT NULL
reference_id character varying(50)
element_name character varying(255)
action character varying(20)
link_item_id integer
status_code integer
record_count integer
message text

Index - Schema public


Table: task

task Structure
F-Key Name Type Description
task_id serial PRIMARY KEY
entered timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id enteredby integer NOT NULL
lookup_task_priority.code priority integer NOT NULL
description character varying(255)
duedate timestamp(3) without time zone
reminderid integer
notes text
sharing integer NOT NULL
complete boolean NOT NULL DEFAULT false
enabled boolean NOT NULL DEFAULT false
modified timestamp(3) without time zone NOT NULL DEFAULT now()
access.user_id modifiedby integer
estimatedloe double precision
lookup_task_loe.code estimatedloetype integer
type integer DEFAULT 1
access.user_id owner integer
completedate timestamp(3) without time zone
lookup_task_category.code category_id integer
duedate_timezone character varying(255)
trashed_date timestamp(3) without time zone
lookup_ticket_task_category.code ticket_task_category_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: taskcategory_project

taskcategory_project Structure
F-Key Name Type Description
lookup_task_category.code category_id integer NOT NULL
projects.project_id project_id integer NOT NULL

Index - Schema public


Table: taskcategorylink_news

taskcategorylink_news Structure
F-Key Name Type Description
project_news.news_id news_id integer NOT NULL
lookup_task_category.code category_id integer NOT NULL

Index - Schema public


Table: tasklink_contact

tasklink_contact Structure
F-Key Name Type Description
task.task_id task_id integer NOT NULL
contact.contact_id contact_id integer NOT NULL
notes text

Index - Schema public


Table: tasklink_project

tasklink_project Structure
F-Key Name Type Description
task.task_id task_id integer NOT NULL
projects.project_id project_id integer NOT NULL

Index - Schema public


Table: tasklink_ticket

tasklink_ticket Structure
F-Key Name Type Description
task.task_id task_id integer NOT NULL
ticket.ticketid ticket_id integer NOT NULL
lookup_ticket_task_category.code category_id integer

Index - Schema public


Table: ticket

ticket Structure
F-Key Name Type Description
ticketid serial PRIMARY KEY
organization.org_id org_id integer
contact.contact_id contact_id integer
problem text 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
closed timestamp without time zone
ticket_priority.code pri_code integer
ticket_level.code level_code integer
lookup_department.code department_code integer
lookup_ticketsource.code source_code integer
ticket_category.id cat_code integer
ticket_category.id subcat_code1 integer
ticket_category.id subcat_code2 integer
ticket_category.id subcat_code3 integer
access.user_id assigned_to integer
comment text
solution text
ticket_severity.code scode integer
critical timestamp without time zone
notified timestamp without time zone
custom_data text
location character varying(256)
assigned_date timestamp(3) without time zone
est_resolution_date timestamp(3) without time zone
resolution_date timestamp(3) without time zone
cause text
service_contract.contract_id link_contract_id integer
asset.asset_id link_asset_id integer
product_catalog.product_id product_id integer
customer_product.customer_product_id customer_product_id integer
expectation integer
key_count integer
est_resolution_date_timezone character varying(255)
assigned_date_timezone character varying(255)
resolution_date_timezone character varying(255)
lookup_ticket_status.code status_id integer
trashed_date timestamp(3) without time zone
user_group.group_id user_group_id integer
lookup_ticket_cause.code cause_id integer
lookup_ticket_resolution.code resolution_id integer
ticket_defect.defect_id defect_id integer
lookup_ticket_escalation.code escalation_level integer
resolvable boolean NOT NULL DEFAULT true
access.user_id resolvedby integer
lookup_department.code resolvedby_department_code integer
lookup_ticket_state.code state_id integer
lookup_site_id.code site_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: ticket_activity_item

ticket_activity_item Structure
F-Key Name Type Description
item_id serial PRIMARY KEY
ticket_csstm_form.form_id link_form_id integer
activity_date timestamp(3) without time zone
description text
travel_hours integer
travel_minutes integer
labor_hours integer
labor_minutes integer
activity_date_timezone character varying(255)

Index - Schema public


Table: ticket_category

ticket_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: ticket_category_assignment

ticket_category_assignment Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
ticket_category.id category_id integer NOT NULL
lookup_department.code department_id integer
access.user_id assigned_to integer
user_group.group_id group_id integer

Index - Schema public


Table: ticket_category_draft

ticket_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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: ticket_category_draft_assignment

ticket_category_draft_assignment Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
ticket_category_draft.id category_id integer NOT NULL
lookup_department.code department_id integer
access.user_id assigned_to integer
user_group.group_id group_id integer

Index - Schema public


Table: ticket_category_draft_plan_map

ticket_category_draft_plan_map Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
action_plan.plan_id plan_id integer NOT NULL
ticket_category_draft.id category_id integer NOT NULL

Index - Schema public


Table: ticket_category_plan_map

ticket_category_plan_map Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
action_plan.plan_id plan_id integer NOT NULL
ticket_category.id category_id integer NOT NULL

Index - Schema public


Table: ticket_csstm_form

ticket_csstm_form Structure
F-Key Name Type Description
form_id serial PRIMARY KEY
ticket.ticketid link_ticket_id integer
phone_response_time character varying(10)
engineer_response_time character varying(10)
follow_up_required boolean DEFAULT false
follow_up_description character varying(2048)
alert_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
enabled boolean DEFAULT true
travel_towards_sc boolean DEFAULT true
labor_towards_sc boolean DEFAULT true
alert_date_timezone character varying(255)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: ticket_defect

ticket_defect Structure
F-Key Name Type Description
defect_id serial PRIMARY KEY
title character varying(255) NOT NULL
description text
start_date timestamp(3) without time zone NOT NULL DEFAULT now()
end_date timestamp(3) without time zone
enabled boolean NOT NULL DEFAULT true
trashed_date timestamp(3) without time zone
lookup_site_id.code site_id integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: ticket_level

ticket_level 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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: ticket_priority

ticket_priority Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) UNIQUE NOT NULL
style text NOT NULL DEFAULT ''::text
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: ticket_severity

ticket_severity Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) UNIQUE NOT NULL
style text NOT NULL DEFAULT ''::text
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: ticket_sun_form

ticket_sun_form Structure
F-Key Name Type Description
form_id serial PRIMARY KEY
ticket.ticketid link_ticket_id integer
description_of_service 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
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: ticketlink_project

ticketlink_project Structure
F-Key Name Type Description
ticket.ticketid ticket_id integer NOT NULL
projects.project_id project_id integer NOT NULL

Index - Schema public


Table: ticketlog

ticketlog Structure
F-Key Name Type Description
id serial PRIMARY KEY
ticket.ticketid ticketid integer
access.user_id assigned_to integer
comment text
closed boolean
ticket_priority.code pri_code integer
level_code integer
lookup_department.code department_code integer
cat_code integer
ticket_severity.code scode 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_ticket_escalation.code escalation_code integer
lookup_ticket_state.code state_id integer

Index - Schema public


Table: trouble_asset_replacement

trouble_asset_replacement Structure
F-Key Name Type Description
replacement_id serial PRIMARY KEY
ticket_sun_form.form_id link_form_id integer
part_number character varying(256)
part_description text

Index - Schema public


Table: usage_log

usage_log Structure
F-Key Name Type Description
usage_id serial PRIMARY KEY
entered timestamp(6) without time zone NOT NULL DEFAULT now()
enteredby integer
action integer NOT NULL
record_id integer
record_size integer

Index - Schema public


Table: user_group

user_group Structure
F-Key Name Type Description
group_id serial PRIMARY KEY
group_name character varying(255) NOT NULL
description text
enabled boolean NOT NULL DEFAULT true
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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: user_group_map

user_group_map Structure
F-Key Name Type Description
group_map_id serial PRIMARY KEY
access.user_id user_id integer NOT NULL
user_group.group_id group_id integer NOT NULL
level integer NOT NULL DEFAULT 10
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: viewpoint

viewpoint Structure
F-Key Name Type Description
viewpoint_id serial PRIMARY KEY
access.user_id user_id integer NOT NULL
access.user_id vp_user_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 true

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: viewpoint_permission

viewpoint_permission Structure
F-Key Name Type Description
vp_permission_id integer PRIMARY KEY DEFAULT nextval('viewpoint_per_vp_permission_seq'::regclass)
viewpoint.viewpoint_id viewpoint_id integer NOT NULL
permission.permission_id permission_id integer NOT NULL
viewpoint_view boolean NOT NULL DEFAULT false
viewpoint_add boolean NOT NULL DEFAULT false
viewpoint_edit boolean NOT NULL DEFAULT false
viewpoint_delete boolean NOT NULL DEFAULT false

Index - Schema public


Table: webdav

webdav Structure
F-Key Name Type Description
id serial PRIMARY KEY
permission_category.category_id category_id integer NOT NULL
class_name character varying(300) 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

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict