Table arcasys.employees Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int 10  √ 
rosters.employee_id FK_rosters_employees C
timeaccounts.employee_id FK_timeaccounts_employees C
Name varchar 40  √  null
Vorname varchar 40  √  null
GebDatum date 10  √  null
Nickname varchar 15  √  null
PLZ varchar 10  √  null
Ort varchar 50  √  null
Anschrift varchar 50  √  null
PLZ2 varchar 10  √  null
Ort2 varchar 50  √  null
Anschrift2 varchar 50  √  null
Bank varchar 30  √  null
KontoNr varchar 15  √  null
BLZ varchar 8  √  null
SozNr varchar 15  √  null
KKasse varchar 25  √  null
KKNr varchar 20  √  null
Steuerklasse int 10  √  null
Gemeinde varchar 10  √  null
Finanzamt varchar 20  √  null
Steuernummer varchar 20  √  null
Grundlohn float 12  √  null
Lohnart varchar 1  √  null
WStd float 12  √  null
MStd float 12  √  null
Zeitkonto float 12  √  null
TStd float 12  √  null
Tarif varchar 5  √  null
VWL float 12  √  null
AV float 12  √  null
Schule varchar 20  √  null
Ausbildung varchar 20  √  null
Abschluss varchar 20  √  null
SonderVb varchar 255  √  null
Einstellung date 10  √  null
Probezeit bit 0  √  null
Beendigung date 10  √  null
Grund varchar 50  √  null
Urlaub int 10  √  null
Resturlaub int 10  √  null
position_id int 10  √  null
positions.id FK_employees_positions R
location_id varchar 3  √  null
user_id varchar 255  √  null

Table contained 0 rows at Do Apr 25 17:50 MESZ 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
location_id Performance Asc Index_location_id
position_id Performance Asc Index_position_id
Nickname Performance Asc Nickname

Close relationships: