전자소송ERD220308

테이블 (15)

BR_Min_Sj_Court_Category (민사 법원명)

  • min_sj_court_category_no (Key) — NUMBER — 기본 키 — NOT NULL
  • min_sj_court_category_namemin_sj_court_category_name (Field) — VARCHAR2(150)

BR_Min_Sj_Sgn_Category (민사 사건명)

  • min_sj_sgn_category_no (Key) — NUMBER — 기본 키 — NOT NULL
  • min_sj_sgn_category_name (Field) — VARCHAR2(150)

Barom_CaseBasicInfo (사건 기본정보)

  • caseBasicInfo_no (Key) — NUMBER — 기본 키 — NOT NULL
  • case_no (Key2) — VARCHAR2(20) — 외래 키 → Barom_case.case_no — NOT NULL
  • min_sj_sgn_category_no (Key3) — NUMBER — 외래 키 → BR_Min_Sj_Sgn_Category.min_sj_sgn_category_no — NOT NULL
  • min_sj_court_category_no (Key4) — NUMBER — 외래 키 → BR_Min_Sj_Court_Category.min_sj_court_category_no — NOT NULL
  • caseBasicInfo_claim_method (Field) — VARCHAR2(20)
  • caseBasicInfo_price_method (Field2) — VARCHAR2(30)
  • caseBasicInfo_price (Field3) — NUMBER

Barom_Cause (청구원인)

  • Cause_no (Key) — NUMBER — 기본 키 — NOT NULL
  • case_no (Key2) — VARCHAR2(20) — 외래 키 → Barom_case.case_no — NOT NULL
  • cause_content (Field) — VARCHAR2(4000)
  • cause_attach (Field2) — VARCHAR2(100)

Barom_Defendant (피고)

  • defendant_no (Key) — NUMBER — 기본 키 — NOT NULL
  • case_no (Key2) — VARCHAR2(20) — 외래 키 → Barom_case.case_no — NOT NULL
  • defendant__personal (Field) — VARCHAR2(30)
  • defendant_resident_num (Field2) — VARCHAR2(20)
  • defendant_name (Field3) — VARCHAR2(100)
  • defendant_address (Field4) — VARCHAR2(500)
  • defendant__send_address (Field5) — VARCHAR2(500)
  • defendant__nationality (Field6) — VARCHAR2(20)
  • defendant_phone (Field7) — VARCHAR2(50)
  • defendant_email (Field8) — VARCHAR2(500)
  • defendant_zipcode (Field9) — NUMBER

Barom_DocumentConfirmed (PDF 출력 확인)

  • confirmed_no (Key) — NUMBER — 기본 키 — NOT NULL
  • case_no (Key2) — VARCHAR2(20) — 외래 키 → Barom_case.case_no — NOT NULL
  • confirmed_url (Field) — VARCHAR2(100)

Barom_Plaintiff (원고)

  • plaintiff_no (Key) — NUMBER — 기본 키 — NOT NULL
  • case_no (Key2) — VARCHAR2(20) — 외래 키 → Barom_case.case_no — NOT NULL
  • plaintiff_personal (Field) — VARCHAR2(30)
  • plaintiff_selected (Field2) — VARCHAR2(10)
  • plaintiff_resident_num (Field3) — VARCHAR2(20)
  • plaintiff_name (Field4) — VARCHAR2(100)
  • plaintiff_zipcode (Field10) — NUMBER
  • plaintiff_address (Field5) — VARCHAR2(500)
  • plaintiff_send_address (Field6) — VARCHAR2(500)
  • plaintiff_nationality (Field7) — VARCHAR2(20)
  • plaintiff_phone (Field8) — VARCHAR2(50)
  • plaintiff_email (Field9) — VARCHAR2(500)

Barom_ProofFile (입증파일)

  • file_no (Key) — NUMBER — 기본 키 — NOT NULL
  • case_no (Key2) — VARCHAR2(20) — 외래 키 → Barom_case.case_no — NOT NULL
  • file_name (Field) — VARCHAR2(500)
  • file_original_name (Field2) — VARCHAR2(500)
  • file_extension (Field3) — VARCHAR2(10)
  • file_date (Field4) — DATE

Barom_Purpose (청구취지)

  • purpose_no (Key) — NUMBER — 기본 키 — NOT NULL
  • case_no (Key2) — VARCHAR2(20) — 외래 키 → Barom_case.case_no — NOT NULL
  • purpose_content (Field) — VARCHAR2(4000)
  • purpose_attach (Field2) — VARCHAR2(100)

Barom_case (소장)

  • case_no (Key) — VARCHAR2(20) — 기본 키 — NOT NULL
  • user_no — NUMBER — 외래 키 → Barom_user.user_no — NOT NULL
  • case_status (Field) — VARCHAR2(20)
  • case_save_date (Field2) — DATE

Barom_caseStatus (Untitled)

    Barom_findQuestion (회원정보 찾기 질문)

    • findQuestion_no (Key) — NUMBER — 기본 키 — NOT NULL
    • findQuestion_content (Field) — VARCHAR2(50)

    Barom_user (회원)

    • user_no — NUMBER — 기본 키 — NOT NULL
    • findQuestion_no (Key) — NUMBER — 외래 키 → Barom_findQuestion.findQuestion_no — NOT NULL
    • user_id (Field) — VARCHAR2(20)
    • user_pw (Field2) — VARCHAR2(500)
    • user_name (Field3) — VARCHAR2(100)
    • user_jumin1 (Field4) — VARCHAR2(6)
    • user_jimin2 (Field5) — VARCHAR2(7)
    • user_zipcode (Field12) — NUMBER
    • user_address (Field6) — VARCHAR2(500)
    • user_send_address (Field13) — VARCHAR2(500)
    • user_phone (Field7) — VARCHAR2(50)
    • user_email (Field8) — VARCHAR2(500)
    • user_state (Field9) — VARCHAR2(10)
    • user_latestAccess (Field10) — DATE
    • user_findAnswer (Field11) — VARCHAR2(50)

    대리인 (Untitled3)

      대리인 관계 (Untitled2)