ERD

Tables (29)

BR_Case_confirmed_Status (승인배당사건진행상황)

  • caseconfirmed_status_no (진행상황pk) — Primary key — NOT NULL
  • caseconfirmed_status_name (진행상황 이름)

BR_Customer_Question (Q&A)

  • cus_question_no (Key) — Primary key — NOT NULL
  • user_no (Key2) — Foreign key → Barom_user.user_no — NOT NULL
  • cus_question_title (Field)
  • cus_question_content (Field2)
  • cus_question_readcount (Field3)
  • cus_question_secret (Field4)
  • cus_question_writedate (Field5)

BR_Customer_Question_Like (Q&A 좋아요)

  • question_like_no (Key) — Primary key — NOT NULL
  • user_no (Key2) — Foreign key → Barom_user.user_no — NOT NULL
  • cus_question_no (Key3) — Foreign key → BR_Customer_Question.cus_question_no — NOT NULL
  • like_date (Field)

BR_Min_Sj_Court_Category (법원카테고리)

  • min_sj_court_category_no (법원pk) — Primary key — NOT NULL
  • min_sj_court_category_name (법원이름)

BR_Min_Sj_Sgn_Category_seq (사건유형카테고리)

  • min_sj_sgn_category_no (사건유형pk) — Primary key — NOT NULL
  • min_sj_sgn_category_name (사건유형이름)

BR_Repple (Q&A 댓글)

  • repple_no (Key) — Primary key — NOT NULL
  • user_no (Key2) — Foreign key → Barom_user.user_no — NOT NULL
  • cus_question_no (Key3) — Foreign key → BR_Customer_Question.cus_question_no — NOT NULL
  • repple_content (Field)
  • repple_writedate (Field2)

BR_Repple_Like (Untitled)

  • repple_like_no (Key) — Primary key — NOT NULL
  • user_no (Key2) — Foreign key → Barom_user.user_no — NOT NULL
  • repple_no (Key3) — Foreign key → BR_Repple.repple_no — NOT NULL
  • repple_like_date (Field)

BR_attorney_realted (대리자/당사자관계)

  • attorney_related_no (대리자/당사자관계pk) — Primary key — NOT NULL
  • concerned_no (당사자pk) — Foreign key → Barom_Plaintiff.plaintiff_no — NOT NULL
  • concerned_no (Key3) — Foreign key → Barom_Defendant.defendant_no — NOT NULL
  • attorney_no (대리인pk) — Foreign key → Barom_attorney.attorney_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_Plaintiff.submit_no — NOT NULL
  • attorney_related_for (당사자파벌)

Barom_CaseBasicInfo (사건기본정보)

  • caseBasicInfo_no (사건기본정보pk) — Primary key — NOT NULL
  • case_no (사건pk) — Foreign key → Barom_case.case_no — NOT NULL
  • min_sj_sgn_category_no (사건유형pk) — Foreign key → BR_Min_Sj_Sgn_Category_seq.min_sj_sgn_category_no — NOT NULL
  • min_sj_court_category_no (법원pk) — Foreign key → BR_Min_Sj_Court_Category.min_sj_court_category_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_case.submit_no — NOT NULL
  • caseBasicInfo_claim_method (청구구분)
  • caseBasicInfo__price_method (소가구분)
  • caseBasicInfo__price (소가)

Barom_Case_Confirmed (승인 및 배당된 사건)

  • Case_Confirmed_no (승인배당사건pk) — Primary key — NOT NULL
  • case_no (사건pk) — Foreign key → Barom_case.case_no — NOT NULL
  • min_sj_sgn_category_no (사건유형pk) — Foreign key → BR_Min_Sj_Sgn_Category_seq.min_sj_sgn_category_no — NOT NULL
  • min_sj_court_category_no (법원pk) — Foreign key → BR_Min_Sj_Court_Category.min_sj_court_category_no — NOT NULL
  • caseconfirmed_status_no (진행상황pk) — Foreign key → BR_Case_confirmed_Status.caseconfirmed_status_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_case.submit_no — NOT NULL
  • case_confirmed_date (승인배당날짜)
  • case_status_reason (진행이유)

Barom_Cause (청구원인)

  • cause_no (청구원인pk) — Primary key — NOT NULL
  • case_no (사건pk) — Foreign key → Barom_case.case_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_case.submit_no — NOT NULL
  • cause_content (청구원인설명)
  • cause_attach (청구원인첨부)

Barom_Defendant (피고)

  • defendant_no (피고pk) — Primary key — NOT NULL
  • case_no (사건pk) — Foreign key → Barom_case.case_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_case.submit_no — NOT NULL
  • defendant_personal (피고 인격)
  • defendant_resident_num (피고 사업자번호)
  • defendant_name (피고 이름)
  • defendant_zipcode (피고 우편번호)
  • defendant_address (피고 주소)
  • defendant_send_address (피고 상세주소)
  • defendant_nationality (피고 국적)
  • defendant_phone (피고 연락처)
  • defendant_email (피고 이메일)

Barom_Defense (답변서)

  • Defense_no (답변서pk) — Primary key — NOT NULL
  • Case_Confirmed_no (승인배당사건pk) — Foreign key → Barom_Case_Confirmed.Case_Confirmed_no — NOT NULL
  • user_no (회원pk) — Foreign key → Barom_user.user_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_Case_Confirmed.submit_no — NOT NULL
  • concerned_related (작성자의당사자와의관계)
  • cause_answer_content (청구취지답변 내용)
  • purpose_answer_content (청구원인답변 내용)
  • defense_date (답변서날짜)

Barom_Defense_Document (Untitled2)

  • document_no (Key) — Primary key — NOT NULL
  • Defense_no (답변서pk) — Foreign key → Barom_Defense.Defense_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_Defense.submit_no — NOT NULL
  • document_url (Field)

Barom_Defense_ProofFile (CopyOf입증서류)

  • file_no (파일pk) — Primary key — NOT NULL
  • Defense_no (답변서pk) — Foreign key → Barom_Defense.Defense_no — NOT NULL
  • user_no (회원pk) — Foreign key → Barom_Defense.user_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_Defense.submit_no — NOT NULL
  • file_name (파일이름(경로))
  • file_original_name (파일원본이름)
  • file_extension (파일확장자)
  • file_date (파일등록일)

Barom_DocumentConfirmed (PDF 작성문서 확인)

  • confirmed_no (작성문서확인pk) — Primary key — NOT NULL
  • case_no (사건pk) — Foreign key → Barom_case.case_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_case.submit_no — NOT NULL
  • confirmed_url (pdf경로)
  • confirmed_status (확인여부)

Barom_Plaintiff (원고)

  • plaintiff_no (원고pk) — Primary key — NOT NULL
  • case_no (사건pk) — Foreign key → Barom_case.case_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_case.submit_no — NOT NULL
  • plaintiff_personal (원고 인격)
  • plaintiff_selected (원고 대표자 여부)
  • plaintiff_resident_num (원고 사업자번호)
  • plaintiff_name (원고 이름)
  • plaintiff_zipcode (원고 우편번호)
  • plaintiff_address (원고 주소)
  • plaintiff_send_address (원고 주소 상세)
  • plaintiff_nationality (원고 국적)
  • plaintiff_phone (원고 연락처)
  • plaintiff_email (원고 이메일)

Barom_ProofFile (입증서류)

  • file_no (파일pk) — Primary key — NOT NULL
  • case_no (사건pk) — Foreign key → Barom_case.case_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_case.submit_no — NOT NULL
  • file_name (파일이름(경로))
  • file_original_name (파일원본이름)
  • file_extension (파일확장자)
  • file_date (파일등록일)

Barom_Purpose (청구취지)

  • purpose_no (청구취지pk) — Primary key — NOT NULL
  • case_no (사건pk) — Foreign key → Barom_case.case_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_case.submit_no — NOT NULL
  • purpose_content (청구취지설명)
  • purpose_attach (청구취지첨부)

Barom_admin (관리자)

  • admin_no (관리자pk) — Primary key — NOT NULL
  • min_sj_court_category_no (법원pk) — Foreign key → BR_Min_Sj_Court_Category.min_sj_court_category_no — NOT NULL
  • admin_category_no (관리자카테고리pk) — Foreign key → admin_category.admin_category_no — NOT NULL
  • admin_id (관리자id)
  • admin_pw (관리자 pw)

Barom_attorney (대리인)

  • attorney_no (대리인pk) — Primary key — NOT NULL
  • attorney_personal (대리인 인격)
  • attorney_resident_num (대리인 사업자번호)
  • attorney_name (대리인 이름)
  • attorney_zipcode (대리인 우편번호)
  • attorney_address (대리인 주소)
  • attorney_send_address (대리인 상세주소)
  • attorney_nationality (대리인 국적)
  • attorney_phone (대리인 연락처)
  • attorney_email (대리인 이메일)

Barom_case (사건)

  • case_no (사건pk) — Primary key — NOT NULL
  • user_no (회원pk) — Foreign key → Barom_user.user_no — NOT NULL
  • status_no (상황pk) — Foreign key → Barom_submit_status.status_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_case_submit.submit_no — NOT NULL
  • case_date (소장저장일)
  • case_refuse_reason (소장반려사유)

Barom_case_submit (사건제출상태)

  • submit_no (제출pk) — Primary key — NOT NULL
  • submit_name (제출상태)

Barom_defendant_case (피고측 사건등록)

  • defendant_case_no (피고측사건pk) — Primary key — NOT NULL
  • Case_Confirmed_no (승인배당사건pk) — Foreign key → Barom_Case_Confirmed.Case_Confirmed_no — NOT NULL
  • user_no (회원pk(피고)) — Foreign key → Barom_user.user_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_Case_Confirmed.submit_no — NOT NULL

Barom_findQuestion (비번찾기질문)

  • findQuestion_no (비번찾기질문pk) — Primary key — NOT NULL
  • findQuestion_content (질문내용)

Barom_submit_status (문서 제출상황)

  • status_no (상황pk) — Primary key — NOT NULL
  • status_name (상황이름)

Barom_trial (판결)

  • trial_no (재판pk) — Primary key — NOT NULL
  • Case_Confirmed_no (승인배당사건pk) — Foreign key → Barom_Case_Confirmed.Case_Confirmed_no — NOT NULL
  • submit_no (제출pk) — Foreign key → Barom_Case_Confirmed.submit_no — NOT NULL
  • trial_date (재판청구날짜)
  • trial_result_status (판결/결정/명령 여부)
  • trial_result_order (주문)
  • trial_result_reason (이유)
  • trial_result_date (결과 발생 날짜)

Barom_user (사용자)

  • user_no (회원pk) — Primary key — NOT NULL
  • findQuestion_no (비번찾기질문pk) — Foreign key → Barom_findQuestion.findQuestion_no — NOT NULL
  • user_id (회원아이디)
  • user_pw (회원비밀번호)
  • user_name (회원이름)
  • user_jumin1 (회원민번앞자리)
  • user_jumin2 (회원민번뒷자리)
  • user_zipcode (우편번호)
  • user_address (주소)
  • user_send_address (주소 상세)
  • user_phone (연락처)
  • user_email (이메일)
  • user_state (가입승인여부)
  • user_latestAccess (마지막로그인)
  • user_findAnswer (비번찾기질문대답)

admin_category (관리자카테고리)

  • admin_category_no (관리자카테고리pk) — Primary key — NOT NULL
  • admin_category_name (관리자카테고리이름)