mydata-demo

Tables (26)

acc_token (접근토큰)

  • org_code (기관코드) — varchar(7) — Foreign key → mydata_operators.org_code — NOT NULL
  • ci (고객번호) — varchar — Foreign key → mydata_user.ci — NOT NULL
  • grant_type (권한부여방식) — varchar — NOT NULL
  • code (인가코드) — varchar — NOT NULL
  • client_id (클라이언트ID) — varchar(50) — NOT NULL
  • client_secret (클라이언트Secret) — varchar(50) — NOT NULL
  • redirect_url (Calback URL) — varchar — NOT NULL
  • token_type (토큰타입) — varchar — NOT NULL
  • access_token (접근토큰) — varchar — NOT NULL
  • expires_in (접근토큰유효기간) — int4 — NOT NULL
  • refresh_token (접근토근갱신을위한토큰) — varchar — NOT NULL
  • reg_date (만료일자) — date — NOT NULL

api_code (API구분코드)

  • api_type (API구분코드) — varchar — Primary key — NOT NULL
  • name (API_URL명) — varchar — NOT NULL
  • url (API_URL) — varchar — NOT NULL

apis (API관리)

  • api_type (API구분코드) — varchar(4) — Foreign key → api_code.api_type — NOT NULL
  • version (API버전) — varchar(10) — NOT NULL
  • min_version (호환가능최소버전) — varchar(10)
  • api_url (API_URL(full)) — varchar(50) — NOT NULL
  • reg_date — date — NOT NULL

auth_code (인가코드관리)

  • org_code (기관코드) — varchar(7) — NOT NULL
  • response_type (인가타입) — varchar — NOT NULL
  • client_id (클라이언트ID) — varchar(50) — NOT NULL
  • redirect_url (Callback_URL) — varchar — NOT NULL
  • state (상태값) — varchar(40) — NOT NULL
  • code (인가코드) — varchar — NOT NULL

consents (전송요구내역관리)

  • org_code (기관코드) — varchar — NOT NULL
  • is_scheduled (정기적전송여부) — bool — NOT NULL
  • cycle — int4
  • end_date — date — NOT NULL
  • purpose — varchar — NOT NULL
  • period — int4 — NOT NULL

insu_type_code (보험종류코드)

  • code (보험종류코드) — varchar — NOT NULL
  • name (보험종류) — varchar — NOT NULL

insurances (보험목록조회)

  • ci (고객번호) — varchar — Foreign key → mydata_user.ci — NOT NULL
  • insu_num — varchar(20) — NOT NULL
  • is_consent (전송요구여부) — bool — NOT NULL
  • prod_name (상품명) — varchar — NOT NULL
  • insu_type (보험종류구분코드) — varchar(2) — NOT NULL
  • insu_status (계약상태코드) — varchar(2) — NOT NULL

insurances_basic (보험기본정보조회)

  • ci (고객번호) — varchar — NOT NULL
  • insu_num (보험증권번호) — varchar(20) — NOT NULL
  • is_renewable (갱신형/비갱신형) — bool — NOT NULL
  • issue_date (계약체결일) — date — NOT NULL
  • exp_date (만기일자) — date — NOT NULL
  • face_amt (보험가입금액) — float8 — NOT NULL
  • currency_code (통화코드) — varchar(3) — NOT NULL
  • is_variable (변액보험해당여부) — bool — NOT NULL
  • is_universal (유니버셜해당여부) — bool — NOT NULL
  • pension_rcv_start_date (연금개시일) — date
  • pension_rcv_cycle (연금수령주기코드) — varchar(2)
  • is_loanable (대출가능여부) — bool — NOT NULL

insurances_basic_list (보험수령자목록)

  • insu_num (보험증권번호) — varchar(20) — NOT NULL
  • insured_no (피보험자순번) — int4 — NOT NULL
  • insured_name (피보험자명) — varchar(20) — NOT NULL

insurances_contracts (보험특약정보)

  • insu_num (보험증권번호) — varchar(20) — NOT NULL
  • insured_no (피보험자순번) — int4 — NOT NULL
  • contract_name (특약명) — varchar(200) — NOT NULL
  • ontract_status (특약의상태코드) — int4 — NOT NULL
  • contract_exp_date (특약만기일자) — date — NOT NULL
  • contract_face_amt (특약가입금액) — float8 — NOT NULL
  • currency_code (통화코드) — varchar(3) — NOT NULL
  • is_required (특약의유형여부) — bool — NOT NULL

insurances_payment (보험납입정보)

  • insu_num (보험증권번호) — varchar(20) — NOT NULL
  • pay_due (납입기간코드) — varchar(2) — NOT NULL
  • pay_cycle (납입주기코드) — varchar(2) — NOT NULL
  • pay_cnt (총납입횟수) — int4 — NOT NULL
  • pay_org_code (납입기관코드) — varchar(7) — NOT NULL
  • pay_date (납입일자) — int4 — NOT NULL
  • pay_end_date (납입종료일자) — date — NOT NULL
  • pay_amt (납입보험료) — float8 — NOT NULL
  • currency_code (납입통화코드) — varchar(3) — NOT NULL
  • is_auto_pay (자동납입여부) — bool — NOT NULL

insurances_transactions (보험거래내역)

  • insu_num — varchar(20) — NOT NULL
  • trans_date (납입일자) — date — NOT NULL
  • trans_applied_mon (납입내역유효년월) — date — NOT NULL
  • trans_no (납입횟차) — int4 — NOT NULL
  • paid_amt (실납입보험료) — float8 — NOT NULL
  • currency_code (납입통화코드) — varchar(3) — NOT NULL
  • pay_method (수금방법코드) — varchar(2) — NOT NULL

mydata_base (MYDATA기본정보)

  • name (자료명) — varchar — NOT NULL
  • data (자료내용) — varchar — NOT NULL

mydata_logs (MYDATA조회내역저장)

  • reg_date (조회일자) — date — NOT NULL
  • state (조회상태) — bool — NOT NULL
  • user (사용자) — varchar
  • provider (제공자) — varchar
  • operators (사업자) — varchar
  • input (입력값) — varchar
  • output (결과전송값) — varchar
  • client_id (클라이언트ID) — varchar

mydata_operators (사업자)

  • org_code (기관코드) — varchar — Primary key — NOT NULL
  • name (사업자명) — varchar — NOT NULL

mydata_provider (제공자코드)

  • code (제공자코드) — varchar — NOT NULL
  • name (제공자기관명) — varchar — NOT NULL

mydata_stat_base (통계코드)

  • code (통계시간대역코드) — varchar — NOT NULL
  • start_time (통계대역시작시간) — time — NOT NULL
  • end_time (통계대역마감시간) — time — NOT NULL

mydata_user (사용자)

  • ci (고객번호) — varchar — Primary key — NOT NULL
  • acc_token (접근토큰) — varchar(20) — NOT NULL
  • id (ID) — varchar(20) — NOT NULL
  • password (비밀번호) — varchar(20) — NOT NULL
  • state (사용여부) — varchar(5) — NOT NULL

mydata_user_agree (동의내역)

  • ci (고객번호) — varchar — Foreign key → mydata_user.ci — NOT NULL
  • reg_date (동의일자) — date
  • token (발급토큰) — varchar
  • agreement (동의내역) — varchar

mydata_user_map (사용자자산선택내용)

  • ci (사용자) — varchar
  • reg_date (저장일자) — date
  • asset_type (자산구분) — varchar
  • asset_num (자산번호) — varchar
  • apis (사용선택여부) — varchar
  • use_yn (사용여부) — bool — NOT NULL

product_code (상품분류코드)

  • code (상품유형) — varchar(4) — NOT NULL
  • sub_code (상세구분코드) — varchar
  • name (상품명) — varchar(100) — NOT NULL

product_type_code (상품종류코드)

  • code (상품코드) — varchar — NOT NULL
  • code2 (상품종류코드) — varchar
  • name (상품명) — varchar — NOT NULL

repaymode_code (상환방식코드)

  • code (상환방식코드) — varchar — NOT NULL
  • name (상환방식) — varchar(100) — NOT NULL

rsp_code (조회결과오류코드)

  • http_code (HTTP응답코드) — varchar — NOT NULL
  • rsp_code (세부응답코드) — varchar — NOT NULL
  • rsp_msg (상세설명) — varchar — NOT NULL

trans_type_code (전자금융거래유형코드)

  • code (거래유형코드) — varchar — NOT NULL
  • name (거래방법) — varchar — NOT NULL

transaction_code (거래종류코드)

  • code (거래종류코드) — varchar — NOT NULL
  • name (거래명) — varchar — NOT NULL