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