crtRelationships (CCP DB)

From EVEDev

CCP DB Table Categories
System Inventory Character Star Map Stations and Services NPC Corporations and Agents Certifications Planets Translation

[edit] Structure

crtRelationships

List of all relationships between certificates.
Column	Links to	Used	Note
relationshipID		*	Unique ID of the relationship. Should be primary key.
parentID	crtCertificates.certificateID	*	CertificateID of the required certificate. NULL if requirement is a skill.
parentTypeID	invTypes.typeID	*	TypeID of the required skill. NULL if requirement is a certificate.
parentLevel		*	Level of the required skill. NULL if requirement is a certificate.
childID	crtCertificates.certificateID	*	CertificateID of the certificate enabled by the parent certificate or skill.

[edit] Examples