Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Page History: Data Modelling Standards

Compare Page Revisions



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


Page Revision: Mon, Aug 20, 2012, 4:01 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
  • Should NOT contain underscores
  • The column containing the main descriptive text should be consistently called "Descrip" - OR - "FirstName" + "LastName".
  • 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".
  • Use the following standardized abbreviations
    • Num = Number
    • Descrip = Description

Views

  • 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 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.