Class CurrencyLedgerEntity

Namespace

FishMMO.Database.Npgsql.Entities

Assembly

FishMMO-DB.dll

One completed currency movement.

public class CurrencyLedgerEntity

Inheritance

object

CurrencyLedgerEntity

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

Written once, after the movement it describes has already happened and its balance change has been persisted. Rows are never updated and never deleted: the table is the economy ledger — what was spent, on what, and whether the transaction completed.

Properties

Amount

Amount moved. Always positive; State says which direction it went.

public long Amount { get; set; }

Property Value

long

CharacterID

The character whose balance moved.

public long CharacterID { get; set; }

Property Value

long

ID

public long ID { get; set; }

Property Value

long

Reason

What the movement was for. Maps to FishMMO.Shared.CurrencyMovementReason.

public int Reason { get; set; }

Property Value

int

State

Absorbed or Returned. Maps to FishMMO.Shared.CurrencyMovementState.

public int State { get; set; }

Property Value

int

Remarks

Set at insert, because the outcome is already known by then. A row left at the column default (Unsettled) is an insert that omitted it, not a transaction still in flight.

TimeCreated

When the movement was recorded.

public DateTime TimeCreated { get; set; }

Property Value

DateTime