User:Mirviriam/BRCS SQL Notation

Template:category:web play

[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

[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

Tags for this Page

Similar Pages

  1. Mirviriam
    By Mirviriam in forum User
    Comments: 0
    Last Post: 05-24-2010, 04:38 AM
  2. Mirviriam/Sieges
    By Mirviriam in forum User
    Comments: 0
    Last Post: 05-17-2010, 02:45 AM
  3. Mirviriam/DomainSpells
    By Mirviriam in forum User
    Comments: 0
    Last Post: 05-16-2010, 11:41 PM
  4. Mirviriam/SQLDB
    By Sorontar in forum User
    Comments: 0
    Last Post: 04-22-2010, 11:57 PM

Bookmarks

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
BIRTHRIGHT, DUNGEONS & DRAGONS, D&D, the BIRTHRIGHT logo, and the D&D logo are trademarks owned by Wizards of the Coast, Inc., a subsidiary of Hasbro, Inc., and are used by permission. ©2002-2010 Wizards of the Coast, Inc.