• SQLite 3.10 and higher

• Singular UpperCamelCase for tables. E.g. UserLogin
• Singular lowerCamelCase for columns. E.g. phoneNumber
• Always try to use names that make sense and are descriptive of their purpose
• Single column primary key fields should be named id
• Use the following pattern for constraints and indexes: {tablename}_{prefix}_{columnname(s)} where the prefix is one of the following:
  • pk for a Primary Key constraint
  • uk for a Unique constraint
  • ix for any other kind of index
  • fk for a Foreign Key constraint
  • ck for a Check constraint

SQLite Database System Design and Implementation, 2nd Edition by Sibsankar Haldar, Self-published (2016) This book provides a comprehensive description of SQLite database system. It describes design principles, engineering trade-offs, implementation issues, and operations of SQLite.

• SQLite Documentation on SQLite.org
• User Profiles Data Model on DatabaseAnswers.org
• Table Naming Dilemma: Singular vs. Plural Names on StackOverflow.com

Copyright © 2016 Membership Database contributors. This source code is licensed under the MIT license found in the LICENSE.txt file. The documentation to the project is licensed under the CC BY-SA 4.0 license.