Old Wiki:Character

Character_

Description of the Character_ Table in the EVEmu database.

Field Name	Field Type	Nullable	Key
'characterID'	int(10) unsigned	NOT NULL	PRIMARY
'accountID'	int(10) unsigned	NULL
'title'	varchar(85)	NOT NULL
'description'	text	NOT NULL
'bounty'	double	NOT NULL
'balance'	double	NOT NULL
'aurBalance'	double	NOT NULL
'securityRating'	double	NOT NULL
'petitionMessage'	double	NOT NULL
'logonMinutes'	int(10) unsigned	NOT NULL
'skillPoints'	double	NOT NULL
'skillQueueEndTime'	bigint(20)	NOT NULL
'corporationID'	int(10) unsigned	NOT NULL
'corpRole'	bigint(20) unsigned	NOT NULL
'rolesAtAll'	bigint(20) unsigned	NOT NULL
'rolesAtBase'	bigint(20) unsigned	NOT NULL
'rolesAtHQ'	bigint(20) unsigned	NOT NULL
'rolesAtOther'	bigint(20) unsigned	NOT NULL
'corporationDateTime'	bigint(20) unsigned	NOT NULL
'startDateTime'	bigint(20) unsigned	NOT NULL
'createDateTime'	bigint(20) unsigned	NOT NULL
'ancesteryID'	int(10) unsigned	NOT NULL
'careerID'	int(10) unsigned	NULL
'schoolID'	int(10) unsigned	NOT NULL
'careerSpecialityID'	int(10) unsigned	NOT NULL
'gender'	tinyint(4)	NOT NULL
'stationID'	int(10) unsigned	NOT NULL
'solarSystemID'	int(10) unsigned	NOT NULL
'constellationID'	int(10) unsigned	NOT NULL
'regionID'	int(10) unsigned	NOT NULL
'online'	tinyint(1)	NOT NULL
'freeRespecs'	tinyint(1) unsigned	NOT NULL
'lastRespecDateTime'	bigint(20) unsigned	NOT NULL
'nextRespecDateTime'	bigint(20) unsigned	NOT NULL
'deletePrepareDateTime'	bigint(20) unsigned	NULL
'shipID'	int(10) unsigned	NOT NULL

Description of the fields

'characterID'

The number the character is given. Refers to the entity table.

'accountID'

The account number making the character. Refers to the account table.

'title'

Characters title, if any.

'description'

The self-given in-game description of the character.

'bounty'

Bounty value on this character.

'balance'

ISK this character has.

'aurBalance'

AUR this character has.

'securityRating'

The CONCORD Security Rating this character has.

'petitionMessage'

Any outstanding petition this character has.

'logonMinutes'

Time character has been logged on.

'skillPoints'

Total acquired skill points.

'skillQueueEndTime'

Time the skill Quue will complete.

'corporationID'

The corporation ID this character has joined. Refers to the corporation table.

'corpRole'

More information needed.

'rolesAtAll'

More information needed.

'rolesAtBase'

More information needed.

'rolesAtHQ'

More information needed.

'rolesAtOther'

More information needed.

'corporationDateTime'

Time the character joined their corporation.

'startDateTime'

Time the character first logged in. (it's the same as createDateTime)

'createDateTime'

Time the character was created.

'ancestryID'

The ancestry of the character. Refers to the chrancestries table.

'careerID'

The career of the character chosen during character creation. Refers to the careers table.

'schoolID'

The school of the character chosen during character creation. Refers to the careers and chrschools table.

'careerSpecialityID'

More information needed.

'gender'

0 = Female, 1 = male

'stationID'

Location of the character if docked in a station. If not this value is 0. Refers to the stastations table.

'solarSystemID'

Solar system of the character. Refers to the mapsolarsystems table.

'constellationID'

Constellation the character is in. Refers to the mapsolarsystems table.

'regionID'

Region the character is located. Refers to the mapsolarsystems table.

'online'

If the character is online or not. 0 = Offline.

'freeRespecs'

Number of attribute repecs remaining on this character.

'lastRespecDateTime'

Default value is 0

'nextRespecDateTime'

Default value is 0

'deletePrepareDateTime'

Default value is 0. When a character can be deleted on the log-on screen.

'shipID'

The entity number for the current active ship. Refers to the entity table.