Table webco_3.5.5.public.pq_organization Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19
org_type varchar 2147483647  √  null
name varchar 2147483647  √  null
address_1 varchar 2147483647  √  null
address_2 varchar 2147483647  √  null
city varchar 2147483647  √  null
state varchar 2147483647  √  null
country varchar 2147483647  √  null
postal_code varchar 2147483647  √  null
phone varchar 2147483647  √  null
fax varchar 2147483647  √  null
email varchar 2147483647  √  null
url varchar 2147483647  √  null
main_contact_person_oid int8 19  √  null
note varchar 2147483647  √  null
search_tags varchar 2147483647  √  null
internal_department varchar 2147483647  √  null
client_job_numbers varchar 2147483647  √  null
client_rate_card int8 19  √  null
vendor_account_number varchar 2147483647  √  null
vendor_maintenance_contract_number varchar 2147483647  √  null
vendor_maintenance_contract_notes varchar 2147483647  √  null

Table contained 0 rows at Mon Mar 15 14:58 EDT 2010

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc pq_organization_pkey