Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



Page History: Data Modelling Standards

Compare Page Revisions

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Mon, Aug 20, 2012, 3:56 PM

Table Names

  • should be a SINGULAR noun
  • should NOT have a "tab" prefix
  • should NOT be a SQL reserved word
  • should NOT contain the company name or application name (e.g., use "AppUser" instead of "AcmeUser")

Column Names

  • Primary Keys with an IDENTITY(1,1) (in SQL Server) or based on a SEQUENCE object (in Oracle) should be named with an "ID" suffix
  • Where possible, columns with a foreign key should be named the same as the primary key field.
  • Boolean (a.k.a. bit or yes/no) columns should be suffixed with "Flag"
  • Name should NOT contain the data type (e.g., no "Date" or "Time" in the column name)
  • Auditing fields should be named "CreatedOn", "CreatedBy", "UpdatedOn", "UpdatedBy".


  • A view based primarily on a single table, with auxiliary information pulled in from other tables should be named with an "Ext" suffix. For example, if you have a "Customer" table, and create a view to pull in the name of the Customer's State/Province, etc., call this view "CustomerExt".

ScrewTurn Wiki version Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2020, Patrick Jasinski.