Credit_BANKMALL

Tables (9)

caution (유의사항)

  • id (고유아이디) — bigserial — Primary key — NOT NULL
  • title (제목) — varchar
  • content (내용) — varchar
  • content_with_out_markup (내용(텍스트만)) — clob
  • is_active (활성화 여부) — boolean
  • write_date (작성일자) — date
  • active_date (시행일자) — date
  • created_by (작성자) — account
  • created_at (작성일) — date
  • updated_by (수정자) — date
  • updated_on (수정일) — account

credit_loan_bank (제휴금융사)

  • id (고유아이디) — bigserial — Primary key — NOT NULL
  • created_at (생성일자) — timestamp
  • updated_on (수정일자) — timestamp
  • code (금융사 코드) — varchar(255)
  • is_active (활성화 여부) — boolean
  • name (금융사 이름) — varchar(255)
  • thumbnail (썸네일) — bigint
  • thumbnail_replace (썸네일 없는경우 표시) — varchar(255)
  • type (구분(1금융, 2금융 등)) — varchar(255)
  • fis_cd (금융기관 코드) — varchar(255)
  • fis_dscd (금융기관 구분 코드) — varchar(255)

credit_loan_call_log (쿠콘API 콜 로그)

  • id (고유아이디(날짜_시퀀스번호)) — varchar(255) — Primary key — NOT NULL
  • created_at (생성일자) — timestamp
  • type (타입(한도조회 , 대출신청 , 대출신청결과)) — varchar(255)
  • is_ok (정상 호출 여부) — boolean
  • data (호출 후 반환 데이터 (json)) — clob(text)

credit_loan_compare (대출비교시 넣은 정보)

  • id (고유아이디) — bigserial — Primary key — NOT NULL
  • created_at (생성일자) — timestamp
  • updated_on (수정일자) — timestamp
  • annual_income (연봉) — bigint
  • car_num (자동차 번호) — varchar(255)
  • company_address (회사주소) — varchar(255)
  • company_name (회사명) — varchar(255)
  • company_num (사업자등록번호) — varchar(255)
  • employ_type (고용 형태) — integer
  • has_car (차량소유 유무) — boolean
  • has_housing_type (주거 소유형태) — integer
  • housing_type (주거 형태(아파트,오피스텔등)) — integer
  • housing_address (주택 주소) — varchar(255)
  • housing_size (주택 크기(평형)) — double
  • job_type (직업 구분) — integer
  • medical_insurance_type (의료보험 구분) — integer
  • open_date (입사일(창업일)) — timestamp
  • sector_type (업종구분) — integer
  • status (작성 진행상황) — varchar(255)
  • created_by_id (작성자(audit column)) — bigint
  • request_by_id (요청자) — bigint
  • request_at (요청일자) — timestamp
  • lo_reqt_no (대출비교 신청 List (One to many)) — varchar(255) — Foreign key → credit_loan_request_product.lo_reqt_no — NOT NULL

credit_loan_product (신용대출 상품)

  • id (고유아이디) — bigserial — Primary key
  • bank_id (금융사) — bigserial — Foreign key → credit_loan_bank.id — NOT NULL
  • lo_prd_cd (대출상품코드) — varchar(255)
  • lo_prd_nm (대출상품명) — varchar(255)
  • created_at (생성일자) — timestamp
  • updated_on (수정일자) — timestamp
  • rt_tpbs_ds_cd (금리종류 구분코드) — varchar(255)
  • b_url (브릿지 URL) — varchar(255)
  • isproduct_character (상품 특징 입력 사용여부) — boolean
  • is_active (활성화여부) — boolean
  • is_credit_loan_product_detail (상품 상세정보 사용여부) — boolean
  • is_top_detail (상품우측상단 사용여부) — boolean
  • is_under_detail (자세히보기 하단 사용 여부) — boolean
  • lo_tem (대출기간개월수) — bigint
  • m_rpay_fe_rt (중도상환수수료율) — double
  • product_character (상품 특징 입력(비대면, 직장인, 3시간입금 등..)) — text
  • r_pay_mthd_ds_cd (상환방법 구분코드) — varchar(255)
  • top_detail (상품우측상단(최근 14일간 000건 진행 등..)) — varchar(255)
  • under_detail (자세히보기 하단 (신청후 심사완료까지 ..... )) — varchar(255)
  • created_by_id (작성자) — bigint
  • updated_by_id (수정자) — bigint

credit_loan_product_detail (대출상품 디테일정보)

  • id (고유아이디) — bigserial — Primary key
  • credit_loan_product_id (대출상품) — bigserial — Foreign key → credit_loan_product.id
  • created_at (생성일자) — timestamp
  • updated_on (수정일자) — timestamp
  • content (내용) — varchar(255)
  • is_active (활성여부) — boolean
  • name (제목) — varchar(255)
  • num (순서) — bigint
  • created_by_id (작성자) — bigint
  • updated_by_id (수정자) — bigint

credit_loan_rate (대출비교 상품 신청에 대한 결과)

  • lo_aplc_mm_no (대출신청 번호) — varchar(255) — Primary key — NOT NULL
  • credit_loan_compare_product_id (대출비교결과 상품) — varchar(255) — Foreign key → credit_loan_request_product.lo_reqt_no — NOT NULL
  • alnc_is_mn_no (핀테크기관 관리번호) — varchar(255)
  • ap_rt (적용이율(가산금리)) — double
  • aply_dt (신청일자) — timestamp
  • bs_rt (기준금리) — double
  • created_at (생성일자) — timestamp
  • lo_ct_dt (대출약정일자(대출승인일자)) — timestamp
  • lo_ex_dt (대출실행일자) — timestamp
  • lonat_rsn (부결사유) — varchar(255)
  • lo_prd_cd (대출상품코드) — varchar(255)
  • lo_req_amt (대출금액) — bigint
  • lo_rsprpn (대출담당자 연락처) — varchar(255)
  • lo_tem (대출기간개월수) — bigint
  • lt_lo_lm_amt (최종대출한도금액) — bigint
  • lt_lo_rt (최종대출금리) — double
  • m_rpay_fe_rt (중도상환수수료율) — double
  • prnl_lm_amt (우대한도) — bigint
  • prnl_rsn (우대사유) — varchar(255)
  • prnl_rt (우대금리) — double
  • prnlyn (우대여부) — varchar(255)
  • rpay_mthd_ds_cd (상환방법 구분코드) — varchar(255)
  • rst_st_cd (결과상태코드) — varchar(255)
  • rt_tpbs_ds_cd (금리종류 구분코드) — varchar(255)
  • status (진행 상태) — varchar(255)
  • request_by_id (요청자) — bigint

credit_loan_request_product (신용대출 비교 결과 리스트)

  • lo_reqt_no (대출비교신청 번호) — varchar(255) — Primary key — NOT NULL
  • bank_id (금융사 ID) — bigserial — Foreign key → credit_loan_bank.id — NOT NULL
  • credit_loan_compare_id (대출비교 상품) — bigserial — Foreign key → credit_loan_compare.id — NOT NULL
  • rt_tpbs_ds_cd (금리종류 구분코드) — varchar(255)
  • ap_rt (적용이율(가산금리)) — double
  • aplc_ds (신청종류) — varchar(255)
  • bs_rt (기준금리) — double
  • chg_cycl (변동주기) — bigint
  • created_at (생성일자) — timestamp
  • edofrpayayn (만기일시 상환가능 여부) — varchar(255)
  • fin_en_mn_no (핀테크기관 관리번호) — varchar(255)
  • hd_dpayn (휴일입금 가능 여부) — varchar(255)
  • im_dpayn (즉시입금 가능 여부) — varchar(255)
  • inq_dt (조회일자) — timestamp
  • lo_cdvdt_tm (대출조건 유효일시) — timestamp
  • lonat_rsn (부결 사유) — varchar(255)
  • lo_prd_cd (대출상품코드) — varchar(255)
  • lo_prd_nm (대출상품명) — varchar(255)
  • lo_tem (대출기간개월수) — bigint
  • lt_lo_lm_amt (최종 대출 한도금액) — bigint
  • lt_lo_rt (최종 대출 금리) — double
  • lw_lm_rst (하한 한도결과) — varchar(255)
  • m_rpay_fe_exyn (중도상환수수료 면제여부) — varchar(255)
  • m_rpay_fe_rt (중도상환수수료율) — double
  • obrfd_ac_ds (타행대환계정여부) — varchar(255)
  • prnl_lm_amt (우대 한도) — bigint
  • prnl_rsn (우대사유) — varchar(255)
  • prnl_rt (우대금리) — double
  • prnlyn (우대여부) — varchar(255)
  • r_pay_mthd_ds_cd (상환방법 구분코드) — varchar(255)
  • rst_st_cd (결과상태 코드) — varchar(255)
  • credit_loan_compare_id (대출비교건) — bigint
  • brpg_url (대출신청시 브릿지 URL) — varchar(255)
  • cb_tel_no (콜백 전화번호) — varchar(255)
  • status (대출한도조회 진행상황) — varchar(255)
  • lo_req_amt (대출 신청 금액) — bigint
  • is_apply (대출 신청여부) — boolean
  • request_by_id (요청자) — bigint

review

  • id — bigserial — Primary key
  • created_at — timestamp
  • updated_on — timestamp
  • content_with_out_markup — text
  • contents — text
  • created_by_nm — varchar(255)
  • facebook_url — varchar(255)
  • instar_url — varchar(255)
  • is_best — boolean
  • kakao_url — varchar(255)
  • naver_url — varchar(255)
  • tags — varchar(255)
  • title — varchar(255)
  • created_by_id — bigint
  • loan_rate_id — bigint
  • manager_id — bigint
  • hit — bigint
  • ip — varchar(255)
  • write_date — timestamp
  • updated_by_id — bigint
  • is_delete — boolean
  • method — varchar(255)
  • origin — varchar(255)
  • remote_addr — varchar(255)
  • request_uri — varchar(255)
  • user_agent — varchar(255)
  • bank_id — bigint
  • limit_money — varchar(255)
  • is_event_delete — boolean
  • method_code — varchar(255)
  • pawn_code — varchar(255)
  • is_after — boolean
  • bcode_origin — varchar(255)