| CandidateAccount | Username | Candidate | LoginReminder | LastLogin | Passphrase | |
| VARCHAR(40) | Ref. Candidate OID | INT (init =0) | TIMESTAMP | VARCHAR(50) | VARCHAR(20) |
| CompanyAccount | Username | Company | LoginReminder | LastLogin | Passphrase | |
| VARCHAR(40) | Ref. Company OID | INT (init =0) | TIMESTAMP | VARCHAR(50) | VARCHAR(20) |
| Employer | Company | City | Country |
| VARCHAR(30) | VARCHAR(30) | Ref. Country OID |
| EmployerCandidate | Candidate | Employer | From | To | Remarks | Reference |
| Ref. Candidate OID | Ref. Employer OID | DATE | DATE | TEXT (Null) | VARCHAR (Null) | |
| Function | Pensum | |||||
| VARCHAR(20) | TINYINT UNSIGNED |
| Candidate | Account | Lname | Fname | Sex | Street | HouseNumber | City | PLZ | PHONE |
| Ref. CandidateAccount | VARCHAR(25) | VARCHAR(20) | ENUM('w','m') | VARCHAR(50) | VARCHAR(5) | VARCHAR(30) | MEDIUMINT UNSIGNED | VARCHAR(25)
(Null) |
|
| Fax | Picture | Birthdate | Residence | Nationality | Competence | Status | AIESECMember | MobilePhone | |
| VARCHAR(25) (Null) | MEDIUMBLOB (Null) | DATE | VARCHAR(50) (Null) | VARCHAR(25) | TEXT (Null) | BIT | BIT | VARCHAR(25) (Null) |
| SchoolCandidate | School | Candidate | From | To | Diploma | Remarks |
| Ref School OID | Ref. Candidate OID | DATE | DATE | Ref. Graduation OID (Null) | TEXT (Null) |
| School | Name | Location | Type |
| VARCHAR(50) | VARCHAR(40) | Ref. Schooltype OID |
| Schooltype | Description |
| VARCHAR(40) |
| Profile | Name | MinSchoolType | MaxSchoolType | Company | Interval | LastNotification | MatchTree | Notify | NeedsRematching |
| VARCHAR(40) | Ref. Schooltype OID | Ref. Schooltype OID | Ref. Company OID | INT | TIMESTAMP | MEDIUMBLOB | BIT (init=true) | BIT (init=true) |
| Company | Account | Name | Location | GraduatesPerYear | ShortDescription | Earnings |
| Ref. CompanyAccount | VARCHAR(30) | VARCHAR(40) | INTEGER (Null) | TEXT (Null) | INTEGER (Null) | |
| Presence | Active | Industry | URL | NumberEmployees | Contact | |
| VARCHAR(40) (Null) | BIT | Ref. Industry OID (Null) | VARCHAR(50) (Null) | INTEGER (Null) | Ref. Contactperson OID |
| Contactperson | Name | Fax | |
| VARCHAR(40) | VARCHAR(50) | VARCHAR(20) (Null) |
| Software | Description |
| VARCHAR(40) |
| Programming | Description |
| VARCHAR(40) |
| Operatingsystem | Description |
| VARCHAR(40) |
| SoftwareProfile | Software | Profile | Mandatory | MinCapability | LeafNumber |
| Ref. Software OID | Ref. Profile OID | BIT | Ref. CompCapability | INTEGER (null) |
| ProgrammingProfile | Language | Profile | Mandatory | LeafNumber | MinCapability |
| Ref. Programming OID | Ref. Profile OID | BIT | INTEGER (null) | Ref. CompCapability |
| OperatingsystemProfile | System | Profile | LeafNumber | Mandatory | MinCapability |
| Ref. Operatingsystem OID | Ref. Profile OID | INTEGER (null) | BIT | Ref. CompCapability |
| CompCapability | Description | Ordinal |
| VARCHAR(40) | INTEGER |
| LanguageCapability | Description | Ordinal |
| VARCHAR(40) | INTEGER |
| SoftwareCandidate | Software | Candidate | Capability |
| Ref. Software OID | Ref. Candidate OID | Ref. CompCapability OID |
| ProgrammingCandidate | Language | Candidate | Capability |
| Ref. Programming OID | Ref. Candidate OID (Null) | Ref. CompCapability OID |
| OperatingsystemCandidate | System | Candidate | Capability |
| Ref. Operatingsystem OID | Ref. Candidate OID | Ref. CompCapability OID |
| Association | Description |
| VARCHAR(40) |
| AssociationCandidate | Candidate | Association | Function |
| Ref. Candidate OID | Ref. Association OID | VARCHAR(40) (null) |
| Language | Description |
| VARCHAR(40) |
| LanguageCandidate | Candidate | Language | Diploma | Written | Spoken |
| Ref. Candidate OID | Ref. Language OID | TEXT (null) | Ref. LanguageCapability OID | Ref. LanguageCapability OID |
| Hobby | Title | Candidate | Description | Priority |
| VARCHAR | Ref. Candidate OID | TEXT (Null) | TINYINT UNSIGNED (Null) |
| LanguageProfile | MinSpoken | MinWritten | Mandatory | Diploma | Profile | Language |
| Ref. LanguageCapability OID (Null) | Ref. LanguageCapability OID (Null) | BIT | VARCHAR(40) (Null) | Ref. Profile OID | Ref. Language OID |
| CandidateProfile | Candidate | Profile | MatchingTime | Deleted |
| Ref. Candidate OID | Ref. Profile OID | TIMESTAMP | BIT (init = false) |
| Jobwish | Candidate | Industry | Area | Function | Pensum | Remarks |
| Ref. Candidate OID | Ref. Industry OID (Null) | Ref. Area OID (Null) | VARCHAR (Null) | TINYINT UNSIGNED (Null) | TEXT (Null) |
| Country | Description |
| VARCHAR(40) |
| Graduation | Description |
| VARCHAR(40) |
| Area | Description |
| VARCHAR(40) |
| Industry | Description |
| VARCHAR(40) |
| MailQueue | Priority | Time | |
| MEDIUMBLOB | INTEGER | TIMESTAMP |
| MatchQueue | Candidate | Time |
| Ref. Candidate OID | TIMESTAMP |