전자소송(ECFS) ERD 220228

테이블 (10)

당사자정보(원고) (Barom_Plaintiff)

  • Key (plaintiff_no) — NUMBER — 기본 키 — NOT NULL
  • Key (caseBasicInfo_no) — NUMBER — 외래 키 → 사건기본정보.Key — NOT NULL
  • Field (plaintiff_personal) — VARCHAR2(30)
  • Field (plaintiff_selected) — VARCHAR2(10)
  • Field (plaintiff_resident_num) — VARCHAR2(20)
  • Field (plaintiff_name) — VARCHAR2(40)
  • Field (plaintiff_address) — VARCHAR2(100)
  • Field (plaintiff_send_address) — VARCHAR2(100)
  • Field (plaintiff_send_user_id) — VARCHAR2(20)
  • Field (plaintiff_nationality) — VARCHAR2(20)
  • Field (plaintiff_phone) — VARCHAR2(20)
  • Field (plaintiff_email) — VARCHAR2(40)

당사자정보(피고) (Barom_Defendant)

  • Key (defendant_no) — NUMBER — 기본 키 — NOT NULL
  • Key (caseBasicInfo_no) — NUMBER — 외래 키 → 사건기본정보.Key — NOT NULL
  • Field (defendant_personal) — VARCHAR2(30)
  • Field (defendant_resident_num) — VARCHAR2(20)
  • Field3 (defendant_name) — VARCHAR2(40)
  • Field4 (defendant_address) — VARCHAR2(100)
  • Field (defendant_send_address) — VARCHAR2(100)
  • Field2 (defendant_send_user_id) — VARCHAR2(20)
  • Field3 (defendant_nationality) — VARCHAR2(20
  • Field5 (defendant_phone) — VARCHAR2(20
  • Field (defendant_email) — VARCHAR2(40)

민사 소장 법원명 카테고리 (BR_Min_Sj_Court_Category)

  • Key (min_sj_court_category_no) — NUMBER — 기본 키 — NOT NULL
  • Field (min_sj_court_category_name) — VARCHAR2(20)

민사 소장 사건명 카테고리 (BR_Min_Sj_Sgn_Category)

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

사건기본정보 (Barom_CaseBasicInfo)

  • Key (caseBasicInfo_no) — NUMBER — 기본 키 — NOT NULL
  • Key (user_no) — NUMBER — 외래 키 → 사용자등록.Key — NOT NULL
  • Key (min_sj_sgn_category_no) — NUMBER — 외래 키 → 민사 소장 사건명 카테고리.Key — NOT NULL
  • Key (min_sj_court_category_no) — NUMBER — 외래 키 → 민사 소장 법원명 카테고리.Key — NOT NULL
  • Field (caseBasicInfo_claim_method) — VARCHAR2(20)
  • Field (caseBasicInfo_price_method) — VARCHAR2(30)
  • Field (caseBasicInfo_price) — NUMBER

사용자등록 (Barom_User)

  • Key (user_no) — NUMBER — 기본 키 — NOT NULL
  • Field (user_id) — VARCHAR2(20)
  • Field (user_pw) — VARCHAR2(30)
  • Field (user_name) — VARCHAR2(10)
  • Field (user_address) — VARCHAR2(100)
  • Field (user_phone) — VARCHAR2(20)
  • Field (user_email) — VARCHAR2(40)

입증서류 첨부 (Barom_ProofAttach)

  • Key (proofAttach_no) — NUMBER — 기본 키 — NOT NULL
  • Key (plaintiff_no) — NUMBER — 외래 키 → 당사자정보(원고).Key — NOT NULL
  • Field (proofAttach_title) — VARCHAR2(30)
  • Field (proofAttach_url) — VARCHAR2(100)

작성문서 확인(PDF) (Barom_DocumentConfirmed)

  • Key (confirmed_no) — NUMBER — 기본 키 — NOT NULL
  • Key (caseBasicInfo_no) — NUMBER — 외래 키 → 사건기본정보.Key — NOT NULL
  • Field (confirmed_url) — VARACHAR2(100)

청구원인 (Barom_Cause)

  • Key (cause_no) — NUMBER — 기본 키 — NOT NULL
  • Key (plaintiff_no) — NUMBER — 외래 키 → 당사자정보(원고).Key — NOT NULL
  • Field (cause_content) — VARCHAR2(4000)
  • Field (cause_attach_url) — VARCHAR2(100)

청구취지입력 (Barom_Purpose)

  • Key (purpose_no) — NUMBER — 기본 키 — NOT NULL
  • Key (plaintiff_no) — NUMBER — 외래 키 → 당사자정보(원고).Key — NOT NULL
  • Field (purpose_content) — VARCHAR2(4000)
  • Field (purpose_attach) — VARCHAR2(100)