전자소송 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)