220318
Tables (28)
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
- 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
- caseBasicInfo_claim_method (청구구분)
- caseBasicInfo__price_method (소가구분)
- caseBasicInfo__price (소가)
Barom_CaseConfirmed_ProofFile (입증 서류)
- file_no (파일pk) — Primary key — NOT NULL
- Case_Confirmed_no (승인배당사건pk) — Foreign key → Barom_Case_Confirmed.Case_Confirmed_no — NOT NULL
- file_name (파일이름(경로))
- file_original_name (파일원본이름)
- file_extension (파일확장자)
- file_date (파일등록일)
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
- concerned_related (작성자의당사자와의관계)
- cause_answer_content (청구취지답변 내용)
- purpose_answer_content (청구원인답변 내용)
- defense_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_DocumentPay (결제정보)
- documentpay_no (결제pk) — Primary key — NOT NULL
- case_no (소장pk) — Foreign key → Barom_case.case_no — NOT NULL
- pay_name (결제시 상품이름)
- pay_user_id (결제 회원 아이디)
- pay_method (결제방식)
- pay_price (결제금액)
- pg_token (결제토큰)
- pay_date (결제일자)
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_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
- case_date (소장저장일)
- case_refuse_reason (Field)
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_no (사건pk) — Foreign key → Barom_case.case_no — NOT NULL
- Case_Confirmed_no (승인배당사건pk) — Foreign key → Barom_Case_Confirmed.Case_Confirmed_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 → Barom_Case_Confirmed.caseconfirmed_status_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 (관리자카테고리이름)