Table chouette_v17.chouette.company
company operating a public transport service

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
id bigserial 19  √  nextval('company_id_seq'::regclass)
line.companyid line_company_fkey N
vehiclejourney.companyid vj_company_fkey N
Internal identification
objectid varchar 255 Neptune identification
objectversion int4 10  √  1 Version of this object
creationtime timestamp 29,6  √  null Creation date and time
creatorid varchar 255  √  null Creator identification
name varchar 255  √  null Name
shortname varchar 255  √  null Short name
organizationalunit varchar 255  √  null Organizational Unit
operatingdepartmentname varchar 255  √  null Operating department
code varchar 255  √  null Zip code
phone varchar 255  √  null Phone number
fax varchar 255  √  null FAX number
email varchar 255  √  null Email
registrationnumber varchar 255  √  null Registration number

Analyzed at lun. nov. 07 16:59 CET 2011

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc company_pkey
objectid Must be unique Asc company_objectid_key

Close relationships  within of separation: