Skip to content

public.position_age_wages

Columns

Name Type Default Nullable Children Parents Comment
age smallint false
fetched_at timestamp with time zone false
hourly_rate numeric(10,2) false
id bigint false
position_id bigint false public.job_positions
start_date date false

Constraints

Name Type Definition
position_age_wages_age_check CHECK CHECK ((age >= 0))
position_age_wages_pkey PRIMARY KEY PRIMARY KEY (id)
position_age_wages_position_id_6960171c_fk_job_positions_id FOREIGN KEY FOREIGN KEY (position_id) REFERENCES job_positions(id) DEFERRABLE INITIALLY DEFERRED
uniq_position_age_startdate UNIQUE UNIQUE (position_id, age, start_date)

Indexes

Name Definition
position_ag_positio_45ecbc_idx CREATE INDEX position_ag_positio_45ecbc_idx ON public.position_age_wages USING btree (position_id, age)
position_ag_positio_9d336b_idx CREATE INDEX position_ag_positio_9d336b_idx ON public.position_age_wages USING btree (position_id, start_date)
position_age_wages_pkey CREATE UNIQUE INDEX position_age_wages_pkey ON public.position_age_wages USING btree (id)
position_age_wages_position_id_6960171c CREATE INDEX position_age_wages_position_id_6960171c ON public.position_age_wages USING btree (position_id)
uniq_position_age_startdate CREATE UNIQUE INDEX uniq_position_age_startdate ON public.position_age_wages USING btree (position_id, age, start_date)

Generated by tbls