Table of Contents

Class GuildEntity

Namespace
FishMMO.Database.Npgsql.Entities
Assembly
FishMMO-DB.dll

Database entity representing a guild.

public class GuildEntity : IVersionedEntity
Inheritance
GuildEntity
Implements
Inherited Members

Properties

Applications

Gets or sets the guild's pending recruitment applications.

public List<GuildApplicationEntity> Applications { get; set; }

Property Value

List<GuildApplicationEntity>

Blurb

Recruitment advertisement shown in the guild directory.

public string Blurb { get; set; }

Property Value

string

Remarks

Separate from Notice and MessageOfTheDay on purpose. Those two are written for people who are already members; this one is written for people who are not, and a guild that had to advertise with its internal notice would either leak its business or stop using the notice.

Characters

Gets or sets the guild membership relationships.

public List<CharacterGuildEntity> Characters { get; set; }

Property Value

List<CharacterGuildEntity>

ID

Primary key.

public long ID { get; set; }

Property Value

long

IsRecruiting

Whether the guild is listed in the recruitment directory and accepting applications.

public bool IsRecruiting { get; set; }

Property Value

bool

MessageOfTheDay

Message of the day displayed to members on login.

public string MessageOfTheDay { get; set; }

Property Value

string

Name

Display name.

public string Name { get; set; }

Property Value

string

NameLowercase

Lowercase copy of guild name for lookups.

public string NameLowercase { get; set; }

Property Value

string

Remarks

This value is stored as a computed column in PostgreSQL (generated from Name). It exists to support efficient case-insensitive lookups and uniqueness enforcement.

Notice

Guild notice text.

public string Notice { get; set; }

Property Value

string

Ranks

Gets or sets the guild's editable rank rows.

public List<GuildRankEntity> Ranks { get; set; }

Property Value

List<GuildRankEntity>

Tags

Comma-separated recruitment tags, lower-cased, used by directory search.

public string Tags { get; set; }

Property Value

string

TimeCreated

Row creation timestamp (UTC).

public DateTime TimeCreated { get; set; }

Property Value

DateTime

Version

Application-level concurrency token. Incremented on every write to detect stale updates.

public long Version { get; set; }

Property Value

long