Unit Transaction

Submitted by Brutus5000 on Thu, 07/21/2016 - 23:00
Parent element
Semantic

Characters can buy or dispatch units. Both activities get logged in a transaction. The transaction contains meta-data. The individual units per transaction are stored in Unit transaction details.

Table name
unit_transactions
Table structure
  • id [INT, PRIMARY, AUTO_INCREMENT]
  • fk_character [INT]
  • fk_battle [INT, NULLABLE]: if type=dispatch here goes the battle-id
  • type [CHAR]: [B]uy, [D]ispatch
  • created_at [DATETIME]

Add new comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.