Skip to content

public.weekly_timesheets

Columns

Name Type Default Nullable Children Parents Comment
bc_hour_sheet_id uuid true
end_date date false
id bigint false public.daily_timesheets
is_auto_approved boolean false
is_corrected boolean false
is_mutated boolean false
is_paid boolean false
is_read boolean false
is_sent_to_bc boolean false
placement_id bigint false public.placements
start_date date false
status varchar(20) false
week integer false
year integer false

Constraints

Name Type Definition
unique_timesheet_per_placement_week_year UNIQUE UNIQUE (placement_id, week, year)
weekly_timesheets_pkey PRIMARY KEY PRIMARY KEY (id)
weekly_timesheets_placement_id_5fe2b51f_fk_placements_id FOREIGN KEY FOREIGN KEY (placement_id) REFERENCES placements(id) DEFERRABLE INITIALLY DEFERRED
weekly_timesheets_week_check CHECK CHECK ((week >= 0))
weekly_timesheets_year_check CHECK CHECK ((year >= 0))

Indexes

Name Definition
unique_timesheet_per_placement_week_year CREATE UNIQUE INDEX unique_timesheet_per_placement_week_year ON public.weekly_timesheets USING btree (placement_id, week, year)
weekly_time_end_dat_385ba8_idx CREATE INDEX weekly_time_end_dat_385ba8_idx ON public.weekly_timesheets USING btree (end_date)
weekly_time_start_d_364819_idx CREATE INDEX weekly_time_start_d_364819_idx ON public.weekly_timesheets USING btree (start_date)
weekly_time_status_e94855_idx CREATE INDEX weekly_time_status_e94855_idx ON public.weekly_timesheets USING btree (status)
weekly_time_week_880a6b_idx CREATE INDEX weekly_time_week_880a6b_idx ON public.weekly_timesheets USING btree (week)
weekly_timesheets_pkey CREATE UNIQUE INDEX weekly_timesheets_pkey ON public.weekly_timesheets USING btree (id)
weekly_timesheets_placement_id_5fe2b51f CREATE INDEX weekly_timesheets_placement_id_5fe2b51f ON public.weekly_timesheets USING btree (placement_id)

Generated by tbls