guild_relations

Relationships

erDiagram
    guild_relations {
        mediumintunsigned guild1
        mediumintunsigned guild2
    }
    guilds {
        int id
        int leader
        varchar motd_setter
    }
    guild_relations ||--o{ guilds : "One-to-One"
    guild_relations ||--o{ guilds : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	guild1	guilds	id
One-to-One	guild2	guilds	id

Schema

Column	Data Type	Description
guild1	mediumint	Unique Guild Identifier 1
guild2	mediumint	Unique Guild Identifier 2
relation	tinyint	Relation