shift

549 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
shift_id uuid 2147483647 uuid_generate_v1()
shiftTask.shift_id shifttask_shift_id_foreign R
user_id varchar 255 √ null
userFarm.user_id shift_farm_id_user_id_foreign R
mood text 2147483647 √ null
wage_at_moment float4 8,8 √ '0'::real
farm_id uuid 2147483647 √ null
userFarm.farm_id shift_farm_id_user_id_foreign R
deleted bool 1 √ false
created_by_user_id varchar 255 √ '1'::character varying
users.user_id shift_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ '1'::character varying
users.user_id shift_updated_by_user_id_foreign R
created_at timestamptz 35,6 '1999-12-31 16:00:00-08'::timestamp with time zone
updated_at timestamptz 35,6 '1999-12-31 16:00:00-08'::timestamp with time zone
shift_date date 13 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
shift_pkey Primary key Asc shift_id

Relationships

Close relationships within degrees of separation