naming-conventions-sqlite
These are the Naming Conventions I am going to use SQLite databases. As far as I know, there are no best practices in SQLite, so you could come up with your own. These are the ones I am going to use, so everything is consistent.
| Object | Notation | Length | Plural | Prefix | Suffix | Example |
|---|---|---|---|---|---|---|
| Database File | snake_case | 30 | No | No | .db |
my_database.db
|
| Table Column | snake_case | 128 | No | No | No |
my_column
|
| Check Constraint | snake_case | 128 | No |
ck_
|
No |
ck_table_description
|
| Table Foreign Key | snake_case | 128 | No |
fk_
|
No |
fk_source_colum_target_target_column
|
| Table Index | snake_case | 128 | No |
ix_
|
No |
ix_table_column_1_column_2
|
| Table Unique Index | snake_case | 128 | No |
ux_
|
No |
ux_table_columns
|
| View | snake_case | 128 | No |
vi_
|
No |
vi_viewname
|