Table chouette_v17.chouette.ptnetwork
Public Transport Network

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('ptnetwork_id_seq'::regclass)
line.ptnetworkid line_ptnetwork_fkey N
Internal identification
objectid varchar 255 Neptune identification
objectversion int4 10  √  null Version of this object
creationtime timestamp 29,6  √  null Creation date and time
creatorid varchar 255  √  null Creator identification
versiondate date 13  √  null PTNetwork version date
description varchar 255  √  null description
name varchar 255  √  null Name
registrationnumber varchar 255  √  null Registration unique number
sourcename varchar 255  √  null data producer name
sourceidentifier varchar 255  √  null data producer identifier
comment varchar 255  √  null Comment

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc ptnetwork_pkey  
objectid Must be unique Asc ptnetwork_objectid_key  
registrationnumber Must be unique Asc ptnetwork_registrationnumber_key This unique column is also nullable

Close relationships  within of separation: