core_historicalcase

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
scaling_step int2 5 √ null
assessment_comment text 2147483647 null
history_id serial 10 √ nextval('core_historicalcase_history_id_seq'::regclass)
history_date timestamptz 35,6 null
history_change_reason varchar 100 √ null
history_type varchar 1 null
case_worker_id int8 19 √ null
history_user_id int8 19 √ null
effort_step_id int8 19 √ null
created timestamptz 35,6 √ null
modified timestamptz 35,6 √ null
user_created varchar 128 null
user_modified varchar 128 null
acting_municipality_id int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
core_historicalcase_pkey Primary key Asc history_id
core_historicalcase_acting_municipality_id_28d597d4 Performance Asc acting_municipality_id
core_historicalcase_case_worker_id_12b18640 Performance Asc case_worker_id
core_historicalcase_effort_step_new_id_aea6bd36 Performance Asc effort_step_id
core_historicalcase_history_user_id_601d37c5 Performance Asc history_user_id
core_historicalcase_id_ca89227a Performance Asc id

Check Constraints

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

Diagram producer might be missing

No diagrams were produced please see application output for any errors