christine griffin's legal issue tracking relational database

6
zk_F_legal_issue_ID_t zk_P_event_ID_t address_location_of_incident civil_code_violation_california civilpenalties complaint_to_government_authority conduct conductexact date_of_written_notice_givenby_party dateCreation datemodification dateofevent document_in_pdf_format document_notice_or_other event_location event_total_c eventDescription eventHours eventLabel_c eventLabelwithGrayOption_c eventMenuDisplay_c eventNumber eventNumberDisplay_c eventNumberMax_s eventTitle form_violation gCheckboxGrayOutOtherEvents_bool… gpaCurrentt_legal_case_c isDeletable_boolean nature_of_event notice_given_person notice_givenby_party numContacts_Witnesses_Associated… penalcodeviolation personsinvolved policereportnumber property_information reportedtopolice responsebypartygivennotice summary_of_notice time_begin_event time_end_event totaltimeofevent vvictim_account z___DEVELOPER___ zc_person_Label_t zc_recordsLabel_t zc_SORT_legal_issue_t zg_legal_issue_Selector_t zk_A_constant_n zk_A_currentLegal_Issue_t zk_F_DOCUMENT_ID_t zk_F_legal_issue_ID_t zk_F_person_ID_t zk_P_event_ID_t event.eventID_gCurrentLegal_Issue zk_A_constant_n addressCity addressLine1 addressLine2 addressState addressZip contact_witness_Number count_event_currentLegal_issue_c count_involvement_overall_c isDeletable_boolean_c litigamt nameFirst nameFull_c nameFullLastFirst_c nameLast notes notesGeneral notesLegal_Case notesPersonal numberOfHoursCurrent_witness_c numberOfHoursTotalEvent_c organization phoneEmergency phoneHome Professional_License_Badge_Corpor… title z___DEVELOPER___ zc_recordsLabel_t zk_A_constant_n zk_P_contact_witness_ID_t zkc_currentLegal_Case_ID_t contacts_witnesses.constant zk_F_event_ID_t zk_F_personID_t zkc_currentLegal_CaserID_t enrolledHours_c event_Display_c gCheckboxGrayOutOtherSemesters_boolean grade indexForCalculation_c indexforcalculation_CurrentLegal_Case_c isNotWaitListed_boolean_c isWaitListed_boolean legal_case_Display_c z___DEVELOPER___ zc_SORT_contact_witnessName_t zc_SORT_legal_case_t zk_A_constant_n zk_F_event_ID_t zk_F_personID_t zk_P_timesheetLineID_t zkc_currentLegal_CaserID_t contactEvent zk_A_constant_n zk_P_contact_witness_ID_t addressCity addressLine1 addressLine2 addressState addressZip contact_witness_Number count_event_currentLegal_issue_c count_involvement_overall_c isDeletable_boolean_c litigamt nameFirst nameFull_c nameFullLastFirst_c nameLast notes notesGeneral notesLegal_Case notesPersonal numberOfHoursCurrent_witness_c numberOfHoursTotalEvent_c organization phoneEmergency phoneHome Professional_License_Badge_Corporate_ID title z___DEVELOPER___ zc_recordsLabel_t zk_A_constant_n zk_P_contact_witness_ID_t zkc_currentLegal_Case_ID_t contacts_witnesses

Upload: christine-griffin

Post on 28-Mar-2016

212 views

Category:

Documents


0 download

DESCRIPTION

The graph of a relational database for legal issues tracking.

TRANSCRIPT

Page 1: Christine Griffin's Legal Issue Tracking Relational Database

zk_F_legal_issue_ID_tzk_P_event_ID_t

address_location_of_incidentcivil_code_violation_californiacivilpenaltiescomplaint_to_government_authorityconductconductexactdate_of_written_notice_givenby_partydateCreationdatemodificationdateofeventdocument_in_pdf_formatdocument_notice_or_otherevent_locationevent_total_ceventDescriptioneventHourseventLabel_ceventLabelwithGrayOption_ceventMenuDisplay_ceventNumbereventNumberDisplay_ceventNumberMax_seventTitleform_violationgCheckboxGrayOutOtherEvents_bool…gpaCurrentt_legal_case_cisDeletable_booleannature_of_eventnotice_given_personnotice_givenby_partynumContacts_Witnesses_Associated…penalcodeviolationpersonsinvolvedpolicereportnumberproperty_informationreportedtopoliceresponsebypartygivennoticesummary_of_noticetime_begin_eventtime_end_eventtotaltimeofeventvvictim_accountz___DEVELOPER___zc_person_Label_tzc_recordsLabel_tzc_SORT_legal_issue_tzg_legal_issue_Selector_tzk_A_constant_nzk_A_currentLegal_Issue_tzk_F_DOCUMENT_ID_tzk_F_legal_issue_ID_tzk_F_person_ID_tzk_P_event_ID_t

event.eventID_gCurrentLegal_Issue

zk_A_constant_n

addressCityaddressLine1addressLine2addressStateaddressZipcontact_witness_Numbercount_event_currentLegal_issue_ccount_involvement_overall_cisDeletable_boolean_clitigamtnameFirstnameFull_cnameFullLastFirst_cnameLastnotesnotesGeneralnotesLegal_CasenotesPersonalnumberOfHoursCurrent_witness_cnumberOfHoursTotalEvent_corganizationphoneEmergencyphoneHomeProfessional_License_Badge_Corpor…titlez___DEVELOPER___zc_recordsLabel_tzk_A_constant_nzk_P_contact_witness_ID_tzkc_currentLegal_Case_ID_t

contacts_witnesses.constantzk_F_event_ID_tzk_F_personID_tzkc_currentLegal_CaserID_t

enrolledHours_cevent_Display_cgCheckboxGrayOutOtherSemesters_booleangradeindexForCalculation_cindexforcalculation_CurrentLegal_Case_cisNotWaitListed_boolean_cisWaitListed_booleanlegal_case_Display_cz___DEVELOPER___zc_SORT_contact_witnessName_tzc_SORT_legal_case_tzk_A_constant_nzk_F_event_ID_tzk_F_personID_tzk_P_timesheetLineID_tzkc_currentLegal_CaserID_t

contactEventzk_A_constant_nzk_P_contact_witness_ID_t

addressCityaddressLine1addressLine2addressStateaddressZipcontact_witness_Numbercount_event_currentLegal_issue_ccount_involvement_overall_cisDeletable_boolean_clitigamtnameFirstnameFull_cnameFullLastFirst_cnameLastnotesnotesGeneralnotesLegal_CasenotesPersonalnumberOfHoursCurrent_witness_cnumberOfHoursTotalEvent_corganizationphoneEmergencyphoneHomeProfessional_License_Badge_Corporate_IDtitlez___DEVELOPER___zc_recordsLabel_tzk_A_constant_nzk_P_contact_witness_ID_tzkc_currentLegal_Case_ID_t

contacts_witnesses

Page 2: Christine Griffin's Legal Issue Tracking Relational Database

zk_F_legal_issue_ID_t

conductexactdate_of_written_notice_g…dateCreationdatemodificationdateofeventdocument_in_pdf_formatdocument_notice_or_otherevent_locationevent_total_ceventDescriptioneventHourseventLabel_ceventLabelwithGrayOptio…eventMenuDisplay_ceventNumbereventNumberDisplay_ceventNumberMax_seventTitleform_violationgCheckboxGrayOutOtherE…gpaCurrentt_legal_case_cisDeletable_booleannature_of_eventnotice_given_personnotice_givenby_partynumContacts_Witnesses…penalcodeviolationpersonsinvolvedpolicereportnumberproperty_informationreportedtopoliceresponsebypartygivennoti…summary_of_noticetime_begin_eventtime_end_eventtotaltimeofeventvvictim_accountz___DEVELOPER___zc_person_Label_tzc_recordsLabel_tzc_SORT_legal_issue_tzg_legal_issue_Selector_tzk_A_constant_nzk_A_currentLegal_Issue_tzk_F_DOCUMENT_ID_tzk_F_legal_issue_ID_tzk_F_person_ID_tzk_P_event_ID_t

course.currentLegal_Iss…

zk_A_constant_nzk_P_legal_issue_ID_tzkg_currentlegal_issue_ID_t

dateBegin_Legal_ActiondateBegin_Legal_IssuedateEnd_Legal_ActiondateEnd_Legal_IssueisDeletable_boolean_cjurisdiction_caselegal_issuelegal_issue_Label_clegal_issue_LabelWithGrayOption_clegal_issue_MenuDisplay_clegal_issue_Selection_cyearBegin_Legal_IssueyearEnd_Legal_Issuez___DEVELOPER___zk_A_constant_nzk_P_legal_issue_ID_tzkg_currentlegal_issue_ID_t

legal_issue

zk_A_constant_n

dateBegin_Legal_ActiondateBegin_Legal_IssuedateEnd_Legal_ActiondateEnd_Legal_IssueisDeletable_boolean_cjurisdiction_caselegal_issuelegal_issue_Label_clegal_issue_LabelWithGrayOption_clegal_issue_MenuDisplay_clegal_issue_Selection_cyearBegin_Legal_IssueyearEnd_Legal_Issuez___DEVELOPER___zk_A_constant_nzk_P_legal_issue_ID_tzkg_currentlegal_issue_ID_t

legal_issue.constant

event

zk_P_legal_issue_ID_t

dateBegin_Legal_ActiondateBegin_Legal_IssuedateEnd_Legal_ActiondateEnd_Legal_IssueisDeletable_boolean_cjurisdiction_caselegal_issuelegal_issue_Label_clegal_issue_LabelWithGrayOption_clegal_issue_MenuDisplay_clegal_issue_Selection_cyearBegin_Legal_IssueyearEnd_Legal_Issuez___DEVELOPER___zk_A_constant_nzk_P_legal_issue_ID_tzkg_currentlegal_issue_ID_t

legal_issue.currentLegal_CaseID_legal_c…

zk_P_legal_issue_ID_t

dateBegin_Legal_ActiondateBegin_Legal_IssuedateEnd_Legal_ActiondateEnd_Legal_IssueisDeletable_boolean_cjurisdiction_caselegal_issuelegal_issue_Label_clegal_issue_LabelWithGrayOption_clegal_issue_MenuDisplay_clegal_issue_Selection_cyearBegin_Legal_IssueyearEnd_Legal_Issuez___DEVELOPER___zk_A_constant_nzk_P_legal_issue_ID_tzkg_currentlegal_issue_ID_t

legal_issue.currentLegal_IssueID

Page 3: Christine Griffin's Legal Issue Tracking Relational Database

zk_A_constant_n

gTabLabel01gTabLabel02gTabLabel03gTabLabel04gTabLabel05gTabLabel06gTabLabel07gTabLabel08z___DEVELOPER___zk_A_constant_nzx___GRAPHICS___zx_graphicBarLogozx_graphicHeaderBackgroundzx_graphicSubTabBarzx_graphicTabActivezx_graphicTabBarzx_iconArrowBlueDownzx_iconArrowBlueLeftzx_iconArrowBlueRightzx_iconArrowBlueUpzx_iconCalendarzx_iconCheckzx_iconCheckboxFalsezx_iconCheckboxTruezx_iconEditzx_iconExcelzx_iconFindzx_iconFindAllzx_iconFindConstrainzx_iconFindExtendzx_iconFindReplacezx_iconGotoWebpagezx_iconInteraction

zUserInterface

zk_P_legal_issue_ID_t

dateBegin_Legal_ActiondateBegin_Legal_IssuedateEnd_Legal_ActiondateEnd_Legal_IssueisDeletable_boolean_cjurisdiction_caselegal_issuelegal_issue_Label_clegal_issue_LabelWithGrayO…legal_issue_MenuDisplay_clegal_issue_Selection_cyearBegin_Legal_IssueyearEnd_Legal_Issuez___DEVELOPER___zk_A_constant_nzk_P_legal_issue_ID_tzkg_currentlegal_issue_ID_t

legal_issue.gLegal_Issue_S…

zk_A_constant_n

gTabLabel01gTabLabel02gTabLabel03gTabLabel04gTabLabel05gTabLabel06gTabLabel07gTabLabel08z___DEVELOPER___zk_A_constant_nzx___GRAPHICS___zx_graphicBarLogozx_graphicHeaderBac…zx_graphicSubTabBarzx_graphicTabActivezx_graphicTabBarzx_iconArrowBlueDownzx_iconArrowBlueLeftzx_iconArrowBlueRightzx_iconArrowBlueUpzx_iconCalendarzx_iconCheckzx_iconCheckboxFalsezx_iconCheckboxTruezx_iconEditzx_iconExcelzx_iconFindzx_iconFindAllzx_iconFindConstrain

zUI.person.contantzk_A_constant_nzk_P_personID_t

addressCityaddressLine1addressLine2addressStateaddressZipBadge_NumberBadge_Number_or_LicensedateCreationemail_addressexactconductFaxMainisDeletable_boolean_clitigamtnameFirstnameFull_cnameFullLastFirst_cnameLastnotesnotes_Generalnotes_Personalnotes 2number_of_times_participated_eventsnumber_of_years_rentingorganizationpersonNumberpersonsinvolvedphone_homephoneHomephoneMainphoneMainDisplay_cphoneMainExtensionphoneMobileTitlez___DEVELOPER___zc_recordsLabel_tzk_A_constant_nzk_P_document_ID_tzk_P_personID_tzkc_currentlegalcaseID_t

person

Page 4: Christine Griffin's Legal Issue Tracking Relational Database

zg_legal_issue_Selector_tzk_A_constant_nzk_F_DOCUMENT_ID_tzk_F_legal_issue_ID_tzk_F_person_ID_tzk_P_event_ID_t

address_location_of_incidentcivil_code_violation_californiacivilpenaltiescomplaint_to_government_authorityconductconductexactdate_of_written_notice_givenby_partydateCreationdatemodificationdateofeventdocument_in_pdf_formatdocument_notice_or_otherevent_locationevent_total_ceventDescriptioneventHourseventLabel_ceventLabelwithGrayOption_ceventMenuDisplay_ceventNumbereventNumberDisplay_ceventNumberMax_seventTitleform_violationgCheckboxGrayOutOtherEvents_booleangpaCurrentt_legal_case_cisDeletable_booleannature_of_eventnotice_given_personnotice_givenby_partynumContacts_Witnesses_Associated_cpenalcodeviolationpersonsinvolvedpolicereportnumberproperty_informationreportedtopoliceresponsebypartygivennoticesummary_of_noticetime_begin_eventtime_end_eventtotaltimeofeventvvictim_accountz___DEVELOPER___zc_person_Label_tzc_recordsLabel_tzc_SORT_legal_issue_tzg_legal_issue_Selector_tzk_A_constant_nzk_A_currentLegal_Issue_tzk_F_DOCUMENT_ID_tzk_F_legal_issue_ID_tzk_F_person_ID_tzk_P_event_ID_t

event

zk_A_constant_n

gBuildVersion_tgCurrentGlobal_tgCurrentSelectionID_tgLastErrorCode_tgPopupWindowCommand_tgReferenceLayoutNumber_ngStatusAreaState_nz___DEVELOPER___zk_A_constant_n

zGlobal

zk_F_legal_issue_ID_t

address_location_of_incidentcivil_code_violation_californiacivilpenaltiescomplaint_to_government_…conductconductexactdate_of_written_notice_give…dateCreationdatemodificationdateofeventdocument_in_pdf_formatdocument_notice_or_otherevent_locationevent_total_ceventDescriptioneventHourseventLabel_ceventLabelwithGrayOption_ceventMenuDisplay_ceventNumbereventNumberDisplay_ceventNumberMax_seventTitleform_violationgCheckboxGrayOutOtherEve…gpaCurrentt_legal_case_cisDeletable_booleannature_of_eventnotice_given_personnotice_givenby_partynumContacts_Witnesses_As…penalcodeviolationpersonsinvolvedpolicereportnumberproperty_informationreportedtopoliceresponsebypartygivennoticesummary_of_noticetime_begin_eventtime_end_eventtotaltimeofeventvvictim_accountz___DEVELOPER___zc_person_Label_tzc_recordsLabel_tzc_SORT_legal_issue_tzg_legal_issue_Selector_tzk_A_constant_nzk_A_currentLegal_Issue_tzk_F_DOCUMENT_ID_tzk_F_legal_issue_ID_tzk_F_person_ID_tzk_P_event_ID_t

event.gLegal_IssueSelector

Page 5: Christine Griffin's Legal Issue Tracking Relational Database

zk_A_constant_n

gTabLabel01gTabLabel02gTabLabel03gTabLabel04gTabLabel05gTabLabel06gTabLabel07gTabLabel08z___DEVELOPER___zk_A_constant_nzx___GRAPHICS___zx_graphicBarLogozx_graphicHeaderBackgroundzx_graphicSubTabBarzx_graphicTabActivezx_graphicTabBarzx_iconArrowBlueDownzx_iconArrowBlueLeftzx_iconArrowBlueRightzx_iconArrowBlueUpzx_iconCalendarzx_iconCheckzx_iconCheckboxFalsezx_iconCheckboxTruezx_iconEditzx_iconExcelzx_iconFindzx_iconFindAllzx_iconFindConstrainzx_iconFindExtendzx_iconFindReplacezx_iconGotoWebpagezx_iconInteractionzx_iconPDF

zUI.document.contant 2

zk_F_document_ID_t

addressed_to_whomauthorcostdate_createddate_delivereddate_sentdocumentdocument_in_pdf_for…document_NUMBERformat_documenthow_deliveredname_documentpost_timeTotal_Costtypevendorz___DEVELOPER___zc_recordsLabel_tzc_SORT_legal_issuer_tzg_legalissue_Selecto…zk_A_constant_nzk_A_current_Legal_I…zk_F_document_ID_tzk_F_legalissueID_tzk_F_personID_tzk_P_event_ID_tzk_P_response_ID_t

documents_events

zk_A_constant_nzk_F_document_ID_t

addressed_to_whomauthorcostdate_createddate_delivereddate_sentdocumentdocument_in_pdf_formatdocument_NUMBERformat_documenthow_deliveredname_documentpost_timeTotal_Costtypevendorz___DEVELOPER___zc_recordsLabel_tzc_SORT_legal_issuer_tzg_legalissue_Selector_tzk_A_constant_nzk_A_current_Legal_Issue_tzk_F_document_ID_tzk_F_legalissueID_tzk_F_personID_tzk_P_event_ID_tzk_P_response_ID_t

documents

Page 6: Christine Griffin's Legal Issue Tracking Relational Database

zk_P_document_ID_t

addressCityaddressLine1addressLine2addressStateaddressZipBadge_NumberBadge_Number_or_LicensedateCreationemail_addressexactconductFaxMainisDeletable_boolean_clitigamtnameFirstnameFull_cnameFullLastFirst_cnameLastnotesnotes_Generalnotes_Personalnotes 2number_of_times_participated_e…number_of_years_rentingorganizationpersonNumberpersonsinvolvedphone_homephoneHomephoneMainphoneMainDisplay_cphoneMainExtensionphoneMobileTitlez___DEVELOPER___zc_recordsLabel_tzk_A_constant_nzk_P_document_ID_tzk_P_personID_tzkc_currentlegalcaseID_t

personDocument