| gris_notes_id |
bigint(20) unsigned |
NO |
|
auto_increment |
PK |
| gris_notes_title |
varchar(255) |
YES |
|
|
Titel |
| gris_notes_content |
text |
YES |
|
|
Inhalt |
| gris_notes_object_table |
varchar(255) |
NO |
|
|
Objekt-Tabelle |
| gris_notes_object_id |
bigint(20) unsigned |
NO |
|
|
FK zu Objekt (gris_resource, gris_project) |
| gris_notes_date |
datetime |
NO |
current_timestamp() |
|
Datum |
| gris_notes_group |
bigint(20) unsigned |
YES |
|
|
FK zu gris_groups |
| gris_notes_author |
bigint(20) unsigned |
NO |
|
|
FK zu gris_person |
| gris_notes_for_owners |
tinyint(1) |
NO |
0 |
|
Notiz für Beteiligte sichtbar |
| gris_notes_notify_owners |
tinyint(1) |
NO |
0 |
|
Beteiligte benachrichtigen |
| gris_notes_reply |
bigint(20) unsigned |
YES |
|
|
FK zu gris_person |