Tabelle StudentRoutes

Spalten

Diese Tabelle hat 9 Spalten.

Mandant

INTEGER · NOT NULL

Verweis auf Tabelle TransportationStops

ID

INTEGER · NOT NULL

Mandantenbezogene, eindeutige ID

EnbreaID

VARCHAR(24)

Externer Identifikator aus ENBREA

Line

INTEGER · NOT NULL

Verweis auf Tabelle TransportationLines

Method

INTEGER

Verweis auf Tabelle TransportationMethods

Origin

INTEGER

Verweis auf Tabelle TransportationStops

Destination

INTEGER

Distance

FLOAT

Duration

FLOAT

Primärschlüssel

Diese Tabelle hat einen Primärschlüssel.

StudentRoutes

Mandant, ID

Fremdschlüssel

Diese Tabelle hat 4 Fremdschlüssel.

FK_STUDENTROUTES_LINES

Line, Mandant » TransportationLines (ID, Mandant) · ON UPDATE CASCADE · ON DELETE CASCADE

FK_STUDENTROUTES_METHODS

Mandant, Method » TransportationMethods (ID, Mandant) · ON UPDATE CASCADE · ON DELETE SET NULL

FK_STUDENTROUTES_ORIGIN

Mandant, Origin » TransportationStops (ID, Mandant) · ON UPDATE CASCADE · ON DELETE SET NULL

FK_STUDENTROUTES_DESTINATION

Destination, Mandant » TransportationStops (ID, Mandant) · ON UPDATE CASCADE · ON DELETE SET NULL

Indizes

Diese Tabelle hat 5 Indizes.

FK_STUDENTROUTES_DESTINATION

Mandant, Destination

FK_STUDENTROUTES_LINES

Mandant, Line

FK_STUDENTROUTES_METHODS

Mandant, Method

FK_STUDENTROUTES_ORIGIN

Mandant, Origin

PK_STUDENTROUTES

Mandant, ID