tbl_positions

46 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
position varchar 100 null
tbl_charge_rates.position tbl_charge_rates_position_fkeyC
tbl_slip_exp.staff_position Implied ConstraintR
tbl_staff_positions.position tbl_staff_positions_position_fkeyR
tbl_view_time_sheets_by_day.staff_position Implied ConstraintR
tbl_view_time_sheets_by_week.staff_position Implied ConstraintR
view_staff_by_day.staff_position Implied ConstraintR
view_staff_by_week.staff_position Implied ConstraintR
view_staff_positions.position Implied ConstraintR
view_time_sheets_by_day.staff_position Implied ConstraintR
view_time_sheets_by_day_part_one.staff_position Implied ConstraintR
view_time_sheets_by_day_part_two.staff_position Implied ConstraintR
view_time_sheets_by_week.staff_position Implied ConstraintR
view_time_sheets_by_week_part_one.staff_position Implied ConstraintR
view_time_sheets_by_week_part_two.staff_position Implied ConstraintR
active bool 1 true

Indexes

Constraint Name Type Sort Column(s)
tbl_positions_pkey Primary key Asc position

Relationships

Close relationships within degrees of separation