Table chouette_v17.chouette.line
Public Transport Line

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('line_id_seq'::regclass)
facility.lineid faci_line_fkey C
groupofline_line.lineid groupofline_line_fkey C
route.lineid route_line_fkey C
routingconstraints_lines.lineid routingconstraint_line_fkey C
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
comment varchar 255  √  null Comment
number varchar 255  √  null Number of the line (characters)
publishedname varchar 255  √  null Public name for travelers
registrationnumber varchar 255  √  null Registration number
transportmodename varchar 255  √  null Transport Mode (Bus, Train, ...)
mobilityrestrictedsuitable bool 1  √  null Indicate whenever the line is suitable for mobility restricted persons
userneeds int8 19  √  null bit encoded list of userneeds enum value
ptnetworkid int8 19  √  null
ptnetwork.id line_ptnetwork_fkey N
PTNetwork reference
companyid int8 19  √  null
company.id line_company_fkey N
Company reference
groupoflineid int8 19  √  null
groupofline.id line_glines_fkey N
GroupOfLine reference

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc line_pkey

Close relationships  within of separation: