| gris_history_id |
bigint(20) unsigned |
NO |
|
auto_increment |
PK |
| gris_history_series_id |
bigint(20) unsigned |
NO |
|
|
FK zu gris_history_series |
| gris_history_date |
date |
NO |
|
|
Datum |
| gris_history_state |
varchar(15) |
YES |
|
|
Status |
| gris_history_description |
text |
YES |
|
|
Beschreibung |
| gris_history_area |
varchar(100) |
YES |
|
|
Bereich |
| gris_history_person_1 |
bigint(20) unsigned |
YES |
|
|
Person 1 |
| gris_history_person_2 |
bigint(20) unsigned |
YES |
|
|
Person 2 |
| gris_history_certificate |
varchar(45) |
YES |
|
|
Note |
| gris_history_role |
varchar(60) |
YES |
|
|
Rolle |
| gris_history_value |
decimal(10,2) |
YES |
|
|
Betrag |
| gris_history_foreign_id |
bigint(20) |
YES |
|
|
FK zu gris_unit |
| gris_institute_id |
bigint(20) unsigned |
YES |
|
|
FK zu gris_insitute |
| gris_history_registered |
tinyint(1) |
YES |
|
|
Registrierung an einer Hochschule |
| gris_history_authorization |
tinyint(1) |
YES |
|
|
Zulassungbescheid vorhanden |
| gris_history_supervision_agreement |
tinyint(1) |
YES |
|
|
Betreuungsvereinbarung vorhanden |
| gris_history_worktype |
varchar(20) |
YES |
|
|
Art der Arbeit |
| gris_promotion_program_id |
bigint(20) unsigned |
YES |
|
|
FK zu gris_promotion_programme |
| gris_history_external |
tinyint(1) |
YES |
|
|
Externe Arbeit |
| gris_history_thesistype |
varchar(20) |
YES |
|
|
Art der Arbeit |