数据库设计

1:n

id

案件管理表(t_case_management)

业务协同(t_business_collaboration)

n:1

案款发放(t_payment)

case_nameruling_book_idintroductionarea_idstatepayed_moneycreate_timecreate_byupdate_timeupdate_by

apply_department_idcase_idtask_idapply_reasonapply_timeresultcollaboration_infocreate_timecreate_byupdate_timeupdate_by

1:1

涉案材料(t_case_ material)

涉案人员资料(t_involved_person)

zjhcase_idpayment_moneypayment_timepayment_waycreate_timecreate_byupdate_timeupdate_by

task_namecase_idcase_typecase_material_idcurrent_linkcreate_timecreate_byupdate_timeupdate_by

zjhcase_iduncheckd_informationpolice_investigation_resultprocuratorate_investigation_resultcourt_decision_resultcreate_timecreate_byupdate_timeupdate_by

核查任务(t_cheek_task)

zjhnameresidence_addresspostal_addressteltask_namecase_idcase_typecase_material_idcurrent_linkcreate_timecreate_byupdate_timeupdate_by