Magicmonster's Database Coding and Naming Conventions

Quick Table of Contents

Introduction
Coding Conventions
Naming Conventions

1. Introduction

This is a summary of the coding and naming conventions that we use when designing databases.

2. Coding Conventions

Keywords should all be in CAPITALS, while table names and field names should all be lowercase.
SELECT statements should be written to utilise VIEWS, instead of using base tables. This provides a level of encapsulation.
Stored procedures should be used instead of directly inserting into base tables. This also provides a level of encapsulation.

3. Naming Conventions

Script Naming Conventions

Scripts should start with 'cr_' for create scripts.

Table Naming Conventions

Underscores should be used instead of spaces.
Table names should be plural.

e.g. invoice_lines, users, items

View Naming Conventions

Views should end with '_v'

e.g. users_v, invoices_v