Template:category:web play
Note: SQL database Notes - Please read


Reference Tables











Contents

[top]Reference tables

In DB: No, Updated: 8-29-2010, Wiki Updated: 8-29-2010

[top]"regions"

In DB: Yes, Updated: 8-29-2010
  • region_ID
  • region_description
  • region_Name
  • continentID

[top]"continents"

  • continent_ID
  • continent_name
  • template

[top]"worksCost"

  • worksCost_ID
  • woodBridge
  • stoneBridge
  • ferry
  • fortificationP
  • fortificationH
  • highwayPlainSteppeScrub
  • highwayDesertForestHill
  • highwaySwampTundra
  • highwayGlacierMountain
  • palace
  • seaport
  • ship
  • shipyard
  • wondrous

[top]"worksMaintance"

  • worksCost_ID
  • woodBridge
  • stoneBridge
  • ferry
  • fortificationP
  • fortificationH
  • highwayPlainSteppeScrub
  • highwayDesertForestHill
  • highwaySwampTundra
  • highwayGlacierMountain
  • palace
  • seaport
  • ship
  • shipyard
  • wondrous

[top]"classList"

  • class_ID
  • class_name
  • hitDice
  • startFeats
  • startSkills
  • skillperlevel
  • gainSkillLastLevel
  • FeatPerLevel
  • gainFeatLastLevel
  • description
  • requiredAlignment
  • officalClass
  • banned

[top]"classSkills"

  • class_ID
  • skill_ID

[top]"crossSkills"

  • class_ID
  • skill_ID

[top]"featList"

  • feat_ID
  • featlist_name
  • featList_description
  • officialFeat
  • banned

[top]"bloodAbilityList"

  • bloodAbility_id
  • bloodAbilityListname
  • powerRequired
  • minStrengthAvailable
  • maxStrengthAvailable
  • derivations
  • featList _description
  • official
  • banned

[top]"spellList"

  • spell_ID
  • spell_level
  • spellList_name
  • school
  • reqSorLevel
  • reqDrdLevel
  • reqClerLevel
  • reqWizLevel
  • targetType
  • baseDuration
  • durationLabel
  • addDurRatio
  • addDurLabel
  • saveThrow
  • spellResist
  • spellRequires
  • durationLabel
  • additionalDurationRatio
  • additionalDurationLabel
  • saveThrow
  • spellResist
  • spellRequires
  • range
  • components
  • spellList_description
  • official
  • banned

[top]"domainSpellList"

  • dmnSpell_ID
  • domainSpell_level
  • domainSpell_name
  • school
  • reqSorLevel
  • reqDrdLevel
  • reqClerLevel
  • reqWizLevel
  • targetType
  • baseDuration
  • durationLabel
  • addDurRatio
  • addDurLabel
  • saveThrow
  • spellResist
  • spellRequires
  • gpFormatType
  • gpPerTarget
  • gpTargetLabel
  • rpFormatType
  • rpPerTarget
  • rpRatioDivisor
  • rpTargetLabel
  • domainSpell_description
  • official
  • banned

[top]"schoolsAllowed"

  • class_ID
  • divination
  • enchantment
  • abjuration
  • evocation
  • conjuration
  • transmutation
  • illusion
  • necromancy
  • elemental
  • psionic

[top]"diety"

  • diety_ID
  • diety _name
  • diety _title
  • symbol
  • patronRace
  • diety _alias
  • diety _alignment
  • portfolio
  • domains - probably needs it's own table since not all diety have same number of domains
  • favoredWeapon
  • diety _description
  • dogma
  • relationship
  • diety _allies
  • foes
  • others
  • official
  • banned

===="province_status"====Still developing!
  • province_Status_ID
  • province_Status_name
  • province_Status_shortDescription
  • province_Status_description
  • province_icon_id
  • province_family_id - is it domain spell, seasonal, military type of status
  • isEffectNegative



Live Database Tables











[top]Live Portion

[top]"persona" - character stats

Created: Yes, DB Updated: 8-29-2010
  • persona_ID
  • persona_name
  • persona_abbreviation
  • persona_title
  • persona_description
  • reputation
  • persona_alignment
  • persona_level_total
  • HPMax
  • HPCurrent
  • strength
  • dexterity
  • constitution
  • intelligence
  • wisdom
  • charisma

[top]"persona_regency"

  • regency_id
  • deriviation
  • bloodStrength
  • bloodscore

[top]"md_persona"

  • md_persona_id
  • charLocation
  • trainedThisRound
  • isALieutenant
  • lastaccessed
  • template
  • isAllowed
  • rounds_carried_max_rp
  • regencyPool - for variant rule for lieutenants to under go a ceremony to transfer rp to take actions

[top]"domains" - domain basics

In DB: Yes, Updated: 8-29-2010
  • domain_ID
  • domain_name
  • courtLocation
  • courtLevel
  • courtType
  • palaceLevel
  • TreasuryGP
  • attitude
  • template

[top]"province"

In DB: Yes, Updated: 8-29-2010
  • province_ID
  • province_name
  • province_level
  • province_source
  • fortified
  • province_attitude
  • terraintype_ID
  • tax_level
  • province_description
  • province_short_description

Province_capital

[top]"md_province"

  • caerbhaighlein - a number value representing it's max force
  • currentCaerbahighlein - like hp it regains once disrupted
  • template
  • hasRiver
  • hasLake
  • hasCoastal
  • bonusSource
  • bonusPopulation
  • ruledUpThisTurn
  • usedGuild
  • usedLaw
  • UsedTemple
  • usedSource
  • sourceSpent
  • divineSpent
  • musterSpent

[top]"holds" - decided to do all 4 types in one table

  • holdingID
  • holds_level
  • bastion_level - this reflects individual holding defenses
  • protected - this reflects if the lawful regent of the province extends his protection to the holding in question
  • visible - not hidden via any means
  • contested
  • holds_name
  • holds_type
  • ruledUpThisTurn
  • typeSpecificVariable - source & temple's have a cap on how much RP can be used in some variants, guilds have cap on # of routes can be attached to it
  • template

[top]"Trade_Routes" - who owns & where it starts/stops

  • route_ID
  • startGuild_ID
  • endGuildID
  • startProvince
  • endProvince

===="Route_Path"==== - which provinces the route passes through to get to destination, needed to reflect where raids are possible
  • route_ID
  • province_ID
  • template

[top]"Ley_lines" - setup to allow any of 7 variants on handling ley line connections

  • lay_Line_ID
  • start_Province_ID
  • start_Source_ID
  • end_Province_ID
  • masked
  • warded
  • sunderContested - name is meaningless, looking to represent how many times attacked & how close to gone the line is either bool or int reflecting # of hits it's taken

[top]"spy_Report_Provinces" - this is when a player had access to another province without being neighbor or having units near by

  • spy_report_id
  • domain_ID
  • province_ID
  • report_Turn
  • report_Round

[top]"alliance"

  • alliance_ID
  • domain_ID
  • domain_ID2
  • type
  • permanent_Envoy
  • vassal
  • gold_Tribute
  • regency_Tribute
  • visible
  • objective
  • announcement

===="works"==== - this is completed only
  • works_ID
  • works_level
  • works_type
  • works_name
  • works_description
  • upkeep

[top]"works_Progress" - once completed a works is placed in other table

  • works_progress_ID
  • works_Progress_level
  • worksType
  • works_Progress_Name
  • works_Progress_description
  • GP_Spent
  • GP_Goal

[top]"decrees"

  • decree_ID
  • domain_ID
  • scope
  • turn
  • round
  • messenger
  • message
  • alliance_ID
  • war_ID

Note: This is the cross lists - M:M connections for unknown number of links to unknown number

[top]"x_domain_deity"

  • deity_id
  • domain_id

[top]"x_domain_holding"

  • domain_id
  • holding_id

[top]"x_domain_province"

  • domain_id
  • province_id

[top]"x_domain_persona"

  • domain_id
  • persona_id

[top]"x_domain_Route_Path"

  • route_ID
  • domain_ID

[top]"x_domain_lay_lines"

  • lay_Line_ID
  • domain_id

[top]"x_domain_works"

  • works_id
  • domain_id

[top]"x_domain_works_progress"

  • works_progess_id
  • domain_id

[top]"x_province_holding"

  • province_id
  • holding_id

[top]"x_neighbors"

  • provinceID
  • provinceID

[top]"x_province_region"

  • province_id
  • region_id

[top]"x_province_protects"

  • province_id
  • holding_id

[top]"x_province_leyroute" - which provinces the route passes through to get to destination, needed for custom rules and use of disrupt dmn magic spells

  • ley_Line_ID
  • province_ID

[top]"x_province_works_progress"

  • province_id
  • works_progress_id

[top]"x_province_works"

  • province_id
  • works_id

[top]"x_province_spyNetworks"

  • province_ID
  • domain_ID

[top]"x_Provinces_status"

  • status_ID
  • province_ID

[top]"x_spy_Report_Alliance" - this reflects which courts have cracked or intercepted each other's diplomacy

  • domain_ID
  • allianceID

[top]"presistantDomainSpell"

  • domain_Spell_Instance_ID
  • instance_Owner_ID
  • province_ID
  • targetted_Province_ID
  • domain_Spell_ID
  • Difficult_yChecked
  • intial_Duration_Turn
  • intial_Duration_Round
  • end_Turn
  • end_Round

[top]"persona_identity"

  • persona_id
  • identity_id

[top]"personsa_classes"

  • persona_ID
  • class_ID

[top]"personsa_dieties"

  • domain_ID
  • personsa_ID

[top]"personsa_spells"

  • spell_ID
  • persona_ID

[top]"personsa_domain_Spells"

  • persona_ID
  • domainSpell_ID

[top]"personsa_blood_Abilities"

  • persona_ID
  • bloodAbility_ID

[top]"personsa_feats"

  • persona_ID
  • feat_ID

[top]"personsa_skills"

  • persona_ID
  • skill_ID

[top]"class_skills_cross_class"

  • class_id
  • skill_id



Administrative Tables











[top]administrative Portion

In Database: Yes, Update: 8-16-2010

[top]"mechanics"

  • campaign_ID
  • charTrainingFrequency
  • onlyOfficial
  • multiClasses
  • MCRegency
  • 1stRdInvesture
  • 1stRoundContest
  • 1stRoundNewholding
  • visibleLieutanentcy
  • basicSieges
  • alliedSharedInformationDefault
  • standardWorksCost
  • opposedScoutChecks
  • goldTransfersRaided
  • seasonalWarfare
  • notPayTributeRegencyOption
  • notPayTributeGoldOption

[top]"variants" - these could probably be in mechanic's table but are vanilla house rules for BCRS

  • campaign_ID
  • mustering
  • tribalUnits
  • reownedUnits
  • taxModifers
  • ruleByCouncil
  • regencySpellMax
  • freeLuietenant
  • freeHeirLooms
  • earlyLeadership
  • exp4DmnAction
  • limitedMagicalTransport
  • sourceReclaims

[top]"dmList"

  • campaign_ID
  • identity

[top]"campaigns" - seperate table from dmList since many dm's run same game

  • campaign_ID
  • campaign_Name

[top]"regionsCampaign"

This is region's allowed in a DM's campaign
  • region_ID
  • campaign_ID

[top]"campaignPersona"

  • campaign_ID
  • persona_ID
  • identity - I looked at the number of joins to make these 5 tables work together & putting id here saved us alot of cpu power

[top]"authentification"

  • identity
  • login
  • ppassword
  • CreationIP
  • sessionIP
  • timesFailedPassword
  • lastAccessed

[top]"loginIPTracking"

  • identitiy
  • date
  • time
  • IP

Tags for this Page

Similar Pages

  1. Mirviriam/BRCS SQL Notation
    By Mirviriam in forum User
    Comments: 0
    Last Post: 08-30-2010, 12:51 AM
  2. Mirviriam
    By Mirviriam in forum User
    Comments: 0
    Last Post: 05-24-2010, 04:38 AM
  3. Mirviriam/Sieges
    By Mirviriam in forum User
    Comments: 0
    Last Post: 05-17-2010, 02:45 AM
  4. Mirviriam/SpellBrainStorm
    By Mirviriam in forum User
    Comments: 0
    Last Post: 09-25-2009, 09:45 AM

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.