Union System

From Muds and Dragons
Jump to: navigation, search

The Union System governs the creation and existence of the Union structure. Unions are a collection of characters with like Professions and set of values or common interests. A Union is formed by a 5th level or higher Commoner building a Headquarters dedicated to their Profession(s).

See Also: Union, Headquarters, Professions

Union Tables

union_table

  • union_id
  • union_name
  • union_type - private, pubic
  • union_founder - id
  • union_founded - date formed
  • union_supervisor - id
  • union_election - last election date
  • union_patron
  • union_gold_crowns - Gold Crowns (donated, earned, won)
  • union_alignment
  • union_reg_fee - entrance fee
  • union_dues - base fee * profession_level
  • union_tutor_id
  • union_description
  • union_rules
  • union_headquarters - building id
  • union_fame

union_professions

  • union_id
  • union_profession_1
  • union_profession_1_level
  • union_profession_2
  • union_profession_2_level
  • union_profession_3
  • union_profession_3_level

union_requirements

  • idx
  • union_id
  • union_req_type (alignment, level, skill, spell, feat, ability, race, religion*)
  • union_req_var
  • union_req_int

<<*>>If religion is required, union must be patroned by the same

union_special

  • idx
  • union_id
  • union_spec_var
  • union_spec_char
  • union_spec_int
  • union_spec_desc

union_members

  • idx
  • union_id
  • char_id
  • member_joined - date joined
  • member_fee_paid - date last paid (year only)
  • member_rank
  • member_donated_coins
  • member_donated_crowns

union_ranks

  • idx
  • union_id
  • union_rank_title
  • union_rank_level
  • union_rank_description

union_log

  • idx
  • union_id
  • char_id
  • action - founded, election, joined, quit, ejected, donated, paid, promoted, demoted, change/setting
  • message
  • game_date
  • real_date