Description

This is a description of the table.

Table Structure

ID	Type	Name	Description	Properties	Links
1	Number	allianceEID	The EID of the alliance.	PRIMARY ???
2	String	name	The name of the alliance.
3	String	nick	The tag of the alliance.
4	String	note	Internal notes for developers.
5	DateTime	creation	When the alliance was created.
6	Boolean	defaultAlliance	Is this an default-group alliance?
7	Boolean	active	Is this alliance active?
8	String	logoresource	Link to the logo's file ???
9	Number	id	???	PRIMARY ???
10	Number	raceid	The race the alliance belongs to. ???
11	Object	alliancemembers	A list of members in this alliance.	FOREIGN

Notes

defaultAlliance

Player alliances should have this value false. NPC Alliances should typically be true.

alliancemembers

Pretty sure it's just:

SELECT * FROM alliancemembers WHERE alliancemembers.allianceEID = alliances.allianceEID

See Also

• Corporations