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