Index of database - connect5 2013-05-17


Table: action_item_wiki

action_item_wiki Structure
F-Key Name Type Description
item_wiki_id bigserial PRIMARY KEY
action_item_work.item_work_id item_work_id bigint NOT NULL
projects.project_id project_id bigint NOT NULL
subject character varying(500) NOT NULL
content text NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
enabled boolean DEFAULT true
aiwiki_item_work_id_idx item_work_id

Index - Schema public


Table: action_item_work

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

Tables referencing this one via Foreign Key Constraints:

aiw_phase_work_id_idx phase_work_id

Index - Schema public


Table: action_item_work_files

action_item_work_files Structure
F-Key Name Type Description
file_id bigserial PRIMARY KEY
action_item_work.item_work_id item_work_id bigint NOT NULL
project_files.item_id file_item_id bigint NOT NULL
submitted timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id submittedby bigint NOT NULL
aiw_files_item_work_id_idx item_work_id

Index - Schema public


Table: action_item_work_notes

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

Index - Schema public


Table: action_phase

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

Tables referencing this one via Foreign Key Constraints:

action_phase_parent_id_idx parent_id action_phase_plan_id_idx plan_id

Index - Schema public


Table: action_phase_work

action_phase_work Structure
F-Key Name Type Description
phase_work_id bigserial PRIMARY KEY
action_plan_work.plan_work_id plan_work_id bigint NOT NULL
action_phase.phase_id action_phase_id bigint 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()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

aphw_plan_work_id_idx plan_work_id

Index - Schema public


Table: action_plan

action_plan Structure
F-Key Name Type Description
plan_id bigserial PRIMARY KEY
lookup_project_category.code category_id bigint
plan_name character varying(255) NOT NULL
description character varying(2048)
enabled boolean NOT NULL DEFAULT true
approved timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
archive_date timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

action_plan_name_idx plan_name

Index - Schema public


Table: action_plan_work

action_plan_work Structure
F-Key Name Type Description
plan_work_id bigserial PRIMARY KEY
action_plan.plan_id action_plan_id bigint NOT NULL
users.user_id assigned_to bigint NOT NULL
lookup_project_category.code category_id bigint
projects.project_id project_id bigint NOT NULL
manager bigint
enabled boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
action_phase.phase_id current_phase bigint

Tables referencing this one via Foreign Key Constraints:

apw_action_plan_id_idx action_plan_id apw_project_id_idx project_id

Index - Schema public


Table: action_plan_work_notes

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

Index - Schema public


Table: action_step

action_step Structure
F-Key Name Type Description
step_id bigserial PRIMARY KEY
action_step.step_id parent_id bigint
action_phase.phase_id phase_id bigint NOT NULL
description character varying(2048)
lookup_task_loe.code duration_type_id bigint
estimated_duration bigint
permission_type bigint
lookup_project_role.code role_id bigint
lookup_project_role.code reviewer_role_id bigint
enabled boolean NOT NULL DEFAULT true
attachment_visible boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()
label character varying(80)
action_id bigint
action_required boolean NOT NULL DEFAULT false
allow_update boolean NOT NULL DEFAULT true
plan_list_label character varying(300)
quick_complete boolean NOT NULL DEFAULT false
modified timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

action_step_parent_id_idx parent_id action_step_phase_id_idx phase_id

Index - Schema public


Table: action_step_wiki_template

action_step_wiki_template Structure
F-Key Name Type Description
template_id bigserial PRIMARY KEY
action_step.step_id step_id bigint NOT NULL
subject character varying(500) NOT NULL
content text NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
enabled boolean DEFAULT true

Index - Schema public


Table: ad

ad Structure
F-Key Name Type Description
ad_id bigserial PRIMARY KEY
lookup_project_category.code project_category_id integer
ad_category.code ad_category_id integer
projects.project_id project_id bigint
heading character varying(255) NOT NULL
content text
web_page character varying(255)
publish_date timestamp(3) without time zone DEFAULT now()
expiration_date timestamp(3) without time zone
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
enabled boolean DEFAULT true
read_count integer NOT NULL
read_date timestamp(3) without time zone
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
brief_description_1 character varying(35)
brief_description_2 character varying(35)
destination_url character varying(1024)

Tables referencing this one via Foreign Key Constraints:

ad_ad_cat_idx ad_category_id ad_prj_cat_idx project_category_id

Index - Schema public


Table: ad_category

ad_category Structure
F-Key Name Type Description
code serial PRIMARY KEY
lookup_project_category.code project_category_id integer
item_name character varying(255) NOT NULL
project_files.item_id logo_id bigint
entered timestamp(3) without time zone DEFAULT now()
level integer NOT NULL
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

ad_cat_prj_cat_idx project_category_id

Index - Schema public


Table: ad_comment

ad_comment Structure
F-Key Name Type Description
comment_id bigserial PRIMARY KEY
ad.ad_id ad_id bigint NOT NULL
comment text NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
closed timestamp(3) without time zone
users.user_id closedby bigint
ad_cmt_idx ad_id

Index - Schema public


Table: ad_rating

ad_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
ad.ad_id ad_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
ad_rtg_idx ad_id

Index - Schema public


View: ad_tag

ad_tag Structure
F-Key Name Type Description
ad_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS ad_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008071715)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: ad_tag_log

ad_tag_log Structure
F-Key Name Type Description
ad_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS ad_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008071715);

Index - Schema public


Table: ad_view

ad_view Structure
F-Key Name Type Description
ad.ad_id ad_id bigint NOT NULL
users.user_id user_id bigint
view_date timestamp(3) without time zone NOT NULL DEFAULT now()
ad_vw_idx ad_id

Index - Schema public


Table: app_client

app_client Structure
F-Key Name Type Description
client_id bigserial PRIMARY KEY
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
modifiedby bigint NOT NULL
enabled boolean DEFAULT true
application_id character varying(255) NOT NULL
application_code character varying(255) UNIQUE NOT NULL
source_profile character varying(255)
sandbox_keystore character varying(255)
sandbox_value character varying(1024)
production_keystore character varying(255)
production_value character varying(1024)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: badge

badge Structure
F-Key Name Type Description
badge_id bigserial PRIMARY KEY
badge_category.code badge_category_id integer
title character varying(255) NOT NULL
description text
project_files.item_id logo_id bigint
email1 character varying(255)
email2 character varying(255)
email3 character varying(255)
business_phone character varying(30)
business_phone_ext character varying(30)
web_page character varying(255)
addrline1 character varying(255)
addrline2 character varying(255)
addrline3 character varying(255)
city character varying(255)
state character varying(255)
country character varying(255)
postalcode character varying(255)
latitude double precision
longitude double precision
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
enabled boolean DEFAULT true
read_count integer NOT NULL
read_date timestamp(3) without time zone
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
system_assigned boolean DEFAULT false
system_constant integer

Tables referencing this one via Foreign Key Constraints:

badge_bad_cat_idx badge_category_id

Index - Schema public


Table: badge_category

badge_category Structure
F-Key Name Type Description
code serial PRIMARY KEY
lookup_project_category.code project_category_id integer
item_name character varying(255) NOT NULL
project_files.item_id logo_id bigint
entered timestamp(3) without time zone DEFAULT now()
level integer NOT NULL
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

badge_cat_prj_cat_idx project_category_id

Index - Schema public


Table: badge_comment

badge_comment Structure
F-Key Name Type Description
comment_id bigserial PRIMARY KEY
badge.badge_id badge_id bigint NOT NULL
comment text NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
closed timestamp(3) without time zone
users.user_id closedby bigint
badge_cmt_idx badge_id

Index - Schema public


Table: badge_rating

badge_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
badge.badge_id badge_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
badge_rtg_idx badge_id

Index - Schema public


View: badge_tag

badge_tag Structure
F-Key Name Type Description
badge_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS badge_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008051215)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: badge_tag_log

badge_tag_log Structure
F-Key Name Type Description
badge_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS badge_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008051215);

Index - Schema public


Table: badge_view

badge_view Structure
F-Key Name Type Description
badge.badge_id badge_id bigint NOT NULL
users.user_id user_id bigint
view_date timestamp(3) without time zone NOT NULL DEFAULT now()
badge_vw_idx badge_id

Index - Schema public


Table: badgelink_project

badgelink_project Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
badge.badge_id badge_id bigint NOT NULL
projects.project_id project_id bigint NOT NULL
entered timestamp(3) without time zone DEFAULT now()
badgelink_project_idx badge_id badgelink_project_prj_idx project_id

Index - Schema public


Table: catalog_category

catalog_category Structure
F-Key Name Type Description
category_id bigserial PRIMARY KEY
catalog_category.category_id parent_id bigint
category_name character varying(255) NOT NULL
abbreviation character varying(30)
short_description text
long_description text
project_files.item_id small_image_id bigint
project_files.item_id large_image_id bigint
list_order integer DEFAULT 10
users.user_id enteredby bigint NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint 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: catalog_option

catalog_option Structure
F-Key Name Type Description
option_id bigserial PRIMARY KEY
option_name character varying(255) NOT NULL
option_type integer NOT NULL
default_value character varying(255)
enabled boolean DEFAULT false
additional_text character varying(255)
validation_script text
option_sku_modifier character varying(255)
level integer
option_text text
uses_base_price boolean DEFAULT false
required boolean NOT NULL DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: catalog_option_price

catalog_option_price Structure
F-Key Name Type Description
price_id bigserial PRIMARY KEY
catalog_option.option_id option_id bigint NOT NULL
description character varying(255)
range_low integer
range_high integer
catalog_option_value.value_id value_id bigint
enabled boolean DEFAULT false
invalid boolean DEFAULT false
price_amount double precision
price_per_qty double precision
price_multiplier double precision
price_qty_multiplier boolean DEFAULT false
price_add_on double precision
range_block integer
invoice_text character varying(255)

Index - Schema public


Table: catalog_option_value

catalog_option_value Structure
F-Key Name Type Description
value_id bigserial PRIMARY KEY
catalog_option.option_id option_id bigint NOT NULL
description character varying(255) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: catalog_product

catalog_product Structure
F-Key Name Type Description
product_id bigserial PRIMARY KEY
product_name character varying(255) NOT NULL
details text
base_price double precision NOT NULL
small_image character varying(255)
large_image character varying(255)
enabled boolean DEFAULT false
billing_address_required boolean DEFAULT false
shipping_address_required boolean DEFAULT false
payment_required boolean DEFAULT false
contact_information_required boolean DEFAULT false
catalog_product.product_id parent_id bigint
order_description character varying(1024)
users.user_id enteredby bigint NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint 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
project_files.item_id small_image_id bigint
project_files.item_id large_image_id bigint
product_sku character varying(255)
show_in_catalog boolean NOT NULL DEFAULT true
cart_enabled boolean NOT NULL DEFAULT true
action_text character varying(25)
shipping_cost boolean DEFAULT false
shipping_type character varying(255)
shipping_value character varying(255)
taxable boolean DEFAULT false
tax_type character varying(255)
recurring boolean DEFAULT false
login_required boolean DEFAULT false
projects.project_id project_id bigint
recurring_type character varying(10)
recurring_interval integer
recurring_start_type character varying(10)
recurring_start_interval integer
recurring_total_occurrences integer
standalone boolean NOT NULL DEFAULT false
inventory_enabled boolean NOT NULL DEFAULT false
inventory bigint
price_description text NOT NULL
expire_immediately boolean DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: catalog_product_attachments

catalog_product_attachments Structure
F-Key Name Type Description
attachment_id bigserial PRIMARY KEY
catalog_product.product_id product_id bigint NOT NULL
project_files.item_id file_id bigint NOT NULL
allow_before_checkout boolean NOT NULL DEFAULT false
allow_after_checkout boolean NOT NULL DEFAULT false
send_as_email boolean NOT NULL DEFAULT false
days_allowed integer NOT NULL
hours_allowed integer NOT NULL DEFAULT 1

Index - Schema public


Table: catalog_product_config

catalog_product_config Structure
F-Key Name Type Description
config_id bigserial PRIMARY KEY
catalog_product.product_id product_id bigint NOT NULL
catalog_option.option_id option_id bigint NOT NULL

Index - Schema public


Table: classified_category

classified_category Structure
F-Key Name Type Description
code serial PRIMARY KEY
lookup_project_category.code project_category_id integer
item_name character varying(255) NOT NULL
project_files.item_id logo_id bigint
entered timestamp(3) without time zone DEFAULT now()
level integer NOT NULL
enabled boolean DEFAULT true

Tables referencing this one via Foreign Key Constraints:

classified_cat_prj_cat_idx project_category_id

Index - Schema public


Table: contact_us

contact_us Structure
F-Key Name Type Description
request_id bigserial PRIMARY KEY
first_name character varying(50) NOT NULL
last_name character varying(50) NOT NULL
email character varying(255) NOT NULL
organization character varying(100)
description text NOT NULL
copied boolean NOT NULL DEFAULT false
browser character varying(255)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint
replied timestamp(3) without time zone
users.user_id repliedby bigint
language character varying(255)
ip_address character varying(40) NOT NULL
job_title character varying(255)
business_phone character varying(30)
business_phone_ext character varying(30)
addrline1 character varying(255)
addrline2 character varying(255)
addrline3 character varying(255)
city character varying(255)
state character varying(255)
country character varying(255)
postalcode character varying(255)
form_data text
instances.instance_id instance_id integer

Index - Schema public


Table: contacts

contacts Structure
F-Key Name Type Description
contact_id bigserial PRIMARY KEY
is_organization boolean NOT NULL DEFAULT false
salutation character varying(80)
first_name character varying(80)
middle_name character varying(80)
last_name character varying(80)
suffix_name character varying(80)
organization character varying(255)
file_as character varying(512)
job_title character varying(255)
role character varying(255)
email1 character varying(255)
email2 character varying(255)
email3 character varying(255)
home_phone character varying(30)
home_phone_ext character varying(30)
home2_phone character varying(30)
home2_phone_ext character varying(30)
home_fax character varying(30)
business_phone character varying(30)
business_phone_ext character varying(30)
business2_phone character varying(30)
business2_phone_ext character varying(30)
business_fax character varying(30)
mobile_phone character varying(30)
pager_number character varying(30)
car_phone character varying(30)
radio_phone character varying(30)
web_page character varying(255)
nickname character varying(80)
comments text
users.user_id owner bigint
global boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
addrline1 character varying(255)
addrline2 character varying(255)
addrline3 character varying(255)
city character varying(255)
state character varying(255)
country character varying(255)
postalcode character varying(12)
latitude double precision
longitude double precision

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: contacts_share

contacts_share Structure
F-Key Name Type Description
share_id bigserial PRIMARY KEY
contacts.contact_id contact_id bigint
users.user_id shared_from bigint
users.user_id shared_to bigint
allow_edit boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone DEFAULT now()
modified timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: customer_order

customer_order Structure
F-Key Name Type Description
order_id bigserial PRIMARY KEY
entered timestamp(3) without time zone NOT NULL DEFAULT now()
ipaddress character varying(30)
browser character varying(300)
total_price double precision
processed timestamp(3) without time zone
users.user_id order_by bigint
items_cost double precision
shipping_cost double precision
tax_cost double precision
recurring_payment boolean DEFAULT false
canceled timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: customer_order_address

customer_order_address Structure
F-Key Name Type Description
address_id bigserial PRIMARY KEY
customer_order.order_id order_id bigint NOT NULL
address_type character varying(255) NOT NULL
namefirst character varying(255)
namelast character varying(255)
organization character varying(255)
title character varying(255)
addressline1 character varying(255)
addressline2 character varying(255)
addressline3 character varying(255)
city character varying(255)
state character varying(255)
postal_code character varying(255)
country character varying(255)
phone_number character varying(30)
phone_extension character varying(10)
fax_number character varying(30)
email character varying(256)
primary_address boolean DEFAULT false

Index - Schema public


Table: customer_order_payment

customer_order_payment Structure
F-Key Name Type Description
payment_id bigserial PRIMARY KEY
customer_order.order_id order_id bigint NOT NULL
payment_type character varying(255) NOT NULL
credit_card_type character varying(255)
credit_card_number character varying(255)
processed timestamp(3) without time zone
charge_amount double precision
credit_card_exp_month character varying(255)
credit_card_exp_year character varying(255)
credit_card_ccv character varying(255)
agent_name character varying(255)
agent_type character varying(255)

Index - Schema public


Table: customer_order_product

customer_order_product Structure
F-Key Name Type Description
item_id bigserial PRIMARY KEY
customer_order.order_id order_id bigint NOT NULL
catalog_product.product_id product_id bigint NOT NULL
projects.project_id project_id bigint
product_name character varying(255) NOT NULL
total_price double precision
recurring boolean DEFAULT false
recurring_type character varying(10)
recurring_interval integer
recurring_start_type character varying(10)
recurring_start_interval integer
recurring_total_occurrences integer
price_description text NOT NULL
subscription_id character varying(255)
canceled timestamp(3) without time zone
test_mode boolean DEFAULT false
subscription_start_date timestamp(3) without time zone
subscription_expires_on timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: customer_order_product_options

customer_order_product_options Structure
F-Key Name Type Description
item_option_id bigserial PRIMARY KEY
customer_order_product.item_id item_id bigint NOT NULL
catalog_option.option_id option_id bigint NOT NULL
option_name character varying(255) NOT NULL
option_value character varying(255)
price_amount double precision

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


View: decision_count_view

decision_count_view Structure
F-Key Name Type Description
app_name character varying(255)
project_id bigint
parameter character varying(255)
vote_count bigint
SELECT decision_log.app_name
, decision_log.project_id
, decision_log.parameter
, count
(*) AS vote_count 
FROM decision_log 
GROUP BY decision_log.app_name
, decision_log.project_id
, decision_log.parameter;

Index - Schema public


Table: decision_log

decision_log Structure
F-Key Name Type Description
app_name character varying(255) NOT NULL
projects.project_id project_id bigint
users.user_id user_id bigint
projects.project_id profile_project_id bigint
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
entry integer DEFAULT 1
parameter character varying(255) NOT NULL
parameter_value character varying(1024) NOT NULL
dec_log_app_idx app_name dec_log_prj_idx project_id dec_log_pro_idx profile_project_id dec_log_que_idx parameter dec_log_usr_idx user_id

Index - Schema public


View: decision_value_view

decision_value_view Structure
F-Key Name Type Description
app_name character varying(255)
project_id bigint
parameter character varying(255)
parameter_value character varying(1024)
value_count bigint
SELECT decision_log.app_name
, decision_log.project_id
, decision_log.parameter
, decision_log.parameter_value
, count
(*) AS value_count 
FROM decision_log 
GROUP BY decision_log.app_name
, decision_log.project_id
, decision_log.parameter
, decision_log.parameter_value;

Index - Schema public


Table: departments

departments Structure
F-Key Name Type Description
code serial PRIMARY KEY
groups.group_id group_id integer NOT NULL
description character varying(100) NOT NULL
default_item boolean DEFAULT false
level integer
enabled boolean NOT NULL DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: device

device Structure
F-Key Name Type Description
device_id bigserial PRIMARY KEY
app_client.client_id app_client_id bigint NOT NULL
is_production boolean DEFAULT true
device_type character varying(12) NOT NULL
device_platform character varying(100)
device_model character varying(100)
device_token character varying(128) NOT NULL
users.user_id user_id bigint
user_id_date timestamp(3) without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean DEFAULT true
processed timestamp(3) without time zone
notification_type character varying(255)
notify_news boolean DEFAULT true
notify_activity boolean DEFAULT true
notify_challenges boolean DEFAULT true

Index - Schema public


Table: email_interest

email_interest Structure
F-Key Name Type Description
request_id bigserial PRIMARY KEY
first_name character varying(50)
last_name character varying(50)
email character varying(255) NOT NULL
organization character varying(100)
browser character varying(255)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint
ip_address character varying(40) NOT NULL
instances.instance_id instance_id integer

Index - Schema public


Table: email_updates_queue

email_updates_queue Structure
F-Key Name Type Description
queue_id bigserial PRIMARY KEY
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
enabled boolean NOT NULL DEFAULT true
schedule_often boolean NOT NULL DEFAULT false
schedule_daily boolean NOT NULL DEFAULT false
schedule_weekly boolean NOT NULL DEFAULT false
schedule_monthly boolean NOT NULL DEFAULT false
schedule_monday boolean NOT NULL DEFAULT false
schedule_tuesday boolean NOT NULL DEFAULT false
schedule_wednesday boolean NOT NULL DEFAULT false
schedule_thursday boolean NOT NULL DEFAULT false
schedule_friday boolean NOT NULL DEFAULT false
schedule_saturday boolean NOT NULL DEFAULT false
schedule_sunday boolean NOT NULL DEFAULT false
schedule_time timestamp(3) without time zone
status integer NOT NULL
processed timestamp(3) without time zone DEFAULT NULL::timestamp without time zone

Index - Schema public


Table: groups

groups Structure
F-Key Name Type Description
group_id serial PRIMARY KEY
group_name character varying(50) NOT NULL
enabled boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone DEFAULT now()
modified timestamp(3) without time zone DEFAULT now()
expiration timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
account_size integer

Tables referencing this one via Foreign Key Constraints:

groups_idx group_id

Index - Schema public


Table: instances

instances Structure
F-Key Name Type Description
instance_id serial PRIMARY KEY
domain_name character varying(255) NOT NULL
context character varying(255) NOT NULL DEFAULT '/'::character varying
enabled boolean NOT NULL DEFAULT false
title character varying(255) NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: language_config

language_config Structure
F-Key Name Type Description
id serial PRIMARY KEY
language_pack.id language_id integer
config_name character varying(300)

Tables referencing this one via Foreign Key Constraints:

lang_conf_lang_idx language_id

Index - Schema public


Table: language_dictionary

language_dictionary Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
language_config.id config_id integer
param_name character varying(300) NOT NULL
param_value1 text
param_value2 text
approved integer NOT NULL DEFAULT (-1)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone
users.user_id modifiedby bigint
changed boolean DEFAULT false
lang_dic_conf_idx config_id lang_dic_parmv_idx param_value1

Index - Schema public


Table: language_pack

language_pack Structure
F-Key Name Type Description
id serial PRIMARY KEY
language_name character varying(200) NOT NULL
language_locale character varying(12)
users.user_id maintainer_id bigint
entered timestamp(3) without time zone NOT NULL DEFAULT now()
percent_complete integer NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: language_team

language_team Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
users.user_id member_id bigint NOT NULL
language_pack.id language_pack_id integer NOT NULL
allow_translate boolean NOT NULL DEFAULT false
allow_review boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()

Index - Schema public


Table: lookup_authentication_classes

lookup_authentication_classes Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
login_mode character varying(300)
login_authenticator character varying(300)
session_validator character varying(300)
enabled boolean DEFAULT false
entered timestamp(3) without time zone DEFAULT now()
modified timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: lookup_contribution

lookup_contribution Structure
F-Key Name Type Description
code serial PRIMARY KEY
constant character varying(255) NOT NULL
description character varying(300) NOT NULL
level integer
enabled boolean DEFAULT true
run_date timestamp(3) without time zone
points_awarded integer NOT NULL DEFAULT 1

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: lookup_meeting_category

lookup_meeting_category Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_name character varying(255)
entered timestamp(3) without time zone DEFAULT now()
level integer NOT NULL
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_number

lookup_number Structure
F-Key Name Type Description
id integer NOT NULL

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_assignment_role

lookup_project_assignment_role Structure
F-Key Name Type Description
code integer PRIMARY KEY DEFAULT nextval('lookup_project_ass_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_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
logo_id integer
map_marker_id integer
parent_category integer
style text
style_enabled boolean DEFAULT false
is_sensitive boolean DEFAULT false
label character varying(80) NOT NULL
hidden boolean DEFAULT false

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: lookup_project_language

lookup_project_language Structure
F-Key Name Type Description
id serial PRIMARY KEY
language_name character varying(200) NOT NULL
language_locale character varying(12)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enabled boolean NOT NULL DEFAULT true
default_item boolean NOT NULL DEFAULT false

Tables referencing this one via Foreign Key Constraints:

look_proj_lang_lan_lo language_locale look_proj_lang_lan_nm language_name

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:

lu_project_perm_perm_idx permission

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_portlet

lookup_project_portlet Structure
F-Key Name Type Description
portlet_id serial PRIMARY KEY
portlet_name character varying(255)
portlet_description character varying(1024)
portal_enabled boolean NOT NULL DEFAULT false
project_enabled boolean NOT NULL DEFAULT false
admin_enabled boolean NOT NULL DEFAULT false
enabled boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: lookup_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_service

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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: lookup_step_actions

lookup_step_actions Structure
F-Key Name Type Description
code bigint PRIMARY KEY DEFAULT nextval('lookup_step_actions_code_seq'::regclass)
description character varying(300) NOT NULL
default_item boolean DEFAULT false
level bigint
enabled boolean DEFAULT true
constant_id bigint 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: lookup_task_assigned_priority

lookup_task_assigned_priority Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: lookup_task_assigned_to

lookup_task_assigned_to Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
users.user_id user_id bigint NOT NULL
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: 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_complexity

lookup_task_complexity Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: lookup_task_functional_area

lookup_task_functional_area Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: 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_loe_remaining

lookup_task_loe_remaining Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: 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_task_release

lookup_task_release Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: lookup_task_sprint

lookup_task_sprint Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: lookup_task_status

lookup_task_status Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: lookup_task_value

lookup_task_value Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: 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_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
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
gender character varying(1)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: lookup_wiki_categories

lookup_wiki_categories Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: lookup_wiki_state

lookup_wiki_state Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: process_log

process_log Structure
F-Key Name Type Description
code serial PRIMARY KEY
description character varying(300) NOT NULL
long_value bigint
enabled boolean DEFAULT true
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
processed timestamp(3) without time zone

Index - Schema public


Table: product_catalog_category_map

product_catalog_category_map Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
catalog_product.product_id product_id bigint NOT NULL
catalog_category.category_id category_id bigint NOT NULL

Index - Schema public


Table: product_category_map

product_category_map Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
catalog_category.category_id category1_id bigint NOT NULL
catalog_category.category_id category2_id bigint NOT NULL

Index - Schema public


Table: project_assignments

project_assignments Structure
F-Key Name Type Description
assignment_id bigint PRIMARY KEY DEFAULT nextval('project_assig_assignment_id_seq'::regclass)
projects.project_id project_id bigint NOT NULL
project_requirements.requirement_id requirement_id bigint
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
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()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
project_assignments_folder.folder_id folder_id bigint
percent_complete integer
responsible character varying(255)
lookup_task_category.code task_category_id bigint
lookup_task_release.code task_release_id bigint
lookup_task_functional_area.code task_funct_area_id bigint
remaining_loevalue integer
lookup_project_loe.code remaining_loetype integer

Tables referencing this one via Foreign Key Constraints:

proj_assign_cdate_idx complete_date proj_assign_req_id_idx requirement_id

Index - Schema public


Table: project_assignments_folder

project_assignments_folder Structure
F-Key Name Type Description
folder_id bigint PRIMARY KEY DEFAULT nextval('project_assignmen_folder_id_seq'::regclass)
project_assignments_folder.folder_id parent_id bigint
project_requirements.requirement_id requirement_id bigint NOT NULL
name character varying(255) NOT NULL
description text
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint 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 bigint PRIMARY KEY DEFAULT nextval('project_assignmen_status_id_seq'::regclass)
project_assignments.assignment_id assignment_id bigint NOT NULL
users.user_id user_id bigint 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
users.user_id user_assign_id bigint

Index - Schema public


Table: project_assignments_user

project_assignments_user Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
project_assignments.assignment_id assignment_id bigint NOT NULL
users.user_id user_id bigint NOT NULL
lookup_project_assignment_role.code assignment_role_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
proj_assign_usr_aid_idx assignment_id proj_assign_usr_usr_idx user_id

Index - Schema public


Table: project_calendar_meeting

project_calendar_meeting Structure
F-Key Name Type Description
meeting_id bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
users.user_id owner bigint NOT NULL
title character varying(255) NOT NULL
location character varying(255)
start_date timestamp(3) without time zone
end_date timestamp(3) without time zone
is_tentative boolean DEFAULT false
by_invitation_only boolean NOT NULL DEFAULT false
description text
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer NOT NULL
is_dimdim boolean DEFAULT false
dimdim_url character varying(255)
dimdim_meetingid character varying(255)
dimdim_username character varying(255)
dimdim_password character varying(255)
dimdim_meeting_key character varying(255)
is_webcast boolean DEFAULT false
is_vivu boolean DEFAULT false
vivu_url character varying(255)
vivu_meetingid character varying(255)
vivu_username character varying(255)
vivu_password character varying(255)
vivu_presenter_url character varying(255)
vivu_participant_url character varying(255)
is_profile_default boolean NOT NULL DEFAULT false
is_sub_event boolean NOT NULL DEFAULT false
details_url character varying(255)
registration_url character varying(255)
tickets_url character varying(255)
category_id integer
addrline1 character varying(255)
addrline2 character varying(255)
addrline3 character varying(255)
city character varying(255)
state character varying(255)
country character varying(255)
postalcode character varying(255)
latitude double precision
longitude double precision

Tables referencing this one via Foreign Key Constraints:

project_cal_mtg_edidx end_date project_cal_mtg_idx project_id project_cal_mtg_sdidx start_date

Index - Schema public


Table: project_calendar_meeting_attendees

project_calendar_meeting_attendees Structure
F-Key Name Type Description
attendee_id serial PRIMARY KEY
project_calendar_meeting.meeting_id meeting_id bigint NOT NULL
users.user_id user_id bigint NOT NULL
is_tentative boolean DEFAULT false
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
dimdim_status integer
project_cal_mtg_att_att_idx user_id project_cal_mtg_att_idx meeting_id

Index - Schema public


Table: project_calendar_meeting_rating

project_calendar_meeting_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_calendar_meeting.meeting_id meeting_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_cal_mtg_cmt_rtg_idx meeting_id

Index - Schema public


View: project_calendar_meeting_tag

project_calendar_meeting_tag Structure
F-Key Name Type Description
meeting_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS meeting_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2009021619)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: project_calendar_meeting_tag_log

project_calendar_meeting_tag_log Structure
F-Key Name Type Description
meeting_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS meeting_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2009021619);

Index - Schema public


Table: project_checkin

project_checkin Structure
F-Key Name Type Description
checkin_id bigserial PRIMARY KEY
latitude double precision
longitude double precision
altitude double precision
speed double precision
heading double precision
projects.project_id project_id bigint
location character varying(255)
addrline1 character varying(255)
addrline2 character varying(255)
addrline3 character varying(255)
city character varying(255)
state character varying(255)
country character varying(255)
postalcode character varying(255)
message character varying(1024)
project_files.item_id file_item_id bigint
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
projects_ckin_idx project_id projects_ckin_usr_idx enteredby

Index - Schema public


Table: project_classified

project_classified Structure
F-Key Name Type Description
classified_id bigserial PRIMARY KEY
lookup_project_category.code project_category_id integer
classified_category.code classified_category_id integer
projects.project_id project_id bigint NOT NULL
title character varying(255) NOT NULL
description text
amount double precision
amount_currency character varying(5)
publish_date timestamp(3) without time zone DEFAULT now()
expiration_date timestamp(3) without time zone
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
enabled boolean DEFAULT true
read_count integer NOT NULL
read_date timestamp(3) without time zone
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL

Tables referencing this one via Foreign Key Constraints:

project_classified_cat_idx classified_category_id project_classified_prj_cat_idx project_category_id project_classified_prj_idx project_id

Index - Schema public


Table: project_classified_comment

project_classified_comment Structure
F-Key Name Type Description
comment_id bigserial PRIMARY KEY
project_classified.classified_id classified_id bigint NOT NULL
comment text NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
closed timestamp(3) without time zone
users.user_id closedby bigint
project_classified_cmt_idx classified_id

Index - Schema public


Table: project_classified_rating

project_classified_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_classified.classified_id classified_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
project_classified_rtg_idx classified_id

Index - Schema public


Table: project_classified_response

project_classified_response Structure
F-Key Name Type Description
response_id bigserial PRIMARY KEY
project_classified.classified_id classified_id bigint NOT NULL
projects.project_id from_project_id bigint NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL

Index - Schema public


View: project_classified_tag

project_classified_tag Structure
F-Key Name Type Description
classified_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS classified_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008071716)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: project_classified_tag_log

project_classified_tag_log Structure
F-Key Name Type Description
classified_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS classified_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008071716);

Index - Schema public


Table: project_classified_view

project_classified_view Structure
F-Key Name Type Description
project_classified.classified_id classified_id bigint NOT NULL
users.user_id user_id bigint
view_date timestamp(3) without time zone NOT NULL DEFAULT now()
project_classified_vw_idx classified_id

Index - Schema public


Table: project_dashboard

project_dashboard Structure
F-Key Name Type Description
dashboard_id bigserial PRIMARY KEY
dashboard_name character varying(255)
dashboard_level integer NOT NULL DEFAULT 1
projects.project_id project_id bigint
portal boolean NOT NULL DEFAULT false
enabled boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

proj_dashboard_proj_idx project_id

Index - Schema public


Table: project_dashboard_page

project_dashboard_page Structure
F-Key Name Type Description
page_id bigserial PRIMARY KEY
project_dashboard.dashboard_id dashboard_id bigint NOT NULL
page_name character varying(255)
page_level integer NOT NULL DEFAULT 1
project_dashboard_page.page_id page_alias integer
page_design text
enabled boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_dashboard_portlet

project_dashboard_portlet Structure
F-Key Name Type Description
page_portlet_id bigserial PRIMARY KEY
project_dashboard_page.page_id page_id bigint NOT NULL
lookup_project_portlet.portlet_id portlet_id bigint NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

proj_dsh_page_prt_pg_idx page_id

Index - Schema public


Table: project_dashboard_portlet_prefs

project_dashboard_portlet_prefs Structure
F-Key Name Type Description
preference_id bigserial PRIMARY KEY
project_dashboard_portlet.page_portlet_id page_portlet_id bigint NOT NULL
property_name character varying(1024)
property_value text
entered timestamp(3) without time zone NOT NULL DEFAULT now()
modified timestamp(3) without time zone NOT NULL DEFAULT now()
proj_dsh_pref_pg_prt_idx page_portlet_id

Index - Schema public


Table: project_discussion_forum_template

project_discussion_forum_template Structure
F-Key Name Type Description
template_id bigserial PRIMARY KEY
lookup_project_category.code project_category_id integer
forum_names text NOT NULL
enabled boolean DEFAULT true
entered timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: project_document_folder_template

project_document_folder_template Structure
F-Key Name Type Description
template_id bigserial PRIMARY KEY
lookup_project_category.code project_category_id integer
folder_names text NOT NULL
enabled boolean DEFAULT true
entered timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: project_featured_listing

project_featured_listing Structure
F-Key Name Type Description
featured_id serial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
portlet_key character varying(255)
featured_date timestamp(3) without time zone

Index - Schema public


Table: project_feed

project_feed Structure
F-Key Name Type Description
feed_id bigserial PRIMARY KEY
projects.project_id project_id bigint
feed_url text
feed_name character varying(255) NOT NULL
feed_description text
import_title boolean DEFAULT true
import_description boolean DEFAULT true
import_author_info boolean DEFAULT true
show_original_link boolean DEFAULT true
processed_on timestamp(3) without time zone
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
enabled boolean DEFAULT true
status integer NOT NULL
schedule_time timestamp(3) without time zone
feed_entry_type integer

Tables referencing this one via Foreign Key Constraints:

project_feed_idx feed_id

Index - Schema public


Table: project_feed_entry

project_feed_entry Structure
F-Key Name Type Description
entry_id bigserial PRIMARY KEY
project_feed.feed_id feed_id bigint NOT NULL
projects.project_id project_id bigint NOT NULL
feed_entry_url text
title character varying(255)
description text
author_name character varying(255)
publish_date timestamp(3) without time zone DEFAULT now()
new_entry boolean DEFAULT true
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

project_feed_entry_idx entry_id

Index - Schema public


Table: project_feed_readby

project_feed_readby Structure
F-Key Name Type Description
read_id bigserial PRIMARY KEY
project_feed_entry.entry_id entry_id bigint NOT NULL
users.user_id read_by bigint NOT NULL
read_on timestamp(3) without time zone DEFAULT now()
project_feed_readby_idx read_id

Index - Schema public


Table: project_files

project_files Structure
F-Key Name Type Description
item_id bigserial PRIMARY KEY
link_module_id integer NOT NULL
link_item_id bigint NOT NULL
project_folders.folder_id folder_id bigint
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()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
default_file boolean DEFAULT false
image_width integer NOT NULL
image_height integer NOT NULL
comment character varying(500)
featured_file boolean DEFAULT false
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer NOT NULL
source_project_id bigint
comments_count integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

project_files_cidx link_module_id, link_item_id project_files_liid link_item_id project_files_lmid link_module_id project_files_mod modified project_files_src source_project_id project_files_usr enteredby

Index - Schema public


Table: project_files_comment

project_files_comment Structure
F-Key Name Type Description
comment_id bigserial PRIMARY KEY
project_files.item_id item_id bigint NOT NULL
comment text NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
closed timestamp(3) without time zone
users.user_id closedby bigint
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer

Tables referencing this one via Foreign Key Constraints:

project_files_cmt_idx item_id

Index - Schema public


Table: project_files_comment_rating

project_files_comment_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_files_comment.comment_id comment_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_files_cmt_rtg_idx comment_id

Index - Schema public


Table: project_files_download

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

Index - Schema public


Table: project_files_rating

project_files_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_files.item_id item_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_files_rtg_idx item_id

Index - Schema public


View: project_files_tag

project_files_tag Structure
F-Key Name Type Description
item_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS item_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 1)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: project_files_tag_log

project_files_tag_log Structure
F-Key Name Type Description
item_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS item_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 1);

Index - Schema public


Table: project_files_thumbnail

project_files_thumbnail Structure
F-Key Name Type Description
project_files.item_id item_id bigint
filename character varying(255) NOT NULL
size integer
version double precision
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
image_width integer NOT NULL
image_height integer NOT NULL
format character varying(5)
prj_files_thm_itid item_id

Index - Schema public


Table: project_files_version

project_files_version Structure
F-Key Name Type Description
project_files.item_id item_id bigint
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()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
image_width integer NOT NULL
image_height integer NOT NULL
comment character varying(500)

Index - Schema public


Table: project_folders

project_folders Structure
F-Key Name Type Description
folder_id bigserial PRIMARY KEY
link_module_id integer NOT NULL
link_item_id bigint NOT NULL
subject character varying(255) NOT NULL
description text
parent_id integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
display integer

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_history

project_history Structure
F-Key Name Type Description
history_id bigserial PRIMARY KEY
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
link_object character varying(255) NOT NULL
link_item_id bigint
link_start_date timestamp(3) without time zone NOT NULL DEFAULT now()
description character varying(1024)
enabled boolean DEFAULT true
event_type integer
project_history.history_id parent_id bigint
project_history.history_id top_id bigint
position integer
thread_position integer
indent integer
child_count integer
relative_date timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id relative_enteredby bigint NOT NULL
lineage text
latitude double precision
longitude double precision

Tables referencing this one via Foreign Key Constraints:

projects_hist_lin_idx lineage projects_hist_obj_idx link_object projects_hist_pos_idx "position" projects_hist_prj_idx project_id projects_hist_rdt_idx relative_date projects_hist_reb_idx relative_enteredby projects_hist_sdt_idx link_start_date projects_hist_top_idx top_id

Index - Schema public


Table: project_issue_category_moderator

project_issue_category_moderator Structure
F-Key Name Type Description
moderator_id bigserial PRIMARY KEY
project_issues_categories.category_id issue_category_id bigint
users.user_id user_id bigint NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
project_issue_cat_mod_cid_idx issue_category_id

Index - Schema public


Table: project_issue_replies

project_issue_replies Structure
F-Key Name Type Description
reply_id bigint PRIMARY KEY DEFAULT nextval('project_issue_repl_reply_id_seq'::regclass)
project_issues.issue_id issue_id bigint 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()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
helpful boolean NOT NULL DEFAULT false
solution boolean NOT NULL DEFAULT false
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer NOT NULL
solution_date timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_issue_replies_rating

project_issue_replies_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_issue_replies.reply_id reply_id bigint NOT NULL
rating integer NOT NULL
inappropriate boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
project_iss_repl_rtg_idx reply_id project_iss_repl_rtg_rtg_idx rating

Index - Schema public


View: project_issue_replies_tag

project_issue_replies_tag Structure
F-Key Name Type Description
reply_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS reply_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 20050201)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: project_issue_replies_tag_log

project_issue_replies_tag_log Structure
F-Key Name Type Description
reply_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS reply_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 20050201);

Index - Schema public


Table: project_issues

project_issues Structure
F-Key Name Type Description
issue_id bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
project_issues_categories.category_id category_id bigint
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()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
reply_count integer NOT NULL
last_reply_date timestamp(3) without time zone NOT NULL DEFAULT now()
last_reply_by integer
question boolean NOT NULL DEFAULT false
view_count integer NOT NULL
project_issue_replies.reply_id solution_reply_id integer
read_count integer NOT NULL
read_date timestamp(3) without time zone
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer
locked boolean NOT NULL DEFAULT false
locked_date timestamp(3) without time zone
users.user_id lockedby bigint
priority_id integer NOT NULL DEFAULT 10

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 bigint PRIMARY KEY DEFAULT nextval('project_issue_cate_categ_id_seq'::regclass)
projects.project_id project_id bigint 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()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint 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
read_count integer NOT NULL
read_date timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_issues_rating

project_issues_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_issues.issue_id issue_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_issues_rtg_idx issue_id

Index - Schema public


View: project_issues_tag

project_issues_tag Structure
F-Key Name Type Description
issue_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS issue_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2005020616)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: project_issues_tag_log

project_issues_tag_log Structure
F-Key Name Type Description
issue_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS issue_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2005020616);

Index - Schema public


Table: project_issues_view

project_issues_view Structure
F-Key Name Type Description
project_issues.issue_id issue_id bigint NOT NULL
users.user_id user_id bigint
view_date timestamp(3) without time zone NOT NULL DEFAULT now()
project_issue_vw_idx issue_id

Index - Schema public


Table: project_language_team

project_language_team Structure
F-Key Name Type Description
id serial PRIMARY KEY
users.user_id member_id bigint NOT NULL
lookup_project_language.id language_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
proj_lan_team_lan_id language_id proj_lan_team_mem_id member_id

Index - Schema public


Table: project_list_template

project_list_template Structure
F-Key Name Type Description
template_id bigserial PRIMARY KEY
lookup_project_category.code project_category_id integer
list_names text NOT NULL
enabled boolean DEFAULT true
entered timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: project_message

project_message Structure
F-Key Name Type Description
message_id bigserial PRIMARY KEY
subject character varying(255) NOT NULL
body text
projects.project_id project_id bigint NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_message_template

project_message_template Structure
F-Key Name Type Description
template_id bigserial PRIMARY KEY
lookup_project_category.code project_category_id integer
title character varying(255) NOT NULL
subject character varying(255) NOT NULL
content text NOT NULL
level integer NOT NULL
enabled boolean DEFAULT true
entered timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: project_msg_recipients

project_msg_recipients Structure
F-Key Name Type Description
recipient_id bigserial PRIMARY KEY
project_message.message_id message_id bigint NOT NULL
contacts.contact_id contact_id bigint NOT NULL
status_id integer NOT NULL
status character varying(80)
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL

Index - Schema public


Table: project_news

project_news Structure
F-Key Name Type Description
news_id bigserial PRIMARY KEY
projects.project_id project_id bigint
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()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
start_date timestamp without time zone DEFAULT now()
end_date timestamp 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
classification_id integer NOT NULL
lookup_news_template.code template_id integer
rating_value integer NOT NULL
rating_avg double precision NOT NULL
portal_key character varying(100)
redirect character varying(500)
page_title character varying(250)
keywords character varying(500)
description character varying(500)
meta_name character varying(100)
meta_content character varying(500)
read_date timestamp(3) without time zone
inappropriate_count integer

Tables referencing this one via Foreign Key Constraints:

projects_news_end_idx end_date projects_news_pid_idx project_id projects_news_port_idx portal_key projects_news_start_idx start_date projects_news_stat_idx status

Index - Schema public


Table: project_news_category

project_news_category Structure
F-Key Name Type Description
category_id bigserial PRIMARY KEY
projects.project_id project_id bigint 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:

projects_newsc_ena_idx enabled projects_newsc_pid_idx project_id

Index - Schema public


Table: project_news_comment

project_news_comment Structure
F-Key Name Type Description
comment_id bigserial PRIMARY KEY
project_news.news_id news_id bigint NOT NULL
comment text NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
closed timestamp(3) without time zone
users.user_id closedby bigint
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer

Tables referencing this one via Foreign Key Constraints:

project_news_cmt_idx news_id

Index - Schema public


Table: project_news_comment_rating

project_news_comment_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_news_comment.comment_id comment_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_news_cmt_rtg_idx comment_id

Index - Schema public


Table: project_news_rating

project_news_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_news.news_id news_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_news_rtg_idx news_id

Index - Schema public


View: project_news_tag

project_news_tag Structure
F-Key Name Type Description
news_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS news_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008080809)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: project_news_tag_log

project_news_tag_log Structure
F-Key Name Type Description
news_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS news_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008080809);

Index - Schema public


Table: project_news_tags

project_news_tags Structure
F-Key Name Type Description
project_news.news_id news_id bigint NOT NULL
tag character varying(255) NOT NULL
tag_count integer
project_news_tag_idx news_id

Index - Schema public


Table: project_news_view

project_news_view Structure
F-Key Name Type Description
project_news.news_id news_id bigint NOT NULL
users.user_id user_id bigint
view_date timestamp(3) without time zone NOT NULL DEFAULT now()
project_news_vw_idx news_id

Index - Schema public


Table: project_permissions

project_permissions Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
lookup_project_permission.code permission_id integer NOT NULL
lookup_project_role.code userlevel integer NOT NULL
project_perm_perm_idx permission_id project_perm_proj_idx project_id project_perm_usrl_idx userlevel

Index - Schema public


Table: project_photo_album_template

project_photo_album_template Structure
F-Key Name Type Description
template_id bigserial PRIMARY KEY
lookup_project_category.code project_category_id integer
album_names text NOT NULL
enabled boolean DEFAULT true
entered timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: project_priv_msg_recipient

project_priv_msg_recipient Structure
F-Key Name Type Description
recipient_id bigserial PRIMARY KEY
project_private_message.message_id message_id bigint NOT NULL
projects.project_id project_id bigint NOT NULL
read_date timestamp(3) without time zone
users.user_id read_by bigint
reply_date timestamp(3) without time zone
users.user_id replied_by bigint
delete_date timestamp(3) without time zone
users.user_id deleted_by bigint
archive_date timestamp(3) without time zone
prj_prv_msgr_arch_idx archive_date prj_prv_msgr_del_idx delete_date prj_prv_msgr_msg_idx message_id prj_prv_msgr_prj_idx project_id prj_prv_msgr_read_idx read_date

Index - Schema public


Table: project_private_message

project_private_message Structure
F-Key Name Type Description
message_id bigserial PRIMARY KEY
project_private_message.message_id parent_id bigint
link_module_id integer
link_item_id bigint
body text
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint
last_reply_date timestamp(3) without time zone
projects.project_id link_project_id bigint
users.user_id last_replied_by bigint
users.user_id deleted_by bigint
delete_date timestamp(3) without time zone
subject character varying(255) NOT NULL
recipient_count integer NOT NULL
read_count integer NOT NULL
last_read_date timestamp(3) without time zone
users.user_id last_read_by bigint
projects.project_id related_project_id bigint
projects.project_id from_project_id bigint
recipients text
archivedby text

Tables referencing this one via Foreign Key Constraints:

prj_prv_msg_eby_idx enteredby prj_prv_msg_fpi_idx from_project_id prj_prv_msg_lrd_idx last_read_date prj_prv_msg_rpi_idx related_project_id

Index - Schema public


Table: project_requirements

project_requirements Structure
F-Key Name Type Description
requirement_id bigint PRIMARY KEY DEFAULT nextval('project_requi_requirement_i_seq'::regclass)
projects.project_id project_id bigint NOT NULL
submittedby character varying(50)
departmentby character varying(30)
shortdescription character varying(255) NOT NULL
description text
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
users.user_id approvedby bigint
approvaldate timestamp(3) without time zone
users.user_id closedby bigint
closedate timestamp(3) without time zone
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
startdate timestamp(3) without time zone
wiki_link character varying(500)
read_only boolean NOT NULL DEFAULT false
remaining_loevalue integer
lookup_project_loe.code remaining_loetype integer

Tables referencing this one via Foreign Key Constraints:

proj_req_cdate_idx closedate

Index - Schema public


Table: project_requirements_map

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

Index - Schema public


Table: project_service

project_service Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
lookup_service.code service_id integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: project_team

project_team Structure
F-Key Name Type Description
team_id bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
users.user_id user_id bigint NOT NULL
lookup_project_role.code userlevel integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
status integer
last_accessed timestamp(3) without time zone
purpose integer
notification boolean DEFAULT false
tools boolean NOT NULL DEFAULT false
email_updates_schedule integer NOT NULL
project_team_lsta_idx last_accessed project_team_proj_idx project_id project_team_stat_idx status project_team_user_idx user_id

Index - Schema public


Table: project_ticket_category_template

project_ticket_category_template Structure
F-Key Name Type Description
template_id bigserial PRIMARY KEY
lookup_project_category.code project_category_id integer
ticket_categories text NOT NULL
enabled boolean DEFAULT true
entered timestamp(3) without time zone DEFAULT now()

Index - Schema public


Table: project_ticket_count

project_ticket_count Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
projects.project_id project_id bigint UNIQUE NOT NULL
key_count integer NOT NULL

Index - Schema public


Table: project_video

project_video Structure
F-Key Name Type Description
video_id bigserial PRIMARY KEY
projects.project_id project_id bigint
title character varying(255)
description text
publish_date timestamp(3) without time zone
link character varying(255)
thumbnail character varying(255)
embed_code text
video_type character varying(50)
video_width integer
video_height integer
video_author character varying(255)
is_live boolean NOT NULL DEFAULT false
is_valid boolean NOT NULL DEFAULT true
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
enabled boolean NOT NULL DEFAULT true
view_count integer
last_viewed_on timestamp(3) without time zone
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer
read_count integer NOT NULL
read_date timestamp(3) without time zone

Tables referencing this one via Foreign Key Constraints:

projects_video_pid_idx project_id

Index - Schema public


Table: project_video_rating

project_video_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_video.video_id video_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_video_rtg_idx video_id

Index - Schema public


View: project_video_tag

project_video_tag Structure
F-Key Name Type Description
video_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS video_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2010052514)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: project_video_tag_log

project_video_tag_log Structure
F-Key Name Type Description
video_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS video_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2010052514);

Index - Schema public


Table: project_video_view

project_video_view Structure
F-Key Name Type Description
project_video.video_id video_id bigint NOT NULL
users.user_id user_id bigint
view_date timestamp(3) without time zone NOT NULL DEFAULT now()
project_video_vw_idx video_id

Index - Schema public


Table: project_webcast

project_webcast Structure
F-Key Name Type Description
webcast_id bigserial PRIMARY KEY
projects.project_id project_id bigint
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer

Tables referencing this one via Foreign Key Constraints:

project_webcast_pid_idx project_id

Index - Schema public


Table: project_webcast_rating

project_webcast_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_webcast.webcast_id webcast_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_webcast_rtg_idx webcast_id

Index - Schema public


Table: project_wiki

project_wiki Structure
F-Key Name Type Description
wiki_id bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
subject character varying(500) NOT NULL
content text NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
read_count integer NOT NULL
enabled boolean DEFAULT true
read_only boolean DEFAULT false
rating_count integer NOT NULL
rating_value integer NOT NULL
lookup_wiki_state.code state_id integer
rating_avg double precision NOT NULL
read_date timestamp(3) without time zone
project_wiki_template.template_id template_id integer
inappropriate_count integer

Tables referencing this one via Foreign Key Constraints:

project_wiki_prj_idx project_id project_wiki_subj_idx subject

Index - Schema public


Table: project_wiki_categories

project_wiki_categories Structure
F-Key Name Type Description
project_wiki.wiki_id wiki_id bigint NOT NULL
lookup_wiki_categories.code tag_id bigint NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
project_wiki_cat_idx wiki_id

Index - Schema public


Table: project_wiki_comment

project_wiki_comment Structure
F-Key Name Type Description
comment_id bigserial PRIMARY KEY
project_wiki.wiki_id wiki_id bigint NOT NULL
comment text NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
closed timestamp(3) without time zone
users.user_id closedby bigint
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer

Tables referencing this one via Foreign Key Constraints:

project_wiki_cmt_idx wiki_id

Index - Schema public


Table: project_wiki_comment_rating

project_wiki_comment_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_wiki_comment.comment_id comment_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_wiki_cmt_rtg_idx comment_id

Index - Schema public


Table: project_wiki_rating

project_wiki_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
project_wiki.wiki_id wiki_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
inappropriate boolean DEFAULT false
project_wiki_rtg_idx wiki_id

Index - Schema public


Table: project_wiki_ref

project_wiki_ref Structure
F-Key Name Type Description
ref_id bigserial PRIMARY KEY
project_wiki.wiki_id wiki_id bigint NOT NULL
subject_from character varying(500) NOT NULL
subject_to character varying(500) NOT NULL
project_wiki_ref_idx wiki_id

Index - Schema public


View: project_wiki_tag

project_wiki_tag Structure
F-Key Name Type Description
wiki_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS wiki_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 20060220)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: project_wiki_tag_log

project_wiki_tag_log Structure
F-Key Name Type Description
wiki_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS wiki_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 20060220);

Index - Schema public


Table: project_wiki_template

project_wiki_template Structure
F-Key Name Type Description
template_id bigserial PRIMARY KEY
lookup_project_category.code project_category_id integer
title character varying(255) NOT NULL
content text NOT NULL
level integer NOT NULL
enabled boolean DEFAULT true
entered timestamp(3) without time zone DEFAULT now()

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: project_wiki_version

project_wiki_version Structure
F-Key Name Type Description
version_id bigserial PRIMARY KEY
project_wiki.wiki_id wiki_id bigint NOT NULL
content text NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
read_count integer NOT NULL
enabled boolean DEFAULT true
summary text
lines_added integer NOT NULL
lines_changed integer NOT NULL
lines_deleted integer NOT NULL
size integer NOT NULL
lines_total integer NOT NULL
project_wiki_vers_idx wiki_id

Index - Schema public


Table: project_wiki_view

project_wiki_view Structure
F-Key Name Type Description
project_wiki.wiki_id wiki_id bigint NOT NULL
users.user_id user_id bigint
view_date timestamp(3) without time zone NOT NULL DEFAULT now()
project_wiki_vw_idx wiki_id

Index - Schema public


Table: projects

projects Structure
F-Key Name Type Description
project_id bigserial PRIMARY KEY
group_id integer
departments.code department_id integer
template_id integer
title character varying(100) NOT NULL
requestedby character varying(50)
requesteddept character varying(50)
requestdate timestamp(3) without time zone DEFAULT now()
approvaldate timestamp(3) without time zone
users.user_id approvalby bigint
closedate timestamp(3) without time zone
owner integer
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL
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)
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)
template boolean NOT NULL DEFAULT false
wiki_enabled boolean NOT NULL DEFAULT true
wiki_label character varying(50)
dashboard_order integer NOT NULL DEFAULT 1
news_order integer NOT NULL DEFAULT 2
calendar_order integer NOT NULL DEFAULT 3
wiki_order integer NOT NULL DEFAULT 4
discussion_order integer NOT NULL DEFAULT 5
documents_order integer NOT NULL DEFAULT 6
lists_order integer NOT NULL DEFAULT 7
plan_order integer NOT NULL DEFAULT 8
tickets_order integer NOT NULL DEFAULT 9
team_order integer NOT NULL DEFAULT 10
details_order integer NOT NULL DEFAULT 11
dashboard_enabled boolean NOT NULL DEFAULT true
dashboard_label character varying(50)
lookup_project_language.id language_id integer
projecttextid character varying(100)
read_count bigint NOT NULL
read_date timestamp(3) without time zone
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
logo_id integer
dashboard_description character varying(255)
news_description character varying(255)
calendar_description character varying(255)
wiki_description character varying(255)
discussion_description character varying(255)
documents_description character varying(255)
lists_description character varying(255)
plan_description character varying(255)
tickets_description character varying(255)
team_description character varying(255)
concursive_crm_url character varying(255)
concursive_crm_domain character varying(255)
concursive_crm_code character varying(255)
concursive_crm_client character varying(255)
email1 character varying(255)
email2 character varying(255)
email3 character varying(255)
home_phone character varying(30)
home_phone_ext character varying(30)
home2_phone character varying(30)
home2_phone_ext character varying(30)
home_fax character varying(30)
business_phone character varying(30)
business_phone_ext character varying(30)
business2_phone character varying(30)
business2_phone_ext character varying(30)
business_fax character varying(30)
mobile_phone character varying(30)
pager_number character varying(30)
car_phone character varying(30)
radio_phone character varying(30)
web_page character varying(255)
address_to character varying(255)
addrline1 character varying(255)
addrline2 character varying(255)
addrline3 character varying(255)
city character varying(255)
state character varying(255)
country character varying(255)
postalcode character varying(255)
latitude double precision
longitude double precision
badges_enabled boolean NOT NULL DEFAULT true
badges_label character varying(50)
badges_order integer NOT NULL DEFAULT 12
badges_description character varying(255)
reviews_enabled boolean NOT NULL DEFAULT true
reviews_label character varying(50)
reviews_order integer NOT NULL DEFAULT 13
reviews_description character varying(255)
classifieds_enabled boolean NOT NULL DEFAULT true
classifieds_label character varying(50)
classifieds_order integer NOT NULL DEFAULT 14
classifieds_description character varying(255)
ads_enabled boolean NOT NULL DEFAULT true
ads_label character varying(50)
ads_order integer NOT NULL DEFAULT 15
ads_description character varying(255)
membership_required boolean DEFAULT true
lookup_project_category.code subcategory1_id integer
lookup_project_category.code subcategory2_id integer
lookup_project_category.code subcategory3_id integer
keywords character varying(255)
profile boolean NOT NULL DEFAULT false
profile_enabled boolean NOT NULL DEFAULT true
profile_label character varying(50)
profile_order integer NOT NULL
profile_description character varying(255)
source character varying(255)
style character varying(4096)
style_enabled boolean NOT NULL DEFAULT false
messages_enabled boolean NOT NULL DEFAULT true
messages_label character varying(50)
messages_order integer NOT NULL DEFAULT 18
messages_description character varying(255)
system_default boolean NOT NULL DEFAULT false
shortdescription character varying(1000) NOT NULL
instances.instance_id instance_id integer
twitter_id character varying(255)
facebook_page character varying(255)
youtube_channel_id character varying(255)
ustream_id character varying(1000)
livestream_id character varying(255)
justintv_id character varying(255)
qik_id character varying(255)
webcasts_enabled boolean NOT NULL DEFAULT true
webcasts_label character varying(50)
webcasts_order integer NOT NULL DEFAULT 17
webcasts_description character varying(255)
chatroom_enabled boolean NOT NULL DEFAULT false
chatroom_label character varying(50)
chatroom_order integer NOT NULL DEFAULT 18
chatroom_description character varying(255)
photos_enabled boolean NOT NULL DEFAULT true
photos_label character varying(50)
photos_order integer NOT NULL DEFAULT 20
photos_description character varying(255)
catalog_product.product_id product_id bigint
participants_min integer
participants_max integer
participants_count integer
adoptiondate timestamp(3) without time zone
discarddate timestamp(3) without time zone
actual double precision
actual_currency character varying(5)
videos_enabled boolean NOT NULL DEFAULT true
videos_label character varying(50)
videos_order integer NOT NULL DEFAULT 17
videos_description character varying(255)
pricing character varying(255)
projects.project_id parent_id bigint
checkin_latitude double precision
checkin_longitude double precision
projects.project_id checkin_project_id bigint
checkin_location character varying(255)
checkin_date timestamp(3) without time zone
users.user_id checkin_user_id bigint
foursquare_venue_id character varying(255)
linked_in_profile character varying(255)
event_profile boolean NOT NULL DEFAULT false
apple_ios_url_scheme character varying(255)
apple_ios_store_url character varying(255)
google_android_store_url character varying(255)
rssfeeds_enabled boolean NOT NULL DEFAULT true
rssfeeds_label character varying(50)
rssfeeds_order integer NOT NULL
rssfeeds_description character varying(255)
action_plan.plan_id triggered_action_plan_id bigint

Tables referencing this one via Foreign Key Constraints:

projects_appdate_idx approvaldate projects_cat_idx category_id projects_closedate_idx closedate projects_idx group_id, project_id projects_instanc_idx instance_id projects_mem_req_idx membership_required projects_parent_idx parent_id projects_portal_idx portal projects_prof_idx profile projects_subcat1_idx subcategory1_id projects_title_idx title projects_usr_gst_idx allow_guests projects_usr_obs_idx allows_user_observers

Index - Schema public


Table: projects_rating

projects_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
title character varying(100)
comment text
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
inappropriate_count integer NOT NULL
modified timestamp(3) without time zone DEFAULT now()
users.user_id modifiedby bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

projects_rtg_idx project_id projects_rtg_rtg_idx rating

Index - Schema public


Table: projects_rating_rating

projects_rating_rating Structure
F-Key Name Type Description
record_id bigserial PRIMARY KEY
projects_rating.rating_id rating_id bigint
rating integer NOT NULL
inappropriate boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
projects_rtgrtg_idx rating_id

Index - Schema public


View: projects_tag

projects_tag Structure
F-Key Name Type Description
project_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.link_item_id AS project_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2009021823)
GROUP BY user_tag_log.link_item_id
, user_tag_log.tag;

Index - Schema public


View: projects_tag_log

projects_tag_log Structure
F-Key Name Type Description
project_id bigint
user_id bigint
tag character varying(255)
tag_date timestamp(3) without time zone
SELECT user_tag_log.link_item_id AS project_id
, user_tag_log.user_id
, user_tag_log.tag
, user_tag_log.tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2009021823);

Index - Schema public


Table: projects_view

projects_view Structure
F-Key Name Type Description
projects.project_id project_id bigint NOT NULL
users.user_id user_id bigint
view_date timestamp(3) without time zone NOT NULL DEFAULT now()
projects_vw_idx project_id

Index - Schema public


Table: report

report Structure
F-Key Name Type Description
report_id serial PRIMARY KEY
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()
users.user_id enteredby bigint
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint
enabled boolean DEFAULT true
custom boolean DEFAULT false
user_report boolean DEFAULT false
admin_report 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_queue.queue_id queue_id bigint 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 bigserial PRIMARY KEY
report.report_id report_id integer NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
processed timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
status integer NOT NULL
filename character varying(256)
filesize integer DEFAULT (-1)
enabled boolean NOT NULL DEFAULT true
projects.project_id project_id bigint
send_email boolean NOT NULL DEFAULT false
schedule integer NOT NULL
schedule_monday boolean NOT NULL DEFAULT false
schedule_tuesday boolean NOT NULL DEFAULT false
schedule_wednesday boolean NOT NULL DEFAULT false
schedule_thursday boolean NOT NULL DEFAULT false
schedule_friday boolean NOT NULL DEFAULT false
schedule_saturday boolean NOT NULL DEFAULT false
schedule_sunday boolean NOT NULL DEFAULT false
cleanup integer NOT NULL DEFAULT 1
schedule_time timestamp(3) without time zone
output character varying(20)

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: step_action_map

step_action_map Structure
F-Key Name Type Description
map_id serial PRIMARY KEY
lookup_project_category.code category_id bigint
action_constant_id bigint 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: sync_client

sync_client Structure
F-Key Name Type Description
client_id bigserial PRIMARY KEY
type character varying(100)
version character varying(50)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
modifiedby bigint NOT NULL
anchor timestamp(3) without time zone DEFAULT NULL::timestamp without time zone
enabled boolean DEFAULT false
code character varying(255)

Index - Schema public


Table: sync_system

sync_system Structure
F-Key Name Type Description
system_id bigserial 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 bigint 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)

Index - Schema public


Table: task

task Structure
F-Key Name Type Description
task_id bigserial PRIMARY KEY
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
lookup_task_priority.code priority integer NOT NULL
description character varying(255)
duedate date
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()
users.user_id modifiedby bigint
estimatedloe double precision
lookup_task_loe.code estimatedloetype integer
users.user_id owner bigint
completedate timestamp(3) without time zone
lookup_task_category.code category_id integer
rating_count integer NOT NULL
rating_value integer NOT NULL
rating_avg double precision NOT NULL
lookup_task_functional_area.code functional_area integer
lookup_task_status.code status integer
lookup_task_value.code business_value integer
lookup_task_complexity.code complexity integer
lookup_task_release.code target_release integer
lookup_task_sprint.code target_sprint integer
lookup_task_loe_remaining.code loe_remaining integer
lookup_task_assigned_to.code assigned_to integer
lookup_task_assigned_priority.code assigned_priority integer
link_module_id integer
link_item_id bigint

Tables referencing this one via Foreign Key Constraints:

task_catid_idx category_id task_li_idx link_item_id task_lm_idx link_module_id task_statusid_idx status task_trelid_idx target_release

Index - Schema public


Table: task_rating

task_rating Structure
F-Key Name Type Description
rating_id bigserial PRIMARY KEY
task.task_id task_id bigint NOT NULL
rating integer NOT NULL
entered timestamp(3) without time zone DEFAULT now()
users.user_id enteredby bigint NOT NULL
projects.project_id project_id bigint
project_task_rtg_idx task_id project_task_rtge_idx enteredby

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 bigint NOT NULL

Index - Schema public


Table: taskcategorylink_news

taskcategorylink_news Structure
F-Key Name Type Description
project_news.news_id news_id bigint 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 bigint NOT NULL
contact_id bigint NOT NULL
notes text

Index - Schema public


Table: tasklink_project

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

Index - Schema public


Table: tasklink_ticket

tasklink_ticket Structure
F-Key Name Type Description
task.task_id task_id bigint NOT NULL
ticket_id bigint NOT NULL

Index - Schema public


Table: tasklog

tasklog Structure
F-Key Name Type Description
id serial PRIMARY KEY
task.task_id task_id bigint
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
lookup_task_priority.code priority integer NOT NULL
duedate timestamp(3) without time zone
complete boolean NOT NULL DEFAULT false
estimatedloe double precision
lookup_task_loe.code estimatedloetype integer
users.user_id owner bigint
completedate timestamp(3) without time zone
lookup_task_category.code category_id integer
lookup_task_functional_area.code functional_area bigint
lookup_task_status.code status bigint
lookup_task_value.code business_value bigint
lookup_task_complexity.code complexity bigint
lookup_task_release.code target_release bigint
lookup_task_sprint.code target_sprint bigint
lookup_task_loe_remaining.code loe_remaining bigint
lookup_task_assigned_to.code assigned_to bigint
lookup_task_assigned_priority.code assigned_priority bigint
tasklog_taskid_idx task_id

Index - Schema public


Table: ticket

ticket Structure
F-Key Name Type Description
ticketid bigserial PRIMARY KEY
org_id bigint
users.user_id contact_id bigint
problem text NOT NULL
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
closed timestamp without time zone
ticket_priority.code pri_code integer
ticket_level.code level_code integer
departments.code department_code integer
lookup_ticketsource.code source_code integer
cat_code bigint
subcat_code1 bigint
subcat_code2 bigint
subcat_code3 bigint
users.user_id assigned_to bigint
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(255)
assigned_date timestamp(3) without time zone
est_resolution_date timestamp(3) without time zone
resolution_date timestamp(3) without time zone
cause text
key_count integer NOT NULL
lookup_ticket_status.code status_id integer
ticket_cause.code cause_id bigint
ticket_resolution.code resolution_id bigint
ticket_defect.code defect_id bigint
ticket_escalation.code escalation_id bigint
ticket_state.code state_id bigint
related_id bigint
ready_for_close boolean NOT NULL DEFAULT false
read_count bigint NOT NULL
read_date timestamp(3) without time zone
projects.project_id link_project_id bigint
link_module_id bigint
link_item_id bigint

Tables referencing this one via Foreign Key Constraints:

ticket_cidx assigned_to, closed ticketlist_assigned assigned_to ticketlist_closed closed ticketlist_entered entered

Index - Schema public


Table: ticket_category

ticket_category Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
cat_level bigint NOT NULL
parent_cat_code bigint 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
projects.project_id project_id bigint

Index - Schema public


Table: ticket_cause

ticket_cause Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: ticket_contacts

ticket_contacts Structure
F-Key Name Type Description
id bigserial NOT NULL
ticket.ticketid ticketid bigint
users.user_id user_id bigint
contacts.contact_id contact_id bigint
contact_name character varying(255)
contact_email character varying(255)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL

Index - Schema public


Table: ticket_defect

ticket_defect Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: ticket_escalation

ticket_escalation Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: 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_resolution

ticket_resolution Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: 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_state

ticket_state Structure
F-Key Name Type Description
code bigserial PRIMARY KEY
projects.project_id project_id bigint NOT NULL
item_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: ticket_view

ticket_view Structure
F-Key Name Type Description
ticket.ticketid ticketid bigint NOT NULL
users.user_id user_id bigint
view_date timestamp(3) without time zone NOT NULL DEFAULT now()
ticket_vw_idx ticketid

Index - Schema public


Table: ticketlink_project

ticketlink_project Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
ticket.ticketid ticket_id bigint NOT NULL
projects.project_id project_id bigint NOT NULL
ticketlink_project_idx ticket_id ticketlink_projectid_idx project_id

Index - Schema public


Table: ticketlog

ticketlog Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
ticket.ticketid ticketid bigint
users.user_id assigned_to bigint
comment text
closed boolean
ticket_priority.code pri_code integer
level_code integer
departments.code department_code integer
cat_code bigint
ticket_severity.code scode integer
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
ticket_defect.code defect_id integer
ticket_escalation.code escalation_id integer
ticket_state.code state_id integer
ticket_cause.code cause_id integer

Index - Schema public


Table: timesheet

timesheet Structure
F-Key Name Type Description
timesheet_id bigserial PRIMARY KEY
users.user_id user_id bigint NOT NULL
entry_date timestamp(3) without time zone NOT NULL
hours double precision NOT NULL
start_time timestamp without time zone
end_time timestamp(3) without time zone
verified boolean NOT NULL DEFAULT false
approved boolean NOT NULL DEFAULT false
users.user_id approved_by bigint
available boolean NOT NULL DEFAULT true
unavailable boolean NOT NULL DEFAULT false
vacation boolean NOT NULL DEFAULT false
vacation_approved boolean NOT NULL DEFAULT false
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: timesheet_projects

timesheet_projects Structure
F-Key Name Type Description
id bigserial PRIMARY KEY
timesheet.timesheet_id timesheet_id bigint NOT NULL
projects.project_id project_id bigint
hours double precision NOT NULL
start_time timestamp(3) without time zone
end_time timestamp(3) without time zone

Index - Schema public


View: unique_ad_tag

unique_ad_tag Structure
F-Key Name Type Description
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008071715)
GROUP BY user_tag_log.tag;

Index - Schema public


View: unique_badge_tag

unique_badge_tag Structure
F-Key Name Type Description
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008051215)
GROUP BY user_tag_log.tag;

Index - Schema public


View: unique_project_classified_tag

unique_project_classified_tag Structure
F-Key Name Type Description
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2008071716)
GROUP BY user_tag_log.tag;

Index - Schema public


View: unique_project_video_tag

unique_project_video_tag Structure
F-Key Name Type Description
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2010052514)
GROUP BY user_tag_log.tag;

Index - Schema public


View: unique_project_wiki_tag

unique_project_wiki_tag Structure
F-Key Name Type Description
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 20060220)
GROUP BY user_tag_log.tag;

Index - Schema public


View: unique_projects_tag

unique_projects_tag Structure
F-Key Name Type Description
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
WHERE (user_tag_log.link_module_id = 2009021823)
GROUP BY user_tag_log.tag;

Index - Schema public


View: unique_tag

unique_tag Structure
F-Key Name Type Description
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
GROUP BY user_tag_log.tag;

Index - Schema public


Table: usage_log

usage_log Structure
F-Key Name Type Description
usage_id bigserial 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_contribution_log

user_contribution_log Structure
F-Key Name Type Description
record_id bigserial PRIMARY KEY
users.user_id user_id bigint NOT NULL
contribution_date timestamp(3) without time zone NOT NULL
lookup_contribution.code contribution_id integer NOT NULL
points bigint NOT NULL
entered timestamp(3) without time zone DEFAULT now()
projects.project_id project_id bigint
projects_usr_conl_cdt_idx contribution_date projects_usr_conl_prj_idx project_id projects_usr_conl_usr_idx user_id

Index - Schema public


Table: user_email

user_email Structure
F-Key Name Type Description
email_id bigserial NOT NULL
users.user_id user_id bigint NOT NULL
email character varying(255) NOT NULL
user_email_usr_idx user_id

Index - Schema public


Table: user_groups

user_groups Structure
F-Key Name Type Description
users.user_id user_id bigint NOT NULL
groups.group_id group_id integer NOT NULL

Index - Schema public


Table: user_log

user_log Structure
F-Key Name Type Description
users.user_id user_id bigint NOT NULL
log_date timestamp(3) without time zone DEFAULT now()
browser character varying(255)
ip_address character varying(40) NOT NULL
platform character varying(255)
model character varying(255)

Index - Schema public


Table: user_request

user_request Structure
F-Key Name Type Description
request_id bigserial PRIMARY KEY
request character varying(255)
namefirst character varying(255)
namelast character varying(255)
company_name character varying(255)
title character varying(255)
phone_number character varying(30)
phone_extension character varying(10)
email character varying(255)
ipaddress character varying(30)
browser character varying(300)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
processed timestamp(3) without time zone
addrline1 character varying(255)
addrline2 character varying(255)
addrline3 character varying(255)
city character varying(255)
state character varying(255)
country character varying(255)
postalcode character varying(255)
website character varying(255)
number_of_seats integer
requested_url character varying(255)
language character varying(255)

Index - Schema public


View: user_tag

user_tag Structure
F-Key Name Type Description
user_id bigint
tag character varying(255)
tag_count bigint
tag_date timestamp without time zone
SELECT user_tag_log.user_id
, user_tag_log.tag
, count
(*) AS tag_count
, max
(user_tag_log.tag_date) AS tag_date 
FROM user_tag_log 
GROUP BY user_tag_log.user_id
, user_tag_log.tag;

Index - Schema public


Table: user_tag_log

user_tag_log Structure
F-Key Name Type Description
users.user_id user_id bigint NOT NULL
link_module_id integer NOT NULL
link_item_id bigint NOT NULL
tag character varying(255) NOT NULL
tag_date timestamp(3) without time zone NOT NULL DEFAULT now()
user_tag_log_idx user_id user_tag_log_li_idx link_item_id user_tag_log_lm_idx link_module_id user_tag_log_tag_idx tag

Index - Schema public


View: user_wallet

user_wallet Structure
F-Key Name Type Description
user_id bigint
transactions bigint
balance double precision
SELECT wallet_log.user_id
, count
(*) AS transactions
, sum
(wallet_log.amount) AS balance 
FROM wallet_log 
GROUP BY wallet_log.user_id;

Index - Schema public


Table: users

users Structure
F-Key Name Type Description
user_id bigserial PRIMARY KEY
groups.group_id group_id integer NOT NULL
departments.code department_id integer
first_name character varying(50)
last_name character varying(50)
username character varying(255) NOT NULL
password character varying(50) NOT NULL
temporary_password character varying(50)
company character varying(100)
email character varying(255)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
enteredby integer
enabled boolean NOT NULL DEFAULT false
start_page integer NOT NULL DEFAULT 1
access_personal boolean NOT NULL DEFAULT false
access_enterprise boolean NOT NULL DEFAULT false
access_admin boolean NOT NULL DEFAULT false
access_invite boolean NOT NULL DEFAULT false
access_settings boolean NOT NULL DEFAULT true
access_guest boolean NOT NULL DEFAULT true
access_inbox boolean NOT NULL DEFAULT false
access_resources boolean NOT NULL DEFAULT false
last_login timestamp(3) without time zone DEFAULT now()
expiration timestamp(3) without time zone
registered boolean NOT NULL DEFAULT false
account_size integer
terms boolean NOT NULL DEFAULT false
timezone character varying(50)
currency character varying(5)
language character varying(20)
modified timestamp(3) without time zone NOT NULL DEFAULT now()
modifiedby integer
account_type integer
account_type_starts timestamp(3) without time zone
account_type_ends timestamp(3) without time zone
access_add_projects boolean NOT NULL DEFAULT false
webdav_access boolean NOT NULL DEFAULT false
webdav_password character varying(255)
htpasswd character varying(255)
htpasswd_date timestamp(3) without time zone
access_contacts_view_all boolean NOT NULL DEFAULT false
access_contacts_edit_all boolean NOT NULL DEFAULT false
watch_forums boolean NOT NULL DEFAULT false
nickname character varying(255)
lookup_title.code salutation integer
profile_project_id integer
show_profile_to integer
show_fullname_to integer
show_email_to integer
show_gender_to integer
show_location_to integer
show_company_to integer
points bigint NOT NULL
instances.instance_id instance_id integer
connect_crm_admin boolean DEFAULT false
connect_crm_manager boolean DEFAULT false
wallet_balance double precision
signature text
facebook_id bigint
gender character varying(100)
source character varying(255)

Tables referencing this one via Foreign Key Constraints:

users_enabled_idx enabled users_username_idx lower((username)::text)

Index - Schema public


Table: wallet_log

wallet_log Structure
F-Key Name Type Description
wallet_id bigserial PRIMARY KEY
users.user_id user_id bigint NOT NULL
amount double precision NOT NULL
amount_currency character varying(5)
entered timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id enteredby bigint NOT NULL
modified timestamp(3) without time zone NOT NULL DEFAULT now()
users.user_id modifiedby bigint NOT NULL
customer_order.order_id order_id bigint
projects.project_id project_id bigint
processed timestamp(3) without time zone
wallet_log_entered_idx entered wallet_log_prj_id_idx project_id wallet_log_user_id_idx user_id

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict