Dumped on 2003-07-31

• public
• address
• appointment_resource
• article
• article_category
• article_unit
• company
• company_assignment
• company_category
• company_info
• company_value
• date_company_assignment
• date_info
• date_x
• doc
• document
• document_editing
• document_version
• enterprise
• invoice
• invoice_account
• invoice_accounting
• invoice_action
• invoice_article_assignment
• job
• job_assignment
• job_history
• job_history_info
• job_resource_assignment
• log
• news_article
• news_article_link
• note
• obj_info
• obj_property
• object_acl
• object_model
• palm_address
• palm_category
• palm_date
• palm_memo
• palm_todo
• person
• pga_diagrams
• pga_forms
• pga_graphs
• pga_images
• pga_layout
• pga_queries
• pga_reports
• pga_scripts
• project
• project_company_assignment
• project_info
• resource
• session_log
• staff
• table_version
• team
• telephone
• trust

---

Table: address

address Structure

F-Key	Name	Type	Description
	address_id	integer	PRIMARY KEY
	object_version	integer
	company_id	integer
	name1	character varying(255)
	name2	character varying(255)
	name3	character varying(255)
	street	character varying(255)
	zip	character varying(50)
	zipcity	character varying(255)
	country	character varying(100)
	state	character varying(100)
	type	character varying(50)
	db_status	character varying(50)
	source_url	character varying(255)

 

Permissions which apply to address

User	Select	Insert	Update	Delete	Rule	Reference	Trigger
ogo	♦	♦	♦	♦	♦	♦	♦

Index - Schema public

---

Table: appointment_resource

appointment_resource Structure

F-Key	Name	Type	Description
	appointment_resource_id	integer	PRIMARY KEY
	object_version	integer
	name	character varying(255)	UNIQUE
	email	character varying(255)
	email_subject	character varying(255)
	category	character varying(255)
	notification_time	integer
	db_status	character varying(50)

Index - Schema public

---

Table: article

article Structure

F-Key	Name	Type	Description
	article_id	integer	PRIMARY KEY
	article_unit_id	integer
	article_category_id	integer
	object_version	integer
	article_name	character varying(255)
	article_nr	character varying(255)
	article_text	text
	status	character varying(50)
	price	numeric(19,4)
	vat	numeric(19,4)
	vat_group	character varying(50)
	db_status	character varying(50)

Index - Schema public

---

Table: article_category

article_category Structure

F-Key	Name	Type	Description
	article_category_id	integer	PRIMARY KEY
	category_name	character varying(255)
	category_abbrev	character varying(255)

Index - Schema public

---

Table: article_unit

article_unit Structure

F-Key	Name	Type	Description
	article_unit_id	integer	PRIMARY KEY
	format	character varying(50)
	singular_unit	character varying(255)
	plural_unit	character varying(255)

Index - Schema public

---

Table: company

company Structure

F-Key	Name	Type	Description
	company_id	integer	PRIMARY KEY
	object_version	integer
	owner_id	integer
	contact_id	integer
	template_user_id	integer
	is_private	smallint
	is_person	smallint
	is_readonly	smallint
	is_enterprise	smallint
	is_account	smallint
	is_intra_account	smallint
	is_extra_account	smallint
	is_trust	smallint
	is_team	smallint
	is_location_team	smallint
	is_customer	smallint
	number	character varying(100)	UNIQUE
	description	character varying(255)
	priority	character varying(50)
	keywords	character varying(255)
	url	character varying(255)
	email	character varying(100)
	type	character varying(50)
	bank	character varying(100)
	bank_code	character varying(50)
	account	character varying(50)
	payment	character varying(50)
	is_locked	smallint
	is_template_user	smallint
	can_change_password	smallint
	login	character varying(50)	UNIQUE
	password	character varying(50)
	pop3_account	character varying(50)
	name	character varying(50)
	middlename	character varying(50)
	firstname	character varying(50)
	salutation	character varying(50)
	degree	character varying(50)
	birthday	timestamp with time zone
	sex	character varying(10)
	source_url	character varying(255)
	db_status	character varying(50)
	sensitivity	smallint
	boss_name	character varying(255)
	partner_name	character varying(255)
	assistant_name	character varying(255)
	department	character varying(255)
	office	character varying(255)
	occupation	character varying(255)
	anniversary	timestamp with time zone
	dir_server	character varying(255)
	email_alias	character varying(255)
	freebusy_url	character varying(255)
	fileas	character varying(255)
	name_title	character varying(255)
	name_affix	character varying(255)
	im_address	character varying(255)
	associated_contacts	character varying(255)
	associated_categories	character varying(255)
	associated_company	character varying(255)
	show_email_as	character varying(255)
	show_email2_as	character varying(255)
	show_email3_as	character varying(255)

Index - Schema public

---

Table: company_assignment

company_assignment Structure

F-Key	Name	Type	Description
	company_assignment_id	integer	PRIMARY KEY
	company_id	integer
	sub_company_id	integer
	is_headquarter	smallint
	is_chief	smallint
	function	character varying(255)
	db_status	character varying(50)

Index - Schema public

---

Table: company_category

company_category Structure

F-Key	Name	Type	Description
	company_category_id	integer	PRIMARY KEY
	object_version	integer
	category	character varying(255)
	db_status	character varying(50)

Index - Schema public

---

Table: company_info

company_info Structure

F-Key	Name	Type	Description
	company_info_id	integer	PRIMARY KEY
	company_id	integer
	comment	text
	db_status	character varying(50)

Index - Schema public

---

Table: company_value

company_value Structure

F-Key	Name	Type	Description
	company_value_id	integer	PRIMARY KEY
	company_id	integer
	attribute	character varying(255)
	attribute_type	character varying(50)
	value_string	character varying(255)
	value_date	timestamp with time zone
	value_int	integer
	is_enum	smallint
	category	character varying(255)
	uid	integer
	label	character varying(255)
	type	integer
	is_label_localized	smallint
	db_status	character varying(50)

Index - Schema public

---

Table: date_company_assignment

date_company_assignment Structure

F-Key	Name	Type	Description
	date_company_assignment_id	integer	PRIMARY KEY
	company_id	integer
	date_id	integer
	is_staff	smallint
	is_new	smallint
	partstatus	character varying(50)
	role	character varying(50)
	comment	character varying(255)
	rsvp	smallint
	db_status	character varying(50)
	outlook_key	character varying(255)

Index - Schema public

---

Table: date_info

date_info Structure

F-Key	Name	Type	Description
	date_info_id	integer	PRIMARY KEY
	date_id	integer
	comment	text
	db_status	character varying(50)

Index - Schema public

---

Table: date_x

date_x Structure

F-Key	Name	Type	Description
	date_id	integer	PRIMARY KEY
	object_version	integer
	owner_id	integer
	access_team_id	integer
	parent_date_id	integer
	start_date	timestamp with time zone
	end_date	timestamp with time zone
	cycle_end_date	timestamp with time zone
	type	character varying(50)
	title	character varying(255)
	location	character varying(255)
	absence	character varying(255)
	resource_names	character varying(255)
	write_access_list	character varying(255)
	is_absence	smallint
	is_attendance	smallint
	is_conflict_disabled	smallint
	travel_duration_before	integer
	travel_duration_after	integer
	notification_time	integer
	db_status	character varying(50)
	apt_type	character varying(100)
	calendar_name	character varying(255)
	source_url	character varying(255)
	fbtype	character varying(50)
	sensitivity	smallint
	busy_type	smallint
	importance	smallint
	last_modified	integer
	evo_reminder	character varying(255)
	ol_reminder	character varying(255)
	online_meeting	character varying(255)
	associated_contacts	character varying(255)
	keywords	character varying(255)

Index - Schema public

---

Table: doc

doc Structure

F-Key	Name	Type	Description
	document_id	integer
	object_version	integer
	project_id	integer
	parent_document_id	integer
	date_id	integer
	first_owner_id	integer
	current_owner_id	integer
	version_count	integer
	file_size	integer
	is_note	smallint
	is_folder	smallint
	is_object_link	smallint
	is_index_doc	smallint
	title	character varying(255)
	abstract	character varying(255)
	file_type	character varying(255)
	object_link	character varying(255)
	creation_date	timestamp with time zone
	lastmodified_date	timestamp with time zone
	status	character varying(50)
	db_status	character varying(50)
	contact	character varying(255)

Index - Schema public

---

Table: document

document Structure

F-Key	Name	Type	Description
	document_id	integer	PRIMARY KEY
	object_version	integer
	project_id	integer
	parent_document_id	integer
	date_id	integer
	first_owner_id	integer
	current_owner_id	integer
	version_count	integer
	file_size	integer
	is_note	smallint
	is_folder	smallint
	is_object_link	smallint
	is_index_doc	smallint
	title	character varying(255)
	abstract	character varying(255)
	file_type	character varying(255)
	object_link	character varying(255)
	creation_date	timestamp with time zone
	lastmodified_date	timestamp with time zone
	status	character varying(50)
	db_status	character varying(50)
	contact	character varying(255)

Index - Schema public

---

Table: document_editing

document_editing Structure

F-Key	Name	Type	Description
	document_editing_id	integer	PRIMARY KEY
	object_version	integer
	document_id	integer
	current_owner_id	integer
	title	character varying(255)
	abstract	character varying(255)
	file_type	character varying(255)
	file_size	integer
	version	integer
	is_attach_changed	smallint
	checkout_date	timestamp with time zone
	status	character varying(50)
	db_status	character varying(50)
	contact	character varying(255)

Index - Schema public

---

Table: document_version

document_version Structure

F-Key	Name	Type	Description
	document_version_id	integer	PRIMARY KEY
	object_version	integer
	document_id	integer
	last_owner_id	integer
	title	character varying(255)
	abstract	character varying(255)
	file_type	character varying(255)
	version	integer
	file_size	integer
	creation_date	timestamp with time zone
	archive_date	timestamp with time zone
	is_packed	smallint
	change_text	text
	db_status	character varying(50)
	contact	character varying(255)

Index - Schema public

---

Table: enterprise

enterprise Structure

F-Key	Name	Type	Description
	company_id	integer
	object_version	integer
	owner_id	integer
	contact_id	integer
	template_user_id	integer
	is_private	smallint
	is_person	smallint
	is_readonly	smallint
	is_enterprise	smallint
	is_account	smallint
	is_intra_account	smallint
	is_extra_account	smallint
	is_trust	smallint
	is_team	smallint
	is_location_team	smallint
	is_customer	smallint
	number	character varying(100)
	description	character varying(255)
	priority	character varying(50)
	keywords	character varying(255)
	url	character varying(255)
	email	character varying(100)
	type	character varying(50)
	bank	character varying(100)
	bank_code	character varying(50)
	account	character varying(50)
	payment	character varying(50)
	is_locked	smallint
	is_template_user	smallint
	can_change_password	smallint
	login	character varying(50)
	password	character varying(50)
	pop3_account	character varying(50)
	name	character varying(50)
	middlename	character varying(50)
	firstname	character varying(50)
	salutation	character varying(50)
	degree	character varying(50)
	birthday	timestamp with time zone
	sex	character varying(10)
	source_url	character varying(255)
	db_status	character varying(50)
	sensitivity	smallint
	boss_name	character varying(255)
	partner_name	character varying(255)
	assistant_name	character varying(255)
	department	character varying(255)
	office	character varying(255)
	occupation	character varying(255)
	anniversary	timestamp with time zone
	dir_server	character varying(255)
	email_alias	character varying(255)
	freebusy_url	character varying(255)
	fileas	character varying(255)
	name_title	character varying(255)
	name_affix	character varying(255)
	im_address	character varying(255)
	associated_contacts	character varying(255)
	associated_categories	character varying(255)
	associated_company	character varying(255)
	show_email_as	character varying(255)
	show_email2_as	character varying(255)
	show_email3_as	character varying(255)

Index - Schema public

---

Table: invoice

invoice Structure

F-Key	Name	Type	Description
	invoice_id	integer	PRIMARY KEY
	debitor_id	integer
	parent_invoice_id	integer
	invoice_nr	character varying(255)
	invoice_date	timestamp with time zone
	kind	character varying(100)
	status	character varying(100)
	net_amount	numeric(19,4)
	gross_amount	numeric(19,4)
	paid	numeric(19,4)
	comment	text
	object_version	integer
	db_status	character varying(50)

Index - Schema public

---

Table: invoice_account

invoice_account Structure

F-Key	Name	Type	Description
	invoice_account_id	integer	PRIMARY KEY
	enterprise_id	integer
	account_nr	character varying(50)
	balance	numeric(19,4)
	object_version	integer
	db_status	character varying(50)

Index - Schema public

---

Table: invoice_accounting

invoice_accounting Structure

F-Key	Name	Type	Description
	invoice_accounting_id	integer	PRIMARY KEY
	action_id	integer
	debit	numeric(19,4)
	balance	numeric(19,4)
	object_version	integer
	db_status	character varying(50)

Index - Schema public

---

Table: invoice_action

invoice_action Structure

F-Key	Name	Type	Description
	invoice_action_id	integer	PRIMARY KEY
	account_id	integer
	invoice_id	integer
	document_id	integer
	action_date	timestamp with time zone
	action_kind	character varying(100)
	log_text	text
	object_version	integer
	db_status	character varying(50)

Index - Schema public

---

Table: invoice_article_assignment

invoice_article_assignment Structure

F-Key	Name	Type	Description
	invoice_article_assignment_id	integer	PRIMARY KEY
	invoice_id	integer
	article_id	integer
	article_count	numeric(19,4)
	object_version	integer
	net_amount	numeric(19,4)
	vat	numeric(19,8)
	comment	text
	db_status	character varying(50)

Index - Schema public

---

Table: job

job Structure

F-Key	Name	Type	Description
	job_id	integer	PRIMARY KEY
	object_version	integer
	parent_job_id	integer
	project_id	integer
	creator_id	integer
	executant_id	integer
	name	character varying(255)
	start_date	timestamp with time zone
	end_date	timestamp with time zone
	notify_x	integer
	is_control_job	smallint
	is_team_job	smallint
	is_new	smallint
	job_status	character varying(255)
	category	character varying(255)
	priority	integer
	db_status	character varying(50)
	kind	character varying(50)
	keywords	character varying(255)
	source_url	character varying(255)
	sensitivity	smallint
	job_comment	text
	completion_date	timestamp with time zone
	percent_complete	smallint
	actual_work	smallint
	total_work	smallint
	last_modified	integer
	accounting_info	character varying(255)
	kilometers	character varying(255)
	associated_companies	character varying(255)
	associated_contacts	character varying(255)
	timer_date	timestamp with time zone

Index - Schema public

---

Table: job_assignment

job_assignment Structure

F-Key	Name	Type	Description
	job_assignment_id	integer	PRIMARY KEY
	parent_job_id	integer
	child_job_id	integer
	position_x	integer
	assignment_kind	character varying(50)
	db_status	character varying(50)

Index - Schema public

---

Table: job_history

job_history Structure

F-Key	Name	Type	Description
	job_history_id	integer	PRIMARY KEY
	object_version	integer
	job_id	integer
	actor_id	integer
	action	character varying(50)
	action_date	timestamp with time zone
	job_status	character varying(50)
	db_status	character varying(50)

Index - Schema public

---

Table: job_history_info

job_history_info Structure

F-Key	Name	Type	Description
	job_history_info_id	integer	PRIMARY KEY
	job_history_id	integer
	comment	text
	db_status	character varying(50)

Index - Schema public

---

Table: job_resource_assignment

job_resource_assignment Structure

F-Key	Name	Type	Description
	job_resource_assignment_id	integer	PRIMARY KEY
	resource_id	integer
	job_id	integer
	operative_part	integer
	db_status	character varying(50)

Index - Schema public

---

Table: log

log Structure

F-Key	Name	Type	Description
	log_id	integer	PRIMARY KEY
	creation_date	timestamp with time zone
	object_id	integer
	log_text	text
	action	character varying(100)
	account_id	integer

Index - Schema public

---

Table: news_article

news_article Structure

F-Key	Name	Type	Description
	news_article_id	integer	PRIMARY KEY
	object_version	integer
	name	character varying(255)
	caption	character varying(255)
	is_index_article	smallint
	creation_date	timestamp with time zone
	db_status	character varying(50)

Index - Schema public

---

Table: news_article_link

news_article_link Structure

F-Key	Name	Type	Description
	news_article_link_id	integer	PRIMARY KEY
	object_version	integer
	news_article_id	integer
	sub_news_article_id	integer

Index - Schema public

---

Table: note

note Structure

F-Key	Name	Type	Description
	document_id	integer
	object_version	integer
	project_id	integer
	parent_document_id	integer
	date_id	integer
	first_owner_id	integer
	current_owner_id	integer
	version_count	integer
	file_size	integer
	is_note	smallint
	is_folder	smallint
	is_object_link	smallint
	is_index_doc	smallint
	title	character varying(255)
	abstract	character varying(255)
	file_type	character varying(255)
	object_link	character varying(255)
	creation_date	timestamp with time zone
	lastmodified_date	timestamp with time zone
	status	character varying(50)
	db_status	character varying(50)
	contact	character varying(255)

Index - Schema public

---

Table: obj_info

obj_info Structure

F-Key	Name	Type	Description
	obj_id	integer	PRIMARY KEY
	obj_type	character varying(255)

Index - Schema public

---

Table: obj_property

obj_property Structure

F-Key	Name	Type	Description
	obj_property_id	integer	PRIMARY KEY
	obj_id	integer
	obj_type	character varying(255)
	access_key	integer
	value_key	character varying(255)
	namespace_prefix	character varying(255)
	preferred_type	character varying(255)
	value_string	character varying(255)
	value_int	integer
	value_float	numeric(19,8)
	value_date	timestamp with time zone
	value_oid	character varying(255)
	blob_size	integer
	value_blob	text

Index - Schema public

---

Table: object_acl

object_acl Structure

F-Key	Name	Type	Description
	object_acl_id	integer
	sort_key	integer
	action	character varying(10)
	object_id	character varying(255)
	auth_id	character varying(255)
	permissions	character varying(50)

Index - Schema public

---

Table: object_model

object_model Structure

F-Key	Name	Type	Description
	db_version	integer
	model_name	character varying(255)

Index - Schema public

---

Table: palm_address

palm_address Structure

F-Key	Name	Type	Description
	company_id	integer
	device_id	character varying(50)
	palm_address_id	integer	PRIMARY KEY
	palm_id	integer
	category_index	integer
	is_deleted	smallint
	is_modified	smallint
	is_archived	smallint
	is_new	smallint
	is_private	smallint
	md5hash	character varying(50)
	address	character varying(255)
	city	character varying(255)
	company	character varying(255)
	country	character varying(255)
	display_phone	integer
	firstname	character varying(255)
	lastname	character varying(255)
	note	text
	phone0	character varying(255)
	phone1	character varying(255)
	phone2	character varying(255)
	phone3	character varying(255)
	phone4	character varying(255)
	phone_label_id0	integer
	phone_label_id1	integer
	phone_label_id2	integer
	phone_label_id3	integer
	phone_label_id4	integer
	state	character varying(255)
	title	character varying(255)
	zipcode	character varying(255)
	custom1	character varying(255)
	custom2	character varying(255)
	custom3	character varying(255)
	custom4	character varying(255)
	skyrix_id	integer
	skyrix_sync	integer
	skyrix_version	integer
	skyrix_type	character varying(10)

Index - Schema public

---

Table: palm_category

palm_category Structure

F-Key	Name	Type	Description
	company_id	integer
	device_id	character varying(50)
	palm_category_id	integer	PRIMARY KEY
	palm_id	integer
	palm_table	character varying(10)
	is_modified	smallint
	md5hash	character varying(50)
	category_index	integer
	category_name	character varying(255)

Index - Schema public

---

Table: palm_date

palm_date Structure

F-Key	Name	Type	Description
	company_id	integer
	device_id	character varying(50)
	palm_date_id	integer	PRIMARY KEY
	palm_id	integer
	category_index	integer
	is_deleted	smallint
	is_modified	smallint
	is_archived	smallint
	is_new	smallint
	is_private	smallint
	md5hash	character varying(50)
	alarm_advance_time	integer
	alarm_advance_unit	integer
	description	character varying(255)
	enddate	timestamp with time zone
	is_alarmed	smallint
	is_untimed	smallint
	note	text
	repeat_enddate	timestamp with time zone
	repeat_frequency	integer
	repeat_on	integer
	repeat_start_week	integer
	repeat_type	integer
	startdate	timestamp with time zone
	exceptions	text
	skyrix_id	integer
	skyrix_sync	integer
	skyrix_version	integer

Index - Schema public

---

Table: palm_memo

palm_memo Structure

F-Key	Name	Type	Description
	company_id	integer
	device_id	character varying(50)
	palm_memo_id	integer	PRIMARY KEY
	palm_id	integer
	category_index	integer
	is_deleted	smallint
	is_modified	smallint
	is_archived	smallint
	is_new	smallint
	is_private	smallint
	md5hash	character varying(50)
	memo	text
	skyrix_id	integer
	skyrix_sync	integer
	skyrix_version	integer

Index - Schema public

---

Table: palm_todo

palm_todo Structure

F-Key	Name	Type	Description
	company_id	integer
	device_id	character varying(50)
	palm_todo_id	integer	PRIMARY KEY
	palm_id	integer
	category_index	integer
	is_deleted	smallint
	is_modified	smallint
	is_archived	smallint
	is_new	smallint
	is_private	smallint
	md5hash	character varying(50)
	description	character varying(255)
	duedate	timestamp with time zone
	note	text
	priority	integer
	is_completed	smallint
	skyrix_id	integer
	skyrix_sync	integer
	skyrix_version	integer

Index - Schema public

---

Table: person

person Structure

F-Key	Name	Type	Description
	company_id	integer
	object_version	integer
	owner_id	integer
	contact_id	integer
	template_user_id	integer
	is_private	smallint
	is_person	smallint
	is_readonly	smallint
	is_enterprise	smallint
	is_account	smallint
	is_intra_account	smallint
	is_extra_account	smallint
	is_trust	smallint
	is_team	smallint
	is_location_team	smallint
	is_customer	smallint
	number	character varying(100)
	description	character varying(255)
	priority	character varying(50)
	keywords	character varying(255)
	url	character varying(255)
	email	character varying(100)
	type	character varying(50)
	bank	character varying(100)
	bank_code	character varying(50)
	account	character varying(50)
	payment	character varying(50)
	is_locked	smallint
	is_template_user	smallint
	can_change_password	smallint
	login	character varying(50)
	password	character varying(50)
	pop3_account	character varying(50)
	name	character varying(50)
	middlename	character varying(50)
	firstname	character varying(50)
	salutation	character varying(50)
	degree	character varying(50)
	birthday	timestamp with time zone
	sex	character varying(10)
	source_url	character varying(255)
	db_status	character varying(50)
	sensitivity	smallint
	boss_name	character varying(255)
	partner_name	character varying(255)
	assistant_name	character varying(255)
	department	character varying(255)
	office	character varying(255)
	occupation	character varying(255)
	anniversary	timestamp with time zone
	dir_server	character varying(255)
	email_alias	character varying(255)
	freebusy_url	character varying(255)
	fileas	character varying(255)
	name_title	character varying(255)
	name_affix	character varying(255)
	im_address	character varying(255)
	associated_contacts	character varying(255)
	associated_categories	character varying(255)
	associated_company	character varying(255)
	show_email_as	character varying(255)
	show_email2_as	character varying(255)
	show_email3_as	character varying(255)

Index - Schema public

---

Table: pga_diagrams

pga_diagrams Structure

F-Key	Name	Type	Description
	diagramname	character varying(64)	PRIMARY KEY
	diagramtables	text
	diagramlinks	text

Index - Schema public

---

Table: pga_forms

pga_forms Structure

F-Key	Name	Type	Description
	formname	character varying(64)	PRIMARY KEY
	formsource	text

Index - Schema public

---

Table: pga_graphs

pga_graphs Structure

F-Key	Name	Type	Description
	graphname	character varying(64)	PRIMARY KEY
	graphsource	text
	graphcode	text

Index - Schema public

---

Table: pga_images

pga_images Structure

F-Key	Name	Type	Description
	imagename	character varying(64)	PRIMARY KEY
	imagesource	text

Index - Schema public

---

Table: pga_layout

pga_layout Structure

F-Key	Name	Type	Description
	tablename	character varying(64)	PRIMARY KEY
	nrcols	smallint
	colnames	text
	colwidth	text

Index - Schema public

---

Table: pga_queries

pga_queries Structure

F-Key	Name	Type	Description
	queryname	character varying(64)	PRIMARY KEY
	querytype	character(1)
	querycommand	text
	querytables	text
	querylinks	text
	queryresults	text
	querycomments	text

Index - Schema public

---

Table: pga_reports

pga_reports Structure

F-Key	Name	Type	Description
	reportname	character varying(64)	PRIMARY KEY
	reportsource	text
	reportbody	text
	reportprocs	text
	reportoptions	text

Index - Schema public

---

Table: pga_scripts

pga_scripts Structure

F-Key	Name	Type	Description
	scriptname	character varying(64)	PRIMARY KEY
	scriptsource	text

Index - Schema public

---

Table: project

project Structure

F-Key	Name	Type	Description
	project_id	integer	PRIMARY KEY
	object_version	integer
	owner_id	integer
	team_id	integer
	number	character varying(100)	UNIQUE
	name	character varying(255)
	start_date	timestamp with time zone
	end_date	timestamp with time zone
	status	character varying(255)
	is_fake	smallint
	db_status	character varying(50)
	kind	character varying(50)
	url	character varying(100)

Index - Schema public

---

Table: project_company_assignment

project_company_assignment Structure

F-Key	Name	Type	Description
	project_company_assignment_id	integer	PRIMARY KEY
	company_id	integer
	project_id	integer
	info	character varying(255)
	has_access	smallint
	access_right	character varying(50)
	db_status	character varying(50)

Index - Schema public

---

Table: project_info

project_info Structure

F-Key	Name	Type	Description
	project_info_id	integer	PRIMARY KEY
	project_id	integer
	comment	text
	db_status	character varying(50)

Index - Schema public

---

Table: resource

resource Structure

F-Key	Name	Type	Description
	resource_id	integer	PRIMARY KEY
	resource_name	character varying(255)
	token	character varying(255)
	object_id	integer
	quantity	integer
	comment	text
	standard_costs	numeric(19,2)
	type	integer
	db_status	character varying(50)
	object_version	integer

Index - Schema public

---

Table: session_log

session_log Structure

F-Key	Name	Type	Description
	session_log_id	integer	PRIMARY KEY
	account_id	integer
	log_date	timestamp with time zone
	action	character varying(255)

Index - Schema public

---

Table: staff

staff Structure

F-Key	Name	Type	Description
	staff_id	integer	PRIMARY KEY
	company_id	integer	UNIQUE
	description	character varying(255)
	login	character varying(255)
	is_team	smallint
	is_account	smallint
	db_status	character varying(50)

Index - Schema public

---

Table: table_version

table_version Structure

F-Key	Name	Type	Description
	table_name	character varying(255)	PRIMARY KEY
	table_version	integer

Index - Schema public

---

Table: team

team Structure

F-Key	Name	Type	Description
	company_id	integer
	object_version	integer
	owner_id	integer
	contact_id	integer
	template_user_id	integer
	is_private	smallint
	is_person	smallint
	is_readonly	smallint
	is_enterprise	smallint
	is_account	smallint
	is_intra_account	smallint
	is_extra_account	smallint
	is_trust	smallint
	is_team	smallint
	is_location_team	smallint
	is_customer	smallint
	number	character varying(100)
	description	character varying(255)
	priority	character varying(50)
	keywords	character varying(255)
	url	character varying(255)
	email	character varying(100)
	type	character varying(50)
	bank	character varying(100)
	bank_code	character varying(50)
	account	character varying(50)
	payment	character varying(50)
	is_locked	smallint
	is_template_user	smallint
	can_change_password	smallint
	login	character varying(50)
	password	character varying(50)
	pop3_account	character varying(50)
	name	character varying(50)
	middlename	character varying(50)
	firstname	character varying(50)
	salutation	character varying(50)
	degree	character varying(50)
	birthday	timestamp with time zone
	sex	character varying(10)
	source_url	character varying(255)
	db_status	character varying(50)
	sensitivity	smallint
	boss_name	character varying(255)
	partner_name	character varying(255)
	assistant_name	character varying(255)
	department	character varying(255)
	office	character varying(255)
	occupation	character varying(255)
	anniversary	timestamp with time zone
	dir_server	character varying(255)
	email_alias	character varying(255)
	freebusy_url	character varying(255)
	fileas	character varying(255)
	name_title	character varying(255)
	name_affix	character varying(255)
	im_address	character varying(255)
	associated_contacts	character varying(255)
	associated_categories	character varying(255)
	associated_company	character varying(255)
	show_email_as	character varying(255)
	show_email2_as	character varying(255)
	show_email3_as	character varying(255)

Index - Schema public

---

Table: telephone

telephone Structure

F-Key	Name	Type	Description
	telephone_id	integer	PRIMARY KEY
	object_version	integer
	company_id	integer
	number	character varying(255)
	real_number	character varying(255)
	type	character varying(50)
	info	character varying(255)
	url	character varying(255)
	db_status	character varying(50)

Index - Schema public

---

Table: trust

trust Structure

F-Key	Name	Type	Description
	company_id	integer
	object_version	integer
	owner_id	integer
	contact_id	integer
	template_user_id	integer
	is_private	smallint
	is_person	smallint
	is_readonly	smallint
	is_enterprise	smallint
	is_account	smallint
	is_intra_account	smallint
	is_extra_account	smallint
	is_trust	smallint
	is_team	smallint
	is_location_team	smallint
	is_customer	smallint
	number	character varying(100)
	description	character varying(255)
	priority	character varying(50)
	keywords	character varying(255)
	url	character varying(255)
	email	character varying(100)
	type	character varying(50)
	bank	character varying(100)
	bank_code	character varying(50)
	account	character varying(50)
	payment	character varying(50)
	is_locked	smallint
	is_template_user	smallint
	can_change_password	smallint
	login	character varying(50)
	password	character varying(50)
	pop3_account	character varying(50)
	name	character varying(50)
	middlename	character varying(50)
	firstname	character varying(50)
	salutation	character varying(50)
	degree	character varying(50)
	birthday	timestamp with time zone
	sex	character varying(10)
	source_url	character varying(255)
	db_status	character varying(50)
	sensitivity	smallint
	boss_name	character varying(255)
	partner_name	character varying(255)
	assistant_name	character varying(255)
	department	character varying(255)
	office	character varying(255)
	occupation	character varying(255)
	anniversary	timestamp with time zone
	dir_server	character varying(255)
	email_alias	character varying(255)
	freebusy_url	character varying(255)
	fileas	character varying(255)
	name_title	character varying(255)
	name_affix	character varying(255)
	im_address	character varying(255)
	associated_contacts	character varying(255)
	associated_categories	character varying(255)
	associated_company	character varying(255)
	show_email_as	character varying(255)
	show_email2_as	character varying(255)
	show_email3_as	character varying(255)

Index - Schema public