User:Mirviriam/BRCS SQL Notation
Show all sections
What links here?
This page's broken linksTemplate:category:web play
description
title
level
name
ID
For example:
Description -> regent_description, domain_description, province_description etc
[top]Nomenclature
Assumptions:
- English language
- The database punched in assumes all abbreviations will be fully spelled out. Thus dmn_ID will be domain_ID & dmnSp_ID will be domainSpell_ID.
- ID, NPC & HP will always have both letters capitalized.
[top]Table Naming
x__ - for cross link or pivot tables
md_ - for tables not related to data directly shown in published materials
md_
[top]Field Naming
- Case: Lower case will be the general rule.
- The normal conventions of NPC, HP, RP & GP will also be observed & not expanded in the behind the scenes programming.
- All common fields which can be used generically in two different tables or shown below will also be prefaced by their table name:
description
title
level
name
ID
For example:
Description -> regent_description, domain_description, province_description etc
[top]Reviews
These appear in multiple tables:
- start_province_ID
- end_province_ID
- GP_spent
- RP_spent
- turn
- round
- template
- is_Allowed
- is_NPC
| Contributors: , |
Created by , 08-30-2010 at 12:51 AM Last edited by , 10-23-2011 at 01:51 PM 0 Comments, 2,232 Views |
Tags for this Page
Similar Pages
-
Mirviriam
By Mirviriam in forum UserComments: 0Last Post: 05-24-2010, 04:38 AM -
Mirviriam/Sieges
By Mirviriam in forum UserComments: 0Last Post: 05-17-2010, 02:45 AM -
Mirviriam/DomainSpells
By Mirviriam in forum UserComments: 0Last Post: 05-16-2010, 11:41 PM -
Mirviriam/SQLDB
By Sorontar in forum UserComments: 0Last Post: 04-22-2010, 11:57 PM
Posting Permissions
Posting Permissions
- You may not create new articles
- You may not edit articles
- You may not protect articles
- You may not post comments
- You may not post attachments
- You may not edit your comments
Bookmarks