polyphony-chat / symfonia

A Polyphony chat server, compatible with Spacebar and the Discord API.
Mozilla Public License 2.0
25 stars 3 forks source link

Rewrite migrations statements to contain foreign keys instead of JSON objects #41

Open bitfl0wer opened 3 months ago

bitfl0wer commented 3 months ago

Depends on completion of Remove Json<T> wrapper from all types which should be broken out into own tables.

The migrations should reflect the relations between tables and table entries correctly, instead of storing relations, which are references to other tables, as JSON. Normally, this is referred to as the "first normal form". Every column which could be represented by a chorus or symfonia type should be represented by these types.