core_case

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('core_case_id_seq'::regclass)
core_appropriation.case_id core_appropriation_case_id_69f8b199_fkR
core_relatedperson.main_case_id core_relatedperson_main_case_id_f0d129a9_fkR
sbsys_id varchar 128 null
cpr_number varchar 10 null
name varchar 128 null
scaling_step int2 5 √ null
assessment_comment text 2147483647 null
note text 2147483647 null
acting_municipality_id int8 19 null
core_municipality.id core_case_acting_municipality_id_90f8e17b_fkR
case_worker_id int8 19 null
core_user.id core_case_case_worker_id_9326dffa_fkR
district_id int8 19 √ null
core_schooldistrict.id core_case_district_id_2d51464f_fkR
paying_municipality_id int8 19 null
core_municipality.id core_case_paying_municipality_id_54fadff6_fkR
residence_municipality_id int8 19 null
core_municipality.id core_case_residence_municipality_id_97f4496a_fkR
effort_step_id int8 19 √ null
core_effortstep.id core_case_effort_step_id_64ae08a0_fkR
target_group_id int8 19 √ null
core_targetgroup.id core_case_target_group_id_1ffe0068_fkR
created timestamptz 35,6 √ null
modified timestamptz 35,6 √ null
user_created varchar 128 null
user_modified varchar 128 null

Indexes

Constraint Name Type Sort Column(s)
core_case_pkey Primary key Asc id
core_case_acting_municipality_id_90f8e17b Performance Asc acting_municipality_id
core_case_case_worker_id_9326dffa Performance Asc case_worker_id
core_case_district_id_2d51464f Performance Asc district_id
core_case_effort_step_new_id_cd307771 Performance Asc effort_step_id
core_case_paying_municipality_id_54fadff6 Performance Asc paying_municipality_id
core_case_residence_municipality_id_97f4496a Performance Asc residence_municipality_id
core_case_sbsys_id_6b87f713_like Performance Asc sbsys_id
core_case_sbsys_id_key Must be unique Asc sbsys_id
core_case_target_group_model_id_0487ca96 Performance Asc target_group_id

Check Constraints

Constraint Name Constraint
core_case_scaling_step_check ((scaling_step >= 0))

Relationships

Close relationships within degrees of separation