Web applications will use MySQL by default unless under exceptional circumstances and approved by a lead developer.
Windows Stack applications will use MSSQL.
UWP applications requiring offline functionality will use SQLite.
iOS applications can either use CoreData OR Realm.
Android applications can use Realm.
A list of approved database management tools can be found in the approved software list.
ID’s should be either auto-incrementing unsigned integers, or GUIDs/UUIDs.
Columns are to be defined in snake_case ONLY.
Columns that are relationships to other tables should reference the id column ideally. If the column references a
record from the users table - it should be named user_id.
On all relationship columns, a foreign key (FK) should be defined.
This has a few benefits, such as the automatic indexing in MySQL and MariaDB.
Note: Indexes are NOT automatically created in PostgreSQL & Microsoft SQL Server. These should be added separately.