From EVEDev
This group contain tables, related to Character creation process, bloodlines bonuces etc. These tables start with chr.
|
|
chrRaces
| Table lists available races and bonuces, assigned to created character of Race. Races are numbered like bitmask - 1,2,4,8,16...
|
| Column
| Links to
| Used
| Note
|
| raceID
|
| *
| Unique ID of race. Should be primary key.
|
| raceName
|
| *
| Name of race.
|
| description
|
| *
| Description.
|
| skillTypeID1
| invTypes.typeID
|
| typeID of skill granted for character of this race. Not used, instead there is chrRaceSkills table.
|
| typeID
| invTypes.typeID
|
| typeID of free items granted for character of this race. Not implemented.
|
| typeQuantity
|
|
| Quantity of free items granted for character of this race. Not implemented.
|
| graphicID
| eveGraphics.graphicID
| *
| Logo of this race.
|
| shortDescription
|
| *
| Short description.
|
chrRaceSkills
| List of starting skills and levels for each race.
|
| Column
| Links to
| Used
| Note
|
| raceID
| chrRaces.raceID
| *
| ID of race.
|
| skillTypeID
| invTypes.typeID
| *
| typeID of skill.
|
| levels
|
| *
| Level of skill granted.
|
chrBloodlines
| Bllodlines for newly created characters with starting attributes.
|
| Column
| Links to
| Used
| Note
|
| bloodlineID
|
| *
| Unique ID of bloodline. Should be primary key.
|
| bloodlineName
|
| *
| Name of bloodline.
|
| raceID
| chrRaces.raceID
| *
| ID of race.
|
| description
|
| *
| Description of bloodline.
|
| maleDescription
|
| *
| Description of males in this bloodline.
|
| femaleDescription
|
| *
| Description of females in this bloodline.
|
| shipTypeID
| invTypes.typeID
| *
| typeID of starter ship.
|
| corporationID
| crpNPCCorporations.corporationID
|
| Unkonwn. Seems like main NPC corporation for this bloodline.
|
| perception
|
| *
| Starting attribute - Perception.
|
| willpower
|
| *
| Starting attribute - Willpower.
|
| charisma
|
| *
| Starting attribute - Charisma.
|
| memory
|
| *
| Starting attribute - Memory.
|
| intelligence
|
| *
| Starting attribute - Intelligence.
|
| bonusTypeID
| invTypes.typeID
|
| typeID of bonus for bloodline. Bloodline bonuses not implemented.
|
| skillTypeID1
| invTypes.typeID
|
| typeID of 1st skill granted for bloodline. Not implemented.
|
| skillTypeID2
| invTypes.typeID
|
| typeID of 2nd skill granted for bloodline. Not implemented.
|
| graphicID
| eveGraphics.graphicID
| *
| Icon for this bloodline.
|
| shortDescription
|
| *
| Short description of bloodline.
|
| shortMaleDescription
|
| *
| Short description of males.
|
| shortFemaleDescription
|
| *
| Short description of females.
|
chrAncestries
| Available Ancestries with bonus skills and items.
|
| Column
| Links to
| Used
| Note
|
| ancestryID
|
| *
| Unique ID of ancestry. Should be primary key.
|
| ancestryName
|
| *
| Name of ancestry.
|
| bloodlineID
| chrBloodlines.bloodlineID
| *
| Bloodline to which ancestry belong.
|
| description
|
| *
| Description of ancestry.
|
| perception
|
| *
| Attribute bonus for ancestry - Perception.
|
| willpower
|
| *
| Attribute bonus for ancestry - Willpower.
|
| charisma
|
| *
| Attribute bonus for ancestry - Charisma.
|
| memory
|
| *
| Attribute bonus for ancestry - Memory.
|
| intelligence
|
| *
| Attribute bonus for ancestry - Intelligence.
|
| skillTypeID1
| invTypes.typeID
|
| typeID of 1st skill granted for ancestry. Not implemented.
|
| skillTypeID2
| invTypes.typeID
|
| typeID of 1st skill granted for ancestry. Not implemented.
|
| typeID
| invTypes.typeID
|
| typeID of 1st free items granted for character of this ancestry. Not implemented.
|
| typeQuantity
|
|
| Quantity of 1st free items granted for character of this ancestry. Not implemented.
|
| typeID2
| invTypes.typeID
|
| typeID of 2nd free items granted for character of this ancestry. Not implemented.
|
| typeQuantity2
|
|
| Quantity of 2nd free items granted for character of this ancestry. Not implemented.
|
| graphicID
| eveGraphics.graphicID
| *
| Icon for this ancestry.
|
| shortDescription
|
| *
| Short description of ancestry.
|
chrCareers
| List of careers and schools for each Career.
|
| Column
| Links to
| Used
| Note
|
| raceID
| chrRaces.raceID
| *
| ID of race.
|
| careerID
|
| *
| Unique ID of career. Should be primary key.
|
| careerName
|
| *
| Name of career.
|
| description
|
| *
| Description of career.
|
| shortDescription
|
| *
| Short description of career.
|
| graphicID
| eveGraphics.graphicID
| *
| Icon for this career.
|
| schoolID
| chrSchools.schoolID
| *
| School (AKA starting NPC corp) for this career.
|
chrCareerSkills
| List of skills and levels for each Career.
|
| Column
| Links to
| Used
| Note
|
| careerID
| chrCareers.careerID
| *
| ID of career.
|
| skillTypeID
| invTypes.typeID
| *
| typeID of skill.
|
| levels
|
| *
| Levels of skill added.
|
chrCareerSpecialities
| Specialities for each Career.
|
| Column
| Links to
| Used
| Note
|
| careerID
| chrCareers.careerID
| *
| ID of career.
|
| specialityID
|
| *
| Unique ID of speciality. Should be primary key.
|
| specialityName
|
| *
| Name of speciality.
|
| description
|
| *
| Description of speciality.
|
| shortDescription
|
| *
| Short description of speciality.
|
| graphicID
| eveGraphics.graphicID
| *
| Icon for this speciality.
|
| departmentID
|
|
| Unknown.
|
chrCareerSpecialitySkills
chrSchools
chrSchoolAgents
| List of tutorial agents for starting Schools.
|
| Column
| Links to
| Used
| Note
|
| schoolID
| chrSchools.schoolID
| *
| ID of school.
|
| agentIndex
|
| *
| Ordinal number of agent.
|
| agentID
| agtAgents.agentID
| *
| ID of agent.
|
chrAttributes
| Five base Attrinutes annotated.
|
| Column
| Links to
| Used
| Note
|
| attributeID
|
| *
| Unique ID of attribute. Should be primary key.
|
| attributeName
|
| *
| Name of attribute.
|
| description
|
| *
| Description of attribute.
|
| graphicID
| eveGraphics.graphicID
| *
| Icon for attribute.
|
| shortDescription
|
| *
| Short description of attribute.
|
| notes
|
| *
| Note about attribute usage.
|
chrFactions
| All main Factions found in game.
|
| Column
| Links to
| Used
| Note
|
| factionID
|
| *
| Unique ID of faction. Should be primary key.
|
| factionName
|
| *
| Name of faction. Also see eveNames table linked on eveNames.itemID=chrFactions.factionID
|
| description
|
| *
| Description of faction.
|
| raceIDs
|
| *
| Sum (or Logical AND) of raceID's involved in faction. For exaple, Guristas have here 9 = Caldari (1) + Gallente(8).
|
| solarSystemID
| mapSolarSystems.solarSystemID
| *
| Solar system of faction capital.
|
| corporationID
| chrNPCCorporations.corporationID
| *
| NPC corporation that represent factions.
|
| sizeFactor
|
| *
| Size of faction. More datail need.
|
| stationCount
|
| *
| Number of stations owned by faction.
|
| stationSystemCount
|
| *
| Number of systems with stations owned by faction.
|
