전자소송 ERD220314

테이블 (20)

BR_Anncm_Files (CopyOf공지사항)

  • anncm_files_no (anncm_no) — NUMBER — 기본 키 — NOT NULL
  • anncm_no (anncm_no2) — NUMBER — 외래 키 → BR_Announcement.anncm_no — NOT NULL
  • anncm_files_url (anncm_title) — VARCHAR2(300)
  • anncm_original_filename (anncm_content) — VARCHAR2(400)

BR_Announcement (공지사항)

  • anncm_no — NUMBER — 기본 키 — NOT NULL
  • admin_no (Key) — NUMBER — 외래 키 → Barom_Admin.admin_no — NOT NULL
  • anncm_title — VARCHAR2(60)
  • anncm_content — VARCHAR2(2000)
  • anncm_writedate — DATE
  • anncm_readcount — NUMBER

BR_Customer_Answer (QnA 답(댓)글)

  • cus_answer_no (Key) — NUMBER — 기본 키 — NOT NULL
  • cus_question_no (Key2) — NUMBER — 외래 키 → BR_Customer_Question.cus_question_no — NOT NULL
  • admin_no (Key3) — NUMBER — 외래 키 → Barom_Admin.admin_no — NOT NULL
  • cus_answer_title (Field4) — VARCHAR2(200)
  • cus_answer_content (Field) — VARCHAR2(4000)
  • cus_answer_writedate (Field2) — DATE
  • cus_answer_readcount (Field3) — NUMBER

BR_Customer_Question (QnA 질문글)

  • cus_question_no (Key) — NUMBER — 기본 키 — NOT NULL
  • user_no — NUMBER — 외래 키 → Barom_user.user_no — NOT NULL
  • cus_question_title (Field4) — VARCHAR2(200)
  • cus_question_content (Field) — VARCHAR2(4000)
  • cus_question_writedate (Field2) — DATE
  • cus_question_readcount (Field3) — NUMBER

BR_FAQ (자주하는질문)

  • faq_no — NUMBER — 기본 키 — NOT NULL
  • faq_category_no — NUMBER — 외래 키 → BR_FAQ_Category.faq_category_no — NOT NULL
  • admin_no — NUMBER — 외래 키 → Barom_Admin.admin_no — NOT NULL
  • faq_title — VARCHAR2(150)
  • faq_content — VARCHAR2(2000)
  • faq_readcount — NUMBER

BR_FAQ_Category (자주하는질문 분류)

  • faq_category_no — NUMBER — 기본 키 — NOT NULL
  • faq_category_name — VARCHAR2(60)

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_Admin (관리자)

  • admin_no (Key) — NUMBER — 기본 키 — NOT NULL
  • admin_level (Field3) — VARCHAR2(10)
  • admin_id (Field) — VARCHAR2(20)
  • admin_pw (Field2) — VARCHAR2(500)
  • admin_latestAccess (Field10) — DATE

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)
  • confirmed_status (Field2) — VARCHAR2(1)

Barom_PL_Attorney (원고측 대리인)

  • pl_attorney_no (Key3) — 기본 키 — NOT NULL
  • plaintiff_no (Key) — NUMBER — 외래 키 → Barom_Plaintiff.plaintiff_no — NOT NULL
  • case_no (Key2) — VARCHAR2(20) — 외래 키 → Barom_Plaintiff.case_no — NOT NULL
  • pl_attorney_type (Field)
  • pl_attorney_name (Field2)
  • pl_attorney_send_address (Field3)
  • pl_attorney_phone (Field4)
  • pl_attorney_email (Field5) — VARCHAR2(500)

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_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)
  • user_phone (Field7) — VARCHAR2(50)
  • user_email (Field8) — VARCHAR2(500)
  • user_state (Field9) — VARCHAR2(10)
  • user_latestAccess (Field10) — DATE
  • user_findAnswer (Field11) — VARCHAR2(50)