subway
Tables (3)
INTER_STATION (InterStations)
- id (PK) — bigint — Primary key — NOT NULL
- distance (Field) — bigint
- up_station_id (FK) — bigint — Foreign key → STATION.id — NOT NULL
- down_station_id (FK1) — bigint — Foreign key → STATION.id — NOT NULL
- line_id (FK2) — bigint — Foreign key → LINE.id — NOT NULL
LINE (lines)
- id (PK) — bigint — Primary key — NOT NULL
- line_name (Field) — varchar
- line_color (Field1) — varchar
STATION (Stations)
- id (PK) — bigint — Primary key — NOT NULL
- station_name (Field) — varchar