Hrube
Hrubé mzdy
| Název | Typ | Poznámka | Master |
|---|---|---|---|
| uuid | char 36 | ||
| zapsano | timestamp | ||
| opraveno | timestamp | ||
| mesic | smallint | 1..12 | |
| cislo_pracovnika | integer | ||
| prijmeni | varchar 100 | ||
| jmeno | varchar 50 | ||
| modul | smallint | ||
| sloupec | smallint | ||
| sloupec_slovy | varchar 100 | ||
| dny_od | decimal 4,2 | ||
| dny_neod | decimal 4,2 | ||
| hod_od | decimal 5,2 | ||
| hod_neod | decimal 5,2 | ||
| hod_vedl | decimal 5,2 | ||
| datum | date | ||
| stredisko | smallint | ||
| vykon | smallint | ||
| stroj | integer | ||
| kc1 | decimal 13,2 | ||
| kc2 | decimal 13,2 | ||
| kc3 | decimal 13,2 | ||
| kc4 | decimal 13,2 | ||
| kc_cel | decimal 13,2 | ||
| poznamka | varchar 1000 | ||
| volit_1..volit_10 | integer |