Here we define a list of SQL custom types that could/should be implemented for each table in the migrations. This markdown has been created after the discovery of custom types in SQL and how to convert them to Rust using Diesel (see this repo).
Proposals of custom types
[ ] users column first_name, last_name and middle_name should not be empty strings.
[ ] user_emails column email should be a valid email.
[ ] @LucaCappelletti94 said we should also have a type for Path
[ ] Should all small enums be custom types? (For example sample states could be a custom enum type instead of populating the table with our csv files)
Custom types
Here we define a list of SQL custom types that could/should be implemented for each table in the migrations. This markdown has been created after the discovery of custom types in SQL and how to convert them to Rust using Diesel (see this repo).
Proposals of custom types
users
columnfirst_name
,last_name
andmiddle_name
should not be empty strings.user_emails
columnemail
should be a valid email.