10.1 - Structure of the data tables in moveon
accommodation table
Content: accommodation data
| Name | Type | Size | Description |
|---|---|---|---|
| accommodation_id | int | ID | |
| accommodation_lastupdate | timestamp | Date and time of last update | |
| accommodation_lastuser_id | int | Last updated by user ID | |
| accommodation_residence | varchar | 50 | Name of residence |
| accommodation_number | varchar | 15 | Number |
| accommodation_maxoccupancy | smallint | Maximum occupancy | |
| accommodation_co | varchar | 35 | c/o |
| accommodation_street | varchar | 150 | Street |
| accommodation_postcode | varchar | 15 | Post code |
| accommodation_city | varchar | 50 | City |
| accommodation_active | smallint | Active (yes:1/no:0) |
agreementitems table
Content: details of planned mobility flows for an agreement
| Name | Type | Size | Description |
|---|---|---|---|
| agritem_id | int | ID | |
| agritem_lastupdate | timestamp | Date and time of last update | |
| agritem_lastuser_id | int | Last updated by user ID | |
| agritem_agreement_id | int | Attachment agreement ID | |
| agritem_type_id | varchar | 5 | Type ID (sms: student mobility for studies / smp: student mobility for placement / tm: teaching mobility / st: staff training) |
| agritem_numberout | smallint | Number of outgoing mobilities | |
| agritem_durationout | smallint | Duration of each outgoing mobility | |
| agritem_numberin | smallint | Number of incoming mobilities | |
| agritem_durationin | smallint | Duration of each incoming mobility | |
| agritem_subject_id | varchar | 4 | Subject area ID |
| agritem_levels | varchar | 5 | Study level ID |
| agritem_description | varchar | 255 | Description |
| agritem_homedeptcontact_id | int | Internal departmental contact ID | |
| agritem_extdeptcontact_id | int | External departmental contact ID |
agreements table
Content: agreement data
| Name | Type | Size | Description |
|---|---|---|---|
| agreement_id | int | Agreement ID | |
| agreement_lastupdate | timestamp | Date and time of last update | |
| agreement_lastuser_id | int | Last updated by user ID | |
| agreement_cooperation_id | int | Attachment cooperation ID | |
| agreement_institution_id | int | Attachment institution ID | |
| agreement_name | varchar | 150 | Name |
| agreement_startyear_id | smallint | Start year ID | |
| agreement_status_id | smallint | Agreement status ID | |
| agreement_endyear_id | smallint | End year ID | |
| agreement_agrtype_id | int | Agreement type ID | |
| agreement_signdate | date | Signature date | |
| agreement_renewaldate | date | Renewal date | |
| agreement_contract | smallint | - | |
| agreement_homeinstcontact_id | int | Internal institutional contact ID | |
| agreement_homeadmcontact_id | int | Internal administrative contact ID | |
| agreement_homesigncontact_id | int | Internal signatory ID | |
| agreement_extinstcontact_id | int | External institutional contact ID | |
| agreement_extadmcontact_id | int | External administrative contact ID | |
| agreement_extsigncontact_id | int | External signatory ID | |
| agreement_remarks | text | Remarks | |
| agreement_free01 | varchar | 255 | Free field 1 |
| agreement_free02 | varchar | 255 | Free field 2 |
| agreement_free03 | varchar | 255 | Free field 3 |
| agreement_free04 | varchar | 255 | Free field 4 |
| agreement_free05 | varchar | 255 | Free field 5 |
| agreement_free06 | varchar | 255 | Free field 6 |
| agreement_free07 | varchar | 255 | Free field 7 |
| agreement_free08 | varchar | 255 | Free field 8 |
| agreement_free09 | varchar | 255 | Free field 9 |
| agreement_free10 | varchar | 255 | Free field 10 |
| agreement_free11 | varchar | 255 | Free field 11 |
| agreement_free12 | varchar | 255 | Free field 12 |
agreementtypes table
Content: agreement type data
| Name | Type | Size | Description |
|---|---|---|---|
| agrtype_id | int | ID | |
| agrtype_lastupdate | timestamp | Date and time of last update | |
| agrtype_lastuser_id | int | Last updated by user ID | |
| agrtype_name | varchar | 50 | Name |
| agrtype_name_en | varchar | 50 | English translation of name |
| agrtype_name_de | varchar | 50 | German translation of name |
| agrtype_name_fr | varchar | 50 | French translation of name |
| agrtype_name_es | varchar | 50 | Spanish translation of name |
| agrtype_name_it | varchar | 50 | Italian translation of name |
| agrtype_type_id | smallint | Type ID (1: Erasmus bilateral agreement) | |
| agrtype_acadyear | smallint | Academic year as definition year (yes:1/no(calendar year):0) | |
| agrtype_text | text | Text | |
| agrtype_mobility | smallint | Include mobility (yes:1/no:0) | |
| agrtype_order | smallint | Order | |
| agrtype_active | smallint | Active (yes:1/no:0) | |
| agrtype_idexternal | varchar | 10 | External ID |
applicationprocess table
Content: application process data
| Name | Type | Size | Description |
|---|---|---|---|
| applprocess_id | int | ID | |
| applprocess_lastupdate | timestamp | Date and time of last update | |
| applprocess_lastuser_id | int | Last updated by user ID | |
| applprocess_name | varchar | 50 | Name |
| applprocess_description | varchar | 255 | Description |
| applprocess_startdate | date | Start date | |
| applprocess_enddate | date | End date | |
| applprocess_persontype_id | varchar | 10 | Person type (studout:outgoing student / studin:incoming student / staffout:outgoing staff / staffin:incoming staff) |
applications table
Content: application data
| Name | Type | Size | Description |
|---|---|---|---|
| application_id | int | ID | |
| application_lastupdate | timestamp | Date and time of last update | |
| application_lastuser_id | int | Last updated by user ID | |
| application_date | date | Date | |
| application_applprocess_id | int | Attachment application process ID | |
| application_person_id | int | Attachment person ID | |
| application_free01 | varchar | 255 | Free field 1 |
| application_free02 | varchar | 255 | Free field 2 |
| application_free03 | varchar | 255 | Free field 3 |
| application_free04 | varchar | 255 | Free field 4 |
| application_free05 | varchar | 255 | Free field 5 |
| application_free06 | varchar | 255 | Free field 6 |
| application_free07 | varchar | 255 | Free field 7 |
| application_free08 | varchar | 255 | Free field 8 |
| application_free09 | varchar | 255 | Free field 9 |
| application_free10 | varchar | 255 | Free field 10 |
| application_free11 | varchar | 255 | Free field 11 |
| application_free12 | varchar | 255 | Free field 12 |
contacts table
Content: internal and external contact data
| Name | Type | Size | Description |
|---|---|---|---|
| contact_id | int | ID | |
| contact_lastupdate | timestamp | Date and time of last update | |
| contact_lastuser_id | int | Last updated by user ID | |
| contact_institution_id | int | Attachment institution ID | |
| contact_faculty_id | int | Attachment faculty ID | |
| contact_facfield_id | int | Attachment field of study ID | |
| contact_surname | varchar | 50 | Surname |
| contact_firstname | varchar | 50 | First name |
| contact_title | varchar | 20 | Title |
| contact_sex | char | 1 | Gender (male:M/female:F) |
| contact_department | varchar | 100 | Department |
| contact_function | varchar | 100 | Function |
| contact_responsability | varchar | 255 | Responsibility |
| contact_street | varchar | 150 | Address |
| contact_postcode | varchar | 15 | Post code |
| contact_city | varchar | 50 | City |
| contact_country_id | char | 2 | Country |
| contact_phone | varchar | 20 | Phone |
| contact_mobilephone | varchar | 20 | Mobile phone |
| contact_fax | varchar | 20 | Fax |
| contact_email | varchar | 150 | Email address |
| contact_titleletter | varchar | 50 | Salutation |
| contact_remarks | varchar | 255 | Remarks |
| contact_active | smallint | Active (yes:1/no:0) | |
| contact_free01 | varchar | 255 | Free field 1 |
| contact_free02 | varchar | 255 | Free field 2 |
| contact_free03 | varchar | 255 | Free field 3 |
| contact_free04 | varchar | 255 | Free field 4 |
| contact_free05 | varchar | 255 | Free field 5 |
| contact_free06 | varchar | 255 | Free field 6 |
| contact_free07 | varchar | 255 | Free field 7 |
| contact_free08 | varchar | 255 | Free field 8 |
| contact_free09 | varchar | 255 | Free field 9 |
| contact_free10 | varchar | 255 | Free field 10 |
| contact_free11 | varchar | 255 | Free field 11 |
| contact_free12 | varchar | 255 | Free field 12 |
coopactivities table
Content: cooperation activities data
| Name | Type | Size | Description |
|---|---|---|---|
| coopactivity_id | int | ID | |
| coopactivity_lastupdate | timestamp | Date and time of last update | |
| coopactivity_lastuser_id | int | Last updated by user ID | |
| coopactivity_cooperation_id | int | Attachment cooperation ID | |
| coopactivity_type_id | int | Cooperation activity type ID | |
| coopactivity_name | varchar | 255 | Name |
| coopactivity_description | text | Description | |
| coopactivity_www | varchar | 255 | Website address |
| coopactivity_startdate | date | Start date | |
| coopactivity_duration | varchar | 20 | Duration |
| coopactivity_enddate | date | End date | |
| coopactivity_faculty_id | int | Attachment faculty ID | |
| coopactivity_facfield_id | int | Attachment field of study ID | |
| coopactivity_referencenumber | varchar | 20 | Reference |
| coopactivity_leadership | smallint | Project leader | |
| coopactivity_homecontact_id | int | Internal contact ID | |
| coopactivity_homecontact_others | varchar | 255 | Other internal participants |
| coopactivity_extcontact_id | int | External contact ID | |
| coopactivity_otherparticipants | varchar | 255 | Other external participants |
| coopactivity_fundingothers | varchar | 255 | Other funding sources |
| coopactivity_fundingamount | varchar | 150 | Funding amount |
| coopactivity_remarks | text | Remarks |
coopactivity_funding table
Content: cooperation activity funding sources data
| Name | Type | Size | Description |
|---|---|---|---|
| id | int | ID | |
| coopactivity_id | int | Cooperation activity ID | |
| coopfunding_id | int | Funding source ID |
cooperation_content table
Content: cooperation content data
| Name | Type | Size | Description |
|---|---|---|---|
| id | int | ID | |
| cooperation_id | int | Cooperation ID | |
| coopcontent_id | int | Cooperation content ID |
cooperation_field table
Content: cooperation field of study and faculty data
| Name | Type | Size | Description |
|---|---|---|---|
| id | int | ID | |
| cooperation_id | int | Cooperation ID | |
| faculty_id | int | Faculty ID | |
| field_id | int | Field of study ID |
cooperation_funding table
Content: cooperation funding data
| Name | Type | Size | Description |
|---|---|---|---|
| id | int | ID | |
| cooperation_id | int | Cooperation ID | |
| coopfunding_id | int | Funding source ID |
cooperation_institution table
Content: cooperation institution data
| Name | Type | Size | Description |
|---|---|---|---|
| id | int | ID | |
| cooperation_id | int | Cooperation ID | |
| institution_id | int | Institution ID |
cooperations table
Content: cooperation data
| Name | Type | Size | Description |
|---|---|---|---|
| cooperation_id | int | ID | |
| cooperation_lastupdate | timestamp | Date and time of last update | |
| cooperation_lastuser_id | int | Last updated by user ID | |
| cooperation_type_id | smallint | Type ID | |
| cooperation_status_id | smallint | Status ID | |
| cooperation_coopprogramme_id | int | Cooperation programme ID | |
| cooperation_name | varchar | 150 | Name |
| cooperation_startyear_id | smallint | Start year | |
| cooperation_endyear_id | smallint | End year | |
| cooperation_fundingothers | varchar | 255 | Other funding sources |
| cooperation_contentothers | varchar | 150 | Other content |
| cooperation_fieldsothers | varchar | 150 | Other fields of study |
| cooperation_levels | varchar | 6 | Levels |
| cooperation_remarks | text | Remarks | |
| cooperation_homecontact_id | int | Internal contact ID | |
| cooperation_extcontact_id | int | External contact ID | |
| cooperation_free01 | varchar | 255 | Free field 1 |
| cooperation_free02 | varchar | 255 | Free field 2 |
| cooperation_free03 | varchar | 255 | Free field 3 |
| cooperation_free04 | varchar | 255 | Free field 4 |
| cooperation_free05 | varchar | 255 | Free field 5 |
| cooperation_free06 | varchar | 255 | Free field 6 |
| cooperation_free07 | varchar | 255 | Free field 7 |
| cooperation_free08 | varchar | 255 | Free field 8 |
| cooperation_free09 | varchar | 255 | Free field 9 |
| cooperation_free10 | varchar | 255 | Free field 10 |
| cooperation_free11 | varchar | 255 | Free field 11 |
| cooperation_free12 | varchar | 255 | Free field 12 |
coopprogrammes table
Content: cooperation programme data
| Name | Type | Size | Description |
|---|---|---|---|
| coopprogramme_id | int | ID | |
| coopprogramme_lastupdate | timestamp | Date and time of last update | |
| coopprogramme_lastuser_id | int | Last updated by user ID | |
| coopprogramme_name | varchar | 50 | Name |
| coopprogramme_name_en | varchar | 50 | English translation of name |
| coopprogramme_name_de | varchar | 50 | German translation of name |
| coopprogramme_name_fr | varchar | 50 | French translation of name |
| coopprogramme_name_es | varchar | 50 | Spanish translation of name |
| coopprogramme_name_it | varchar | 50 | Italian translation of name |
| coopprogramme_order | smallint | Order | |
| coopprogramme_active | smallint | Active (yes:1/no:0) |
degrees table
Content: course data
| Name | Type | Size | Description |
|---|---|---|---|
| degree_id | int | ID | |
| degree_lastupdate | timestamp | Date and time of last update | |
| degree_lastuser_id | int | Last updated by user ID | |
| degree_facfield_id | int | Attachment field of study ID | |
| degree_code | varchar | 10 | Code |
| degree_name | varchar | 100 | Name |
| degree_name_en | varchar | 100 | English translation of name |
| degree_name_de | varchar | 100 | German translation of name |
| degree_name_fr | varchar | 100 | French translation of name |
| degree_name_es | varchar | 100 | Spanish translation of name |
| degree_name_it | varchar | 100 | Italian translation of name |
| degree_subject_id | varchar | 4 | Subject area ID |
| degree_degreetype_id | int | Attachment course type ID | |
| degree_level_id | char | 1 | Study level ID |
| degree_active | smallint | Active (yes:1/no:0) | |
| degree_idexternal | varchar | 10 | External ID |
degreetypes table
Content: course type data
| Name | Type | Size | Description |
|---|---|---|---|
| degreetype_id | int | ID | |
| degreetype_lastupdate | timestamp | Date and time of last update | |
| degreetype_lastuser_id | int | Last updated by user ID | |
| degreetype_name | varchar | 50 | Name |
| degreetype_name_en | varchar | 50 | English translation of name |
| degreetype_name_de | varchar | 50 | German translation of name |
| degreetype_name_fr | varchar | 50 | French translation of name |
| degreetype_name_es | varchar | 50 | Spanish translation of name |
| degreetype_name_it | varchar | 50 | Italian translation of name |
| degreetype_order | smallint | Order | |
| degreetype_code | varchar | 10 | Code |
| degreetype_level_id | char | 1 | Study level ID |
| degreetype_active | smallint | Active (yes:1/no:0) | |
| degreetype_idexternal | varchar | 10 | External ID |
degreeyears table
Content: course years data
| Name | Type | Size | Description |
|---|---|---|---|
| degreeyear_id | int | ID | |
| degreeyear_lastupdate | timestamp | Date and time of last update | |
| degreeyear_lastuser_id | int | Last updated by user ID | |
| degreeyear_degree_id | int | Attachment course ID | |
| degreeyear_code | varchar | 10 | Code |
| degreeyear_name | varchar | 100 | Name |
| degreeyear_name_en | varchar | 100 | English translation of name |
| degreeyear_name_de | varchar | 100 | German translation of name |
| degreeyear_name_fr | varchar | 100 | French translation of name |
| degreeyear_name_es | varchar | 100 | Spanish translation of name |
| degreeyear_name_it | varchar | 100 | Italian translation of name |
| degreeyear_active | smallint | Active (yes:1/no:0) | |
| degreeyear_idexternal | varchar | 10 | External ID |
doctemplates table
Content: document template data
| Name | Type | Size | Description |
|---|---|---|---|
| doctemplate_id | int | ID | |
| doctemplate_lastupdate | timestamp | Date and time of last update | |
| doctemplate_lastuser_id | int | Last updated by user ID | |
| doctemplate_name | varchar | 50 | Name |
| doctemplate_path | varchar | 255 | Document path |
| doctemplate_recipients_id | varchar | 50 | Recipient type ID |
| doctemplate_faculty_id | int | Faculty ID for which the document template is valid (valid for any faculty if blank) | |
| doctemplate_user_id | int | User ID for which the document template is valid (valid for any user if blank) |
e_actions table
Content: e-procedure action data
| Name | Type | Size | Description |
|---|---|---|---|
| action_id | smallint | ID | |
| action_code | varchar | 6 | Code |
| action_institutioncode | varchar | 11 | Institution's moveonnet code |
| action_status_id | smallint | Status ID after action | |
| action_message | text | Message | |
| action_lastupdate | timestamp | Date and time of action | |
| action_type | varchar | 50 | Action type |
e_contacts table
Content: moveonnet contacts data
| Name | Type | Size | Description |
|---|---|---|---|
| contact_id | int | ID | |
| contact_lastupdate | timestamp | Date and time of last update | |
| contact_lastuser_id | int | Last updated by user ID | |
| contact_institutioncode | varchar | 11 | Attachment institution's moveonnet code |
| contact_surname | varchar | 50 | Surname |
| contact_firstname | varchar | 50 | First name |
| contact_title | varchar | 20 | Title |
| contact_sex | char | 1 | Gender (male:M/female:F) |
| contact_department | varchar | 100 | Department |
| contact_function | varchar | 100 | Function |
| contact_responsability | varchar | 255 | Responsibility |
| contact_street | varchar | 150 | Address |
| contact_postcode | varchar | 15 | Post code |
| contact_city | varchar | 50 | City |
| contact_country_id | char | 2 | Country |
| contact_phone | varchar | 20 | Phone |
| contact_mobilephone | varchar | 20 | Mobile phone |
| contact_fax | varchar | 20 | Fax |
| contact_email | varchar | 150 | Email address |
| contact_enominationin | smallint | Contact for incoming e-nominations (yes:1/no:0) | |
| contact_enominationinarea | varchar | 255 | Field of responsibility, incoming e-nominations |
| contact_enominationin | smallint | Contact for outgoing e-nominations (yes:1/no:0) | |
| contact_enominationoutarea | varchar | 255 | Field of responsibility, outgoing e-nominations |
| contact_public | smallint | Public (yes:1/no:0) | |
| contact_active | smallint | Active (yes:1/no:0) |
e_institutions table
Content: moveonnet institution data
| Name | Type | Size | Description |
|---|---|---|---|
| institution_id | int | ID | |
| institution_lastupdate | timestamp | Date and time of last update | |
| institution_lastuser_id | int | Last updated by user ID | |
| institution_type_id | smallint | Institution type ID | |
| institution_name | varchar | 100 | Name |
| institution_nametranslated | varchar | 100 | Translated name |
| institution_city | varchar | 50 | City |
| institution_country_id | char | 2 | Country ID |
| institution_erasmuscode | varchar | 12 | Erasmus code |
| institution_code | varchar | 11 | moveonnet code |
| institution_eucnumber | int | EUC number | |
| institution_www | varchar | 255 | Website address |
| institution_wwwenglish | varchar | 255 | Website address - English home page |
| institution_wwwinternational | varchar | 255 | Website address - international home page |
| institution_wwwcity | varchar | 255 | City's website address |
| institution_wwwcatalogue | varchar | 255 | Course catalogue address |
| institution_teachinglanguage | text | Teaching language | |
| institution_semesterstruct_id | smallint | Semester structure ID | |
| institution_semesterdates | text | Semester dates | |
| institution_applformalities | text | Application formalities | |
| institution_langrequirements | text | Language requirements | |
| institution_appldeadlines | text | Application deadlines | |
| institution_accommodation | text | Accommodation | |
| institution_langpreparation | text | Language preparation/language courses | |
| institution_fees | text | Tuition/registration fees | |
| institution_miscellaneous | text | Miscellaneous | |
| institution_sector_id | varchar | 5 | Economic activity ID |
| institution_size_id | varchar | 5 | Size ID |
e_nominations table
Content: e-nomination data
| Name | Type | Size | Description |
|---|---|---|---|
| nomination_id | int | ID | |
| nomination_lastupdate | timestamp | Date and time of last update | |
| nomination_lastuser_id | int | Last updated by user ID | |
| nomination_code | varchar | 6 | moveonnet code for e-nomination |
| nomination_status_id | smallint | Status ID | |
| nomination_surname | varchar | 50 | Surname |
| nomination_firstname | varchar | 50 | First name |
| nomination_sex | char | 1 | Gender (M:male; F: female) |
| nomination_birthdate | date | Date of birth | |
| nomination_nationality_id | char | 2 | Nationality |
| nomination_email | varchar | 150 | Email address |
| nomination_institutioncode | varchar | 13 | Attachment institution's moveonnet code |
| nomination_type | varchar | 10 | Type (incoming/outgoing) |
| nomination_subject_id | char | 4 | Subject area ID |
| nomination_level_id | char | 1 | Study level ID |
| nomination_startyear | smallint | Start year (calendar year) | |
| nomination_year_id | smallint | Start year ID (academic year) | |
| nomination_startsemester_id | smallint | Start semester ID | |
| nomination_durationsemesters | smallint | Duration in semesters | |
| nomination_startmonth | smallint | Start month | |
| nomination_durationmonths | smallint | Duration in months | |
| nomination_homecontact_id | int | ID of moveonnet contact at home institution | |
| nomination_hometempcontact_id | int | ID of temporary moveonnet contact at home institution | |
| nomination_extcontact_id | int | ID of moveonnet contact at host institution | |
| nomination_exttempcontact_id | int | ID of temporary moveonnet contact at host institution | |
| nomination_localstatus_id | smallint | Local status ID | |
| nomination_mobility_id | int | Attachment mobility ID | |
| nomination_programme_id | int | Attachment programme ID | |
| nomination_faculty_id | int | Attachment faculty ID | |
| nomination_facfield_id | int | Attachment field of study ID |
e_tempcontacts table
Content: temporary moveonnet contacts data
| Name | Type | Size | Description |
|---|---|---|---|
| contact_id | int | ID | |
| contact_lastupdate | timestamp | Date and time of last update | |
| contact_lastuser_id | int | Last updated by user ID | |
| contact_institutioncode | varchar | 13 | Attachment institution's moveonnet code |
| contact_surname | varchar | 50 | Surname |
| contact_firstname | varchar | 50 | First name |
| contact_title | varchar | 20 | Title |
| contact_email | varchar | 150 | Email address |
| contact_enominationin | smallint | Contact for incoming e-nominations (yes:1/no:0) | |
| contact_enominationinarea | varchar | 255 | Field of responsibility, incoming e-nominations |
| contact_enominationin | smallint | Contact for outgoing e-nominations (yes:1/no:0) | |
| contact_enominationoutarea | varchar | 255 | Field of responsibility, outgoing e-nominations |
| contact_definstitutioncode | varchar | 13 | moveonnet code of institution defining the contact |
entries table
Content: entry data
| Name | Type | Size | Description |
|---|---|---|---|
| entry_id | int | ID | |
| entry_lastupdate | timestamp | Date and time of last update | |
| entry_lastuser_id | int | Last updated by user ID | |
| entry_funding_id | int | Attachment funding ID | |
| entry_entrytype_id | int | Attachment expense type ID | |
| entry_grant_id | int | Attachment grant ID | |
| entry_description | varchar | 100 | Text |
| entry_date | date | Date | |
| entry_planned | double | Planned amount | |
| entry_amount | double | Amount | |
| entry_checked | smallint | Checked (yes:1/no:0) | |
| entry_revenue | smallint | Revenue (yes:1/no:0) | |
| entry_remarks | varchar | 255 | Remarks |
entrytypes table
Content: expense type data
| Name | Type | Size | Description |
|---|---|---|---|
| entrytype_id | int | ID | |
| entrytype_lastupdate | timestamp | Date and time of last update | |
| entrytype_lastuser_id | int | Last updated by user ID | |
| entrytype_funding_id | int | Attachment funding ID | |
| entrytype_name | varchar | 50 | Name |
| entrytype_planned | double | Planned amount | |
| entrytype_persontype_id | varchar | 10 | Person type (studout:outgoing student / studin:incoming student / staffout:outgoing staff / staffin:incoming staff) |
exchanges table
Content: exchange possibilities data
| Name | Type | Size | Description |
|---|---|---|---|
| exchange_id | int | ID | |
| exchange_lastupdate | timestamp | Date and time of last update | |
| exchange_lastuser_id | int | Last updated by user ID | |
| exchange_institution_id | int | Attachment institution ID | |
| exchange_cooperation_id | int | Attachment cooperation ID | |
| exchange_programme_id | int | Attachment exchange programme ID | |
| exchange_faculty_id | int | Attachment faculty ID | |
| exchange_facfield_id | int | Attachment field of study ID | |
| exchange_degree_id | int | Attachment degree ID | |
| exchange_subject_id | varchar | 4 | Subject area ID |
| exchange_levels | varchar | 5 | Study level ID |
| exchange_active | smallint | Active (yes:1/no:0) | |
| exchange_remarks | text | Remarks | |
| exchange_homeinstcontact_id | int | Internal institutional contact ID | |
| exchange_homedeptcontact_id | int | Internal departmental contact ID | |
| exchange_hometutor_id | int | Internal tutor ID | |
| exchange_extinstcontact_id | int | External institutional contact ID | |
| exchange_extdeptcontact_id | int | External departmental contact ID | |
| exchange_exttutor_id | int | External tutor ID | |
| exchange_startyear_id | smallint | Start year ID (academic year) | |
| exchange_renewalyear_id | smallint | Renewal year ID (academic year) | |
| exchange_renewaldate | Date | Renewal date | |
| exchange_endyear_id | smallint | End year ID (academic year) | |
| exchange_abroaddegree | varchar | 150 | Title of external degree obtained |
| exchange_free01 | varchar | 255 | Free field 1 |
| exchange_free02 | varchar | 255 | Free field 2 |
| exchange_free03 | varchar | 255 | Free field 3 |
| exchange_free04 | varchar | 255 | Free field 4 |
| exchange_free05 | varchar | 255 | Free field 5 |
| exchange_free06 | varchar | 255 | Free field 6 |
| exchange_free07 | varchar | 255 | Free field 7 |
| exchange_free08 | varchar | 255 | Free field 8 |
| exchange_free09 | varchar | 255 | Free field 9 |
| exchange_free10 | varchar | 255 | Free field 10 |
| exchange_free11 | varchar | 255 | Free field 11 |
| exchange_free12 | varchar | 255 | Free field 12 |
facfields table
Content: field of study data
| Name | Type | Size | Description |
|---|---|---|---|
| facfield_id | int | ID | |
| facfield_lastupdate | timestamp | Date and time of last update | |
| facfield_lastuser_id | int | Last updated by user ID | |
| facfield_faculty_id | int | Attachment faculty ID | |
| facfield_code | varchar | 10 | Code |
| facfield_name | varchar | 100 | Name |
| facfield_name_en | varchar | 100 | English translation of name |
| facfield_name_de | varchar | 100 | German translation of name |
| facfield_name_fr | varchar | 100 | French translation of name |
| facfield_name_es | varchar | 100 | Spanish translation of name |
| facfield_name_it | varchar | 100 | Italian translation of name |
| facfield_subject_id | varchar | 4 | Subject area ID |
| facfield_active | smallint | Active (yes:1/no:0) | |
| facfield_idexternal | varchar | 10 | External ID |
faculties table
Content: faculty data
| Name | Type | Size | Description |
|---|---|---|---|
| faculty_id | int | ID | |
| faculty_lastupdate | timestamp | Date and time of last update | |
| faculty_lastuser_id | int | Last updated by user ID | |
| faculty_code | varchar | 10 | Code |
| faculty_name | varchar | 100 | Name |
| faculty_name_en | varchar | 100 | English translation of name |
| faculty_name_de | varchar | 100 | German translation of name |
| faculty_name_fr | varchar | 100 | French translation of name |
| faculty_name_es | varchar | 100 | Spanish translation of name |
| faculty_name_it | varchar | 100 | Italian translation of name |
| faculty_subject_id | varchar | 4 | Subject area ID |
| faculty_active | smallint | Active (yes:1/no:0) | |
| faculty_idexternal | varchar | 10 | External ID |
flows table
Content: planned mobility flows for an exchange possibility
| Name | Type | Size | Description |
|---|---|---|---|
| flow_id | int | ID | |
| flow_lastupdate | timestamp | Date and time of last update | |
| flow_lastuser_id | int | Last updated by user ID | |
| flow_year_id | smallint | Attachment year ID (academic year) | |
| flow_exchange_id | int | Attachment exchange ID | |
| flow_numberout | smallint | Number of outgoing mobilities | |
| flow_durationout | smallint | Duration of each outgoing mobility | |
| flow_numberin | smallint | Number of incoming mobilities | |
| flow_durationin | smallint | Duration of each incoming mobility |
freefields table
Content: free fields data
| Name | Type | Size | Description |
|---|---|---|---|
| freefield_id | int | ID | |
| freefield_lastupdate | timestamp | Date and time of last update | |
| freefield_lastuser_id | int | Last updated by user ID | |
| freefield_table | varchar | 50 | Table |
| freefield_number | smallint | Number | |
| freefield_name | varchar | 50 | Description |
| freefield_type | smallint | Type (1: Text; 2: Checkbox; 3: List; 4: Date) | |
| freefield_field | varchar | 50 | Field name |
fundings table
Content: funding data
| Name | Type | Size | Description |
|---|---|---|---|
| funding_id | int | ID | |
| funding_lastupdate | timestamp | Date and time of last update | |
| funding_lastuser_id | int | Last updated by user ID | |
| funding_name | varchar | 100 | Name |
| funding_fundingtype_id | int | Attachment funding type ID | |
| funding_year_id | smallint | Attachment year ID | |
| funding_institution | varchar | 50 | Funding institution |
| funding_account1 | varchar | 50 | Account reference 1 |
| funding_account2 | varchar | 50 | Account reference 2 |
| funding_agreementnumber | varchar | 50 | Agreement reference |
| funding_period | varchar | 50 | Period of use |
| funding_remarks | text | Remarks | |
| funding_acadyear | smallint | Academic year as financial year (yes:1/no(calendar year):0) | |
| funding_faculty_id | int | Attachment faculty ID | |
| funding_locked | smallint | Locked - data cannot be edited (yes:1/no:0) | |
| funding_currency_id | char | 3 | Currency ID |
| funding_currencyrate | double | Exchange rate relative to the default currency | |
| funding_durationtype_id | char | 1 | Duration unit ID (m: month/w:week/d:day) |
| funding_studout | smallint | Used for outgoing students (yes:1/no:0) | |
| funding_studin | smallint | Used for incoming students (yes:1/no:0) | |
| funding_staffout | smallint | Used for outgoing staff (yes:1/no:0) | |
| funding_staffin | smallint | Used for incoming staff (yes:1/no:0) | |
| funding_expenses | smallint | Used for expenses (yes:1/no:0) |
fundingtypes table
Content: funding type data
| Name | Type | Size | Description |
|---|---|---|---|
| fundingtype_id | int | ID | |
| fundingtype_lastupdate | timestamp | Date and time of last update | |
| fundingtype_lastuser_id | int | Last updated by user ID | |
| fundingtype_name | varchar | 50 | Name |
| fundingtype_acadyear | smallint | Academic year as financial year (yes:1/no(calendar year):0) | |
| fundingtype_currency_id | varchar | 3 | Currency ID |
| fundingtype_order | smallint | Order | |
| fundingtype_studout | smallint | Used for outgoing students (yes:1/no:0) | |
| fundingtype_studin | smallint | Used for incoming students (yes:1/no:0) | |
| fundingtype_staffout | smallint | Used for outgoing staff (yes:1/no:0) | |
| fundingtype_staffin | smallint | Used for incoming staff (yes:1/no:0) | |
| fundingtype_expenses | smallint | Used for expenses (yes:1/no:0) | |
| fundingtype_active | smallint | Active (yes:1/no:0) |
grants table
Content: grant data
| Name | Type | Size | Description |
|---|---|---|---|
| grant_id | int | ID | |
| grant_lastupdate | timestamp | Date and time of last update | |
| grant_lastuser_id | int | Last updated by user ID | |
| grant_funding_id | int | Attachment funding ID | |
| grant_mobility_id | int | Attachment mobility ID | |
| grant_grantstatus_id | int | Attachment status ID | |
| grant_duration | Double | Duration | |
| grant_total | Double | Total amount | |
| grant_planned | Double | Planned amount |
grantstatus table
Content: grant status data
| Name | Type | Size | Description |
|---|---|---|---|
| grantstatus_id | int | ID | |
| grantstatus_lastupdate | timestamp | Date and time of last update | |
| grantstatus_lastuser_id | int | Last updated by user ID | |
| grantstatus_funding_id | smallint | Attachment funding ID | |
| grantstatus_code | varchar | 10 | Code |
| grantstatus_name | varchar | 50 | Name |
| grantstatus_persontype_id | varchar | 10 | Person type (studout:outgoing student / studin:incoming student / staffout:outgoing staff / staffin:incoming staff) |
| grantstatus_amountonetime | Double | Fixed amount to be paid | |
| grantstatus_amountmin | Double | Minimum amount to be paid per time unit | |
| grantstatus_amountmax | Double | Maximum amount to be paid per time unit | |
| grantstatus_durationmin | Double | Minimum duration to be paid | |
| grantstatus_durationmax | Double | Maximum duration to be paid | |
| grantstatus_percentpaid | Double | Percentage paid relative to total amount to be paid |
images table
Content: image data
| Name | Type | Size | Description |
|---|---|---|---|
| image_id | int | ID | |
| image_lastupdate | timestamp | Date and time of last update | |
| image_lastuser_id | int | Last updated by user ID | |
| image_name | varchar | 50 | Name |
| image_object | binary | Image file |
|
| image_faculty_id | int | Faculty ID for which the image is valid (valid for any faculty if blank) | |
| image_user_id | int | User ID for which the image is valid (valid for any user if blank) |
institutions table
Content: institution data
| Name | Type | Size | Description |
|---|---|---|---|
| institution_id | int | ID | |
| institution_lastupdate | timestamp | Date and time of last update | |
| institution_lastuser_id | int | Last updated by user ID | |
| institution_type_id | smallint | Institution type ID | |
| institution_name | varchar | 100 | Name |
| institution_nametranslated | varchar | 100 | Translated name |
| institution_city | varchar | 50 | City |
| institution_country_id | char | 2 | Country ID |
| institution_erasmuscode | varchar | 12 | Erasmus code |
| institution_moveonnetcode | varchar | 11 | moveonnet code |
| institution_eucnumber | int | EUC number | |
| institution_partner | smallint | Partner (yes:1/no:0) | |
| institution_www | varchar | 255 | Website address |
| institution_wwwenglish | varchar | 255 | Website address - English home page |
| institution_wwwInternational | varchar | 255 | Website address - international home page |
| institution_wwwcity | varchar | 255 | City's website address |
| institution_wwwcatalogue | varchar | 255 | Course catalogue address |
| institution_teachinglanguage | text | Teaching language | |
| institution_semesterstruct_id | smallint | Semester structure ID | |
| institution_semesterdates | text | Semester dates | |
| institution_applformalities | text | Application formalities | |
| institution_langrequirements | text | Language requirements | |
| institution_appldeadlines | text | Application deadlines | |
| institution_accommodation | text | Accommodation | |
| institution_langpreparation | text | Language preparation/language courses | |
| institution_fees | text | Tuition/registration fees | |
| institution_miscellaneous | text | Miscellaneous | |
| institution_sector_id | varchar | 5 | Economic activity ID |
| institution_size_id | varchar | 5 | Size ID |
| institution_idexternal | varchar | 10 | External ID |
| institution_free01 | varchar | 255 | Free field 1 |
| institution_free02 | varchar | 255 | Free field 2 |
| institution_free03 | varchar | 255 | Free field 3 |
| institution_free04 | varchar | 255 | Free field 4 |
| institution_free05 | varchar | 255 | Free field 5 |
| institution_free06 | varchar | 255 | Free field 6 |
| institution_free07 | varchar | 255 | Free field 7 |
| institution_free08 | varchar | 255 | Free field 8 |
| institution_free09 | varchar | 255 | Free field 9 |
| institution_free10 | varchar | 255 | Free field 10 |
| institution_free11 | varchar | 255 | Free field 11 |
| institution_free12 | varchar | 255 | Free field 12 |
mobilities table
Content: mobility data
| Name | Type | Size | Description |
|---|---|---|---|
| mobility_id | int | ID | |
| mobility_lastupdate | timestamp | Date and time of last update | |
| mobility_lastuser_id | int | Last updated by user ID | |
| mobility_person_id | int | Attachment person ID | |
| mobility_persontype_id | varchar | 10 | Person type (studout:outgoing student / studin:incoming student / staffout:outgoing staff / staffin:incoming staff) |
| mobility_exchange_id | int | Exchange ID | |
| mobility_mobilitytype_id | int | Mobility type ID | |
| mobility_status_id | smallint | Status ID | |
| mobility_institution_id | int | Institution ID | |
| mobility_country_id | char | 2 | Country ID |
| mobility_programme_id | int | Mobility programme ID | |
| mobility_faculty_id | int | Faculty ID |
|
| mobility_facfield_id | int | Field of study ID | |
| mobility_degree_id | int | Course ID | |
| mobility_degreeyear_id | int | Course year ID | |
| mobility_name | varchar | 255 | Name |
| mobility_remarks | text | Remarks | |
| mobility_applicationcode | varchar | 6 | moveonnet code for e-nomination |
| mobility_applicationnumber | varchar | 10 | Application folder number |
| mobility_extqualification_id | char | 1 | Qualification type ID |
| mobility_mandatory | smallint | Mandatory mobility (1:yes; 2:no) | |
| mobility_degreetype_id | int | Course type ID | |
| mobility_degreetypeother | varchar | 20 | Other course type |
| mobility_homedeptcontact_id | int | Internal departmental contact ID | |
| mobility_hometutor_id | int | Internal tutor ID | |
| mobility_extdeptcontact_id | int | External departmental contact ID | |
| mobility_exttutor_id | int | External tutor ID | |
| mobility_year_id | smallint | Academic year ID | |
| mobility_startsemester_id | smallint | Start semester ID | |
| mobility_endsemester_id | smallint | End semester ID | |
| mobility_durationsemesters | smallint | Duration in semesters | |
| mobility_durationmonths | double | Duration in months | |
| mobility_durationdays | smallint | Duration in days | |
| mobility_startdate | date | Start date | |
| mobility_enddate | date | End date | |
| mobility_plannedstartdate | date | Planned start date | |
| mobility_plannedenddate | date | Planned end date | |
| mobility_planneddurationmonths | double | Planned duration in months | |
| mobility_arrivaldate | date | Arrival date | |
| mobility_homelevel_id | char | 1 | Internal study level ID |
| mobility_extlevel_id | char | 1 | External study level ID |
| mobility_homesubject_id | char | 4 | Internal subject area ID |
| mobility_extsubject_id | char | 4 | External subject area ID |
| mobility_language_id | char | 2 | Language ID |
| mobility_numberyearsbefore | double | Number of study years before mobility | |
| mobility_seniority_id | char | 1 | Tutor status |
| mobility_teachinghours | int | Number of teaching hours | |
| mobility_creditsects | smallint | Use of ECTS | |
| mobility_creditsnumber1 | double | Number of ECTS credits - 1st sem. | |
| mobility_creditsnumber2 | double | Number of ECTS credits - 2nd sem. | |
| mobility_extgrad | smallint | Degree obtained at external institution (1:yes; 2:no) | |
| mobility_extgraddate | date | Date degree obtained at external institution | |
| mobility_extgraddegree | varchar | 150 | Title of degree at external institution |
| mobility_homegrad | smallint | Degree obtained at internal institution (1:yes; 2:no) | |
| mobility_homegraddate | date | Date degree obtained at internal institution | |
| mobility_homegraddegree | varchar | 150 | Title of degree at internal institution |
| mobility_addressbook | smallint | Included in address book (1:yes; 2:no) | |
| mobility_addressbookremarks | varchar | 255 | Remarks for address book |
| mobility_accomstartdate | date | Planned accommodation start date | |
| mobility_accomenddate | date | Planned accommodation end date | |
| mobility_accomformdate | date | Accommodation request date | |
| mobility_accomformremarks | varchar | 150 | Accommodation request remarks |
| mobility_accomremarks | varchar | 150 | Accommodation remarks |
| mobility_langcoursedate | date | Language course request date | |
| mobility_langcourseremarks | varchar | 255 | Language course remarks |
| mobility_grantremarks | varchar | 255 | Grant remarks |
| mobility_application_id | int | Attachment application ID | |
| mobility_applicationremarksext | varchar | 255 | External institution application remarks |
| mobility_applicationstatus1_id | smallint | Individual application status ID | |
| mobility_applicationorder | smallint | Application order | |
| mobility_applicationstatus2_id | smallint | Individual application status ID | |
| mobility_applicationrank | smallint | Waiting list ranking | |
| mobility_applicationstatus3_id | smallint | External application status ID | |
| mobility_nationalgrant | varchar | 50 | National grant |
| mobility_extacceptancedate | Date | Date of acceptance by external institution | |
| mobility_personacceptancedate | Date | Date of acceptance by student | |
| mobility_startconfirmdate | Date | Start confirmation date | |
| mobility_endconfirmdate | Date | End confirmation date | |
| mobility_ladate | Date | Learning agreement date | |
| mobility_progagreementdate | Date | Mobility programme date | |
| mobility_tor1date | Date | Transcript of records date - 1st sem. | |
| mobility_tor2date | Date | Transcript of records date - 2nd sem. | |
| mobility_reportdate | Date | Mobility report date | |
| mobility_dsdate | Date | Degree supplement date | |
| mobility_europassdate | Date | Europass certificate date | |
| mobility_expensereportdate | Date | Expenses claim date | |
| mobility_travelappldate | Date | Travel order date | |
| mobility_free01 | varchar | 255 | Free field 1 |
| mobility_free02 | varchar | 255 | Free field 2 |
| mobility_free03 | varchar | 255 | Free field 3 |
| mobility_free04 | varchar | 255 | Free field 4 |
| mobility_free05 | varchar | 255 | Free field 5 |
| mobility_free06 | varchar | 255 | Free field 6 |
| mobility_free07 | varchar | 255 | Free field 7 |
| mobility_free08 | varchar | 255 | Free field 8 |
| mobility_free09 | varchar | 255 | Free field 9 |
| mobility_free10 | varchar | 255 | Free field 10 |
| mobility_free11 | varchar | 255 | Free field 11 |
| mobility_free12 | varchar | 255 | Free field 12 |
mobilitysettings table
Content: mobility settings data
| Name | Type | Size | Description |
|---|---|---|---|
| mobilitysetting_id | int | ID | |
| mobilitysetting_lastupdate | timestamp | Date and time of last update | |
| mobilitysetting_lastuser_id | int | Last updated by user ID | |
| mobilitysetting_name | varchar | 50 | Name |
| mobilitysetting_value | varchar | 255 | Value |
| mobilitysetting_mobility_id | int | Attachment mobility ID |
mobilitytypes table
Content: mobility type data
| Name | Type | Size | Description |
|---|---|---|---|
| mobilitytype_id | int | ID | |
| mobilitytype_lastupdate | timestamp | Date and time of last update | |
| mobilitytype_lastuser_id | int | Last updated by user ID | |
| mobilitytype_name | varchar | 50 | Name |
| mobilitytype_name_en | varchar | 50 | English translation of name |
| mobilitytype_name_de | varchar | 50 | German translation of name |
| mobilitytype_name_fr | varchar | 50 | French translation of name |
| mobilitytype_name_es | varchar | 50 | Spanish translation of name |
| mobilitytype_name_it | varchar | 50 | Italian translation of name |
| mobilitytype_order | smallint | Order | |
| mobilitytype_studout | smallint | Used for outgoing students (yes:1/no:0) | |
| mobilitytype_studin | smallint | Used for incoming students (yes:1/no:0) | |
| mobilitytype_staffout | smallint | Used for outgoing staff (yes:1/no:0) | |
| mobilitytype_staffin | smallint | Used for incoming staff (yes:1/no:0) | |
| mobilitytype_active | smallint | Active (yes:1/no:0) |
modules table
Content: details of modules used for the transcript of records
| Name | Type | Size | Description |
|---|---|---|---|
| module_id | int | ID | |
| module_number | varchar | 15 | Reference |
| module_name | varchar | 70 | Name |
| module_teacher | varchar | 50 | Tutor name |
| module_ectscredits | double | Number of ECTS credits | |
| module_duration | varchar | 15 | Duration |
occupancies table
Content: accommodation occupancy data
| Name | Type | Size | Description |
|---|---|---|---|
| occupancy_id | int | ID | |
| occupancy_lastupdate | timestamp | Date and time of last update | |
| occupancy_lastuser_id | int | Last updated by user ID | |
| occupancy_accommodation_id | int | Attachment accommodation ID |
|
| occupancy_mobility_id | int | Attachment mobility ID | |
| occupancy_startdate | date | Occupancy start date | |
| occupancy_enddate | date | Occupancy end date |
persons table
Content: person data
| Name | Type | Size | Description |
|---|---|---|---|
| person_id | int | ID | |
| person_lastupdate | timestamp | Date and time of last update | |
| person_lastuser_id | int | Last updated by user ID | |
| person_persontype_id | varchar | 10 | Person type (studout:outgoing student / studin:incoming student / staffout:outgoing staff / staffin:incoming staff) |
| person_surname | varchar | 50 | Surname |
| person_firstname | varchar | 50 | First name |
| person_title | varchar | 20 | Title |
| person_sex | char | 1 | Gender (male:M/female:F) |
| person_birthdate | date | Date of birth | |
| person_birthcountry_id | char | 2 | Country of birth ID |
| person_birthplace | varchar | 50 | Place of birth |
| person_nationality_id | char | 2 | Country of nationality ID |
| person_nationality2_id | char | 2 | Country of second nationality ID |
| person_idnational | varchar | 20 | National ID |
| person_faculty_id | int | Attachment faculty ID | |
| person_idmatriculation | varchar | 15 | Student number |
| person_graduationyear_id | smallint | Degree year/graduation year ID | |
| person_currentco | varchar | 35 | Current address - c/o |
| person_currentstreet | varchar | 150 | Current address - street |
| person_currentpostcode | varchar | 15 | Current address - postcode |
| person_currentcity | varchar | 50 | Current address - city |
| person_currentcountry_id | char | 2 | Current address - country ID |
| person_currentphone | varchar | 20 | Current address - phone |
| person_currentvaliduntil | date | Current address - valid until | |
| person_mobilephone | varchar | 20 | Mobile phone |
| person_email | varchar | 150 | Email address |
| person_homeco | varchar | 35 | Home address - c/o |
| person_homestreet | varchar | 150 | Home address - street |
| person_homepostcode | varchar | 15 | Home address - postcode |
| person_homecity | varchar | 50 | Home address - city |
| person_homecountry_id | char | 2 | Home address - country ID |
| person_homephone | varchar | 20 | Home address - phone |
| person_bankcountry_id | char | 2 | Bank details - country ID |
| person_bankname | varchar | 50 | Bank details - name of bank |
| person_bankref | varchar | 30 | Bank details - bank reference |
| person_bankbic | varchar | 11 | Bank details - BIC number |
| person_bankaccount | varchar | 30 | Bank details - account reference |
| person_bankiban | varchar | 35 | Bank details - account IBAN |
| person_bankbeneficiary | varchar | 50 | Bank details - account holder |
| person_privacyconsent | smallint | Consent to transmit data (yes:1/no:0) | |
| person_schoolexamyear_id | smallint | School leaving exam year ID | |
| person_schoolexamcountry_id | char | 2 | School leaving exam country ID |
| person_schoolexamplace | varchar | 30 | School leaving exam location |
| person_remarks | text | Remarks | |
| person_idexternal | varchar | 10 | External ID |
| person_emergencyname | varchar | 100 | Name of person to contact in an emergency |
| person_emergencyphone | varchar | 20 | Phone number of person to contact in an emergency |
| person_emergencyemail | varchar | 150 | Email address of person to contact in an emergency |
| person_iddoctype_id | smallint | Identity document type (1: identity card; 2: passport) | |
| person_iddocnumber | varchar | 30 | Identity document number |
| person_iddocissuedate | date | Identity document issue date | |
| person_iddocexpiredate | date | Identity document expiry date | |
| person_iddocissuedby | varchar | 100 | Identity document issuing body |
| person_free01 | varchar | 255 | Free field 1 |
| person_free02 | varchar | 255 | Free field 2 |
| person_free03 | varchar | 255 | Free field 3 |
| person_free04 | varchar | 255 | Free field 4 |
| person_free05 | varchar | 255 | Free field 5 |
| person_free06 | varchar | 255 | Free field 6 |
| person_free07 | varchar | 255 | Free field 7 |
| person_free08 | varchar | 255 | Free field 8 |
| person_free09 | varchar | 255 | Free field 9 |
| person_free10 | varchar | 255 | Free field 10 |
| person_free11 | varchar | 255 | Free field 11 |
| person_free12 | varchar | 255 | Free field 12 |
programmes table
Content: exchange programme data
| Name | Type | Size | Description |
|---|---|---|---|
| programme_id | int | ID | |
| programme_lastupdate | timestamp | Date and time of last update | |
| programme_lastuser_id | int | Last updated by user ID | |
| programme_name | varchar | 50 | Name |
| programme_name_en | varchar | 50 | English translation of name |
| programme_name_de | varchar | 50 | German translation of name |
| programme_name_fr | varchar | 50 | French translation of name |
| programme_name_es | varchar | 50 | Spanish translation of name |
| programme_name_it | varchar | 50 | Italian translation of name |
| programme_order | smallint | Order | |
| programme_studout | smallint | Used for outgoing students (yes:1/no:0) | |
| programme_studin | smallint | Used for incoming students (yes:1/no:0) | |
| programme_staffout | smallint | Used for outgoing staff (yes:1/no:0) | |
| programme_staffin | smallint | Used for incoming staff (yes:1/no:0) | |
| programme_active | smallint | Active (yes:1/no:0) | |
| programme_idexternal | varchar | 10 | External ID |
remarks table
Content: remarks data
| Name | Type | Size | Description |
|---|---|---|---|
| remark_id | int | ID | |
| remark_lastupdate | timestamp | Date and time of last update | |
| remark_lastuser_id | int | Last updated by user ID | |
| remark_parenttable | varchar | 15 | Name of attachment table |
| remark_parentrecord_id | int | Attachment record ID | |
| remark_date | Date | Date | |
| remark_text | text | Text |
reportfields table
Content: details of fields included in a report template
| Name | Type | Size | Description |
|---|---|---|---|
| reportfield_id | int | ID | |
| reportfield_report_id | int | Attachment report template ID | |
| reportfield_table | varchar | 50 | Name of data table |
| reportfield_field | varchar | 50 | Name of table field |
| reportfield_order | varchar | 3 | Order of appearance (column) |
| reportfield_sort | smallint | Sort order | |
| reportfield_length | Double | Column width |
reports table
Content: report template data
| Name | Type | Size | Description |
|---|---|---|---|
| report_id | int | ID | |
| report_lastupdate | timestamp | Date and time of last update | |
| report_lastuser_id | int | Last updated by user ID | |
| report_table | varchar | 30 | Data type (e.g. mobilities) |
| report_name | varchar | 50 | Name |
| report_orientation | smallint | Orientation (landscape:1/portrait:2) | |
| report_numbering | smallint | Numbering (yes:0/no:0) | |
| report_title1 | varchar | 50 | 1st line title |
| report_title2 | varchar | 50 | 2nd line title |
settings table
Content: general settings data
| Name | Type | Size | Description |
|---|---|---|---|
| setting_id | int | ID | |
| setting_lastupdate | timestamp | Date and time of last update | |
| setting_lastuser_id | int | Last updated by user ID | |
| setting_name | varchar | 50 | Name |
| setting_value | varchar | 255 | Value |
| setting_faculty_id | int | Faculty ID for which the setting is valid (valid for any faculty if blank) | |
| setting_user_id | int | User ID for which the setting is valid (valid for any user if blank) |
transcripts table
Content: details of course units taken during a mobility
| Name | Type | Size | Description |
|---|---|---|---|
| transcript_id | int | ID | |
| transcript_lastupdate | timestamp | Date and time of last update | |
| transcript_lastuser_id | int | Last updated by user ID | |
| transcript_mobility_id | int | Attachment mobility ID | |
| transcript_modulenumber | varchar | 15 | Reference |
| transcript_moduleduration | varchar | 15 | Duration |
| transcript_modulename | varchar | 70 | Name |
| transcript_moduleteacher | varchar | 50 | Tutor name |
| transcript_localgrade | varchar | 15 | Local grade |
| transcript_ectsgrade | varchar | 5 | ECTS grade |
| transcript_ectscredits | double | Number of ECTS credits | |
| transcript_order | smallint | Order |
usergroup_right table
Content: user rights data
| Name | Type | Size | Description |
|---|---|---|---|
| id | int | ID | |
| usergroup_id | int | User group ID | |
| right_id | smallint | Right ID | |
| right_view | smallint | View right (yes:1/no:0) | |
| right_update | smallint | Update right (yes:1/no:0) | |
| right_add | smallint | Add right (yes:1/no:0) |
usergroups table
Content: user group data
| Name | Type | Size | Description |
|---|---|---|---|
| usergroup_id | int | ID | |
| usergroup_lastupdate | timestamp | Date and time of last update | |
| usergroup_lastuser_id | int | Last updated by user ID | |
| usergroup_name | varchar | 50 | Name |
| usergroup_order | smallint | Order | |
| usergroup_active | smallint | Active (yes:1/no:0) |
users table
Content: user data
| Name | Type | Size | Description |
|---|---|---|---|
| user_id | int | ID | |
| user_lastupdate | timestamp | Date and time of last update | |
| user_lastuser_id | int | Last updated by user ID | |
| user_usergroup_id | int | Attachment user group ID | |
| user_faculty_id | int | Attachment faculty ID | |
| user_surname | varchar | 25 | Surname |
| user_firstname | varchar | 25 | First name |
| user_username | varchar | 20 | User name |
| user_password | varchar | 32 | Password (MD5-encrypted) |
| user_phone | varchar | 25 | Phone |
| user_email | varchar | 150 | Email address |
| user_active | smallint | Active (yes:1/no:0) |
visits table
Content: visit data
| Name | Type | Size | Description |
|---|---|---|---|
| visit_id | int | ID | |
| visit_lastupdate | timestamp | Date and time of last update | |
| visit_lastuser_id | int | Last updated by user ID | |
| visit_institution_id | int | Attachment institution ID | |
| visit_faculty_id | int | Attachment faculty ID | |
| visit_startdate | Date | Start date | |
| visit_enddate | Date | End date | |
| visit_participants | varchar | 255 | Participants |
| visit_reason | varchar | 255 | Reason |
| visit_remarks | varchar | 255 | Remarks |
| visit_location | varchar | 50 | Location |
| visit_description | varchar | 100 | Description |
Modified: 2010-05-28 10:40:37