CREATE TABLE Route ( ID: Name BriefDesc Hardware (e.g. bus, train, streetcar, etc.) StopDensity (e.g. express,local) Accessible (wheelchair, boolean) Bikes (boolean) *Approx service areas (many-many) *Services (1-many) RouteServiceArea RouteID ServiceID ServiceArea ID Description Service RouteID ID ServiceDesc First _7_9 _9_16 _16_19 Eve Last Owl Stop ID Desc Street1 Street2 Lat Lon RouteStop RouteID StopID Direction (ie. inbound outbound) Time