erdForPpt

Tables (32)

BR_Anncm_Files (Untitled5)

  • anncm_files_no (Key) — Primary key — NOT NULL
  • anncm_no (Key2) — Foreign key → BR_Announcement.anncm_no — NOT NULL
  • anncm_files_url (Field)
  • anncm_original_filename (Field2)

BR_Announcement (Untitled4)

  • anncm_no (Key) — Primary key — NOT NULL
  • admin_no (관리자pk) — Foreign key → Barom_admin.admin_no — NOT NULL
  • anncm_title (Field)
  • anncm_content (Field2)
  • anncm_writedate (Field3)
  • anncm_readcount (Field4)

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_FAQ (Untitled2)

  • faq_no (Key) — Primary key — NOT NULL
  • admin_no (관리자pk) — Foreign key → Barom_admin.admin_no — NOT NULL
  • faq_category_no (Key2) — Foreign key → BR_FAQ_Category.faq_category_no — NOT NULL
  • faq_title (Field2)
  • faq_content (Field3)
  • Field4

BR_FAQ_Category (Untitled3)

  • faq_category_no (Key) — Primary key — NOT NULL
  • faq_category_name (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)

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
  • 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
  • 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
  • cause_content (청구원인설명)
  • cause_attach (청구원인첨부)

Barom_Defendant (피고)

  • defendant_no (피고pk) — Primary key — NOT NULL
  • case_no (사건pk) — Foreign key → Barom_case.case_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
  • cause_answer_content (청구취지답변 내용)
  • purpose_answer_content (청구원인답변 내용)
  • defense_date (답변서날짜)

Barom_Defense_Document (답변서 PDF)

  • document_no (답변서 PDF pk) — Primary key — NOT NULL
  • Defense_no (답변서pk) — Foreign key → Barom_Defense.Defense_no — NOT NULL
  • document_url (답변서 url)

Barom_Defense_ProofFile (답변서 제출서류)

  • 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
  • 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
  • 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
  • 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
  • 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
  • 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_approval_status (소장승인상태)

  • approval_no (제출pk) — Primary key — NOT NULL
  • approval_name (제출상태)

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
  • approval_no (제출pk) — Foreign key → Barom_approval_status.approval_no — NOT NULL
  • case_date (소장저장일)
  • case_refuse_reason (소장반려사유)

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

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
  • trial_result_status (판결/결정/명령 여부)
  • trial_result_order (주문)
  • trial_result_reason (이유)
  • trial_result_date (결과 발생 날짜)

Barom_trial_document (재판 PDF)

  • trial_document_no (재판 PDF pk) — Primary key — NOT NULL
  • trial_no (재판pk) — Foreign key → Barom_trial.trial_no — NOT NULL
  • trial_document_url (재판 url)

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 (관리자카테고리이름)