Create following:

• Database,
• DataSeed

stanislawpolanski/MrnWebApi#94

API will not be developed, delete from the code.

Drop stations.railwayunitid column

KRAKÓW => Kraków etc.

Stations is a child of objects of interest.

RailwayUnits => RailwayUnit etc.

Change datamodel so that stations and rolling stock are stored in one table. Additional info about station is moved into additional table.

if there is no object of interest with such id then insert should fail

When all the data is merged into the database then delete all the merge-related programmability.

Revert API changes - plain db might be used in .net web app

Check if some indexes would be helpful

Add new column: OwnerId

Eg assign railway unit to new PLK station (intersection of station and units geometry)

There is no photos data in the set.

Parse sys.geometries instantly instead of making an update

Later, delete all useless types, procedures etc.

When deleting a station, database should delete related entities (by foreign keys).

• station to geometries
• station trigger
• object of interest trigger

Queries:
select dbo.Railways.Number as RailwayNumber, dbo.Railways.Name as RailwayName, dbo.Stations.Name as StationName, CentreKmpost from dbo.StationsToGeometries
left join dbo.Stations on dbo.StationsToGeometries.StationId = dbo.Stations.Id
left join dbo.Railways on dbo.StationsToGeometries.RailwayId = dbo.Railways.Id
order by RailwayNumber, dbo.Railways.Id, CentreKmpost

select * from dbo.Railways
left join dbo.StationsToGeometries on dbo.Railways.Id = dbo.StationsToGeometries.RailwayId
left join dbo.Stations on dbo.StationsToGeometries.StationId = dbo.Stations.Id
where Number = 118

From second query comes:

Marked stations ought to have RailwayId = 10118

Change from: use Malopolska...
to:
use $(DatabaseName)

Pseudo data model:
https://github.com/stanislawpolanski/MalopolskaRailNetwork/blob/master/MalopolskaRailNetwork/Documents/FinalDataSetAgreement.md

Short data review

Column RailwayUnits.OwnerId should reference to Owners.Id

Duplicate repo to be deleted ('MskDb')

There is no need to duplicate the info about seeding - schema is enough