Skip to content

guilds

Info

This page was last generated 2023.04.23

Relationship Diagram(s)

Diagram Edit

Relationships

Relationship Type Local Key Relates to Table Foreign Key
Has-Many id guild_bank guildid
Has-Many id guild_ranks guild_id
Has-Many id guild_members guild_id
Has-Many id guild_relations guild1
Has-Many id guild_relations guild2
Has-Many id qs_player_speech guilddbid
One-to-One leader character_data id
One-to-One motd_setter character_data name

Schema

Column Data Type Description
id int Unique Guild Identifier
name varchar Name
leader int Character Identifier
minstatus smallint Minimum Status
motd text Message of the Day
tribute int Tribute
motd_setter varchar Character Identifier
channel varchar Channel
url varchar Website URL