Added "parameter_type" table and associated FK

lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly

https://sql.ophir.dev

MIT License

880 stars 62 forks source link

Added "parameter_type" table and associated FK #427

Closed pchemguy closed 1 week ago

pchemguy commented 1 week ago

The "parameter"("type") field contained two variants of BOOLEAN name (the other one being 'BOOL') due to lack of natural "enum" constraint. Added parameter_type table and associated foreign key to ensure consistency. Also replaced all "BOOL" instances with "BOOLEAN".

lovasoa commented 1 week ago

We should probably also remove at least one of (number, integer, real).

pchemguy commented 1 week ago

Here you go

lovasoa commented 1 week ago

Thank you!