test

Tables (25)

badge

  • badge_id — INT — Primary key — NOT NULL
  • badge_name — VARCHAR(20) — NOT NULL
  • badge_image — VARCHAR(100) — NOT NULL
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

card_parsed_benefit

  • parsed_benefit_id — INT — Primary key — NOT NULL — 파싱된 혜택 ID
  • card_id2 — INT — NOT NULL — 카드 ID (FK)
  • title — VARCHAR(255) — NOT NULL — 혜택 원본 제목
  • category — VARCHAR(100) — NOT NULL — 추론된 혜택 카테고리 (교통, 외식 등)
  • benefit_type — VARCHAR(50) — NOT NULL — 혜택 유형 (할인, 적립, 캐시백)
  • value — DECIMAL(10, 2) — NOT NULL — 혜택 값 (퍼센트 또는 금액)
  • condition_text — TEXT — 혜택 조건 (콤마로 구분된 텍스트)
  • max_benefit_monthly — INT — 월 최대 혜택 금액 (무제한 시 NULL)
  • min_spend_per_transaction — INT — 건당 최소 결제 금액
  • pre_month_money_specific — INT — 해당 혜택 전월 실적 (NULL 시 카드 전체 전월 실적 따름)
  • description — TEXT — 혜택 상세 설명 (HTML 디코딩 텍스트)
  • created_at — TIMESTAMP — 생성일시
  • updated_at — TIMESTAMP — 최종 수정일시

card_search_benefit

  • search_benefit_id — INT — Primary key — NOT NULL — 검색 혜택 ID
  • card_id2 — INT — NOT NULL — 카드 ID (카드고릴라 idx)
  • benefit_text — TEXT — NOT NULL — 혜택 전체 텍스트 (옵션 포함)
  • created_at — TIMESTAMP — 생성일시
  • updated_at — TIMESTAMP — 최종 수정일시

cards_products

  • card_id — INT — Primary key — NOT NULL — 카드 ID (카드고릴라 idx)
  • name — VARCHAR(255) — NOT NULL — 카드 이름
  • type — VARCHAR(50) — NOT NULL — 카드 종류 (신용, 체크, unknown)
  • is_available — TINYINT(1) — NOT NULL — 발급 가능 여부
  • issuer_id — INT — NOT NULL — 발급사 ID (FK)
  • annual_fee — VARCHAR(255) — 연회비 정보
  • pre_month_money — INT — 전월 실적 금액 (원)
  • online_only — TINYINT(1) — 온라인 전용 카드 여부
  • card_image_url — VARCHAR(500) — 카드 이미지 URL
  • request_pc_url — VARCHAR(500) — PC 신청 링크
  • request_mobile_url — VARCHAR(500) — 모바일 신청 링크
  • annual_fee_detail — TEXT — 연회비 상세 설명 (HTML 디코딩 텍스트)
  • corp_pr_container — TEXT — 카드사 PR 컨테이너 (HTML 디코딩 텍스트)
  • corp_pr_detail — TEXT — 카드사 PR 상세 (원시 HTML)
  • corp_tips — TEXT — 고릴라 TIP (HTML 디코딩 텍스트)
  • created_at — TIMESTAMP — 생성일시
  • updated_at — TIMESTAMP — 최종 수정일시
  • persona_id — BIGINT — NOT NULL

deposit_option

  • deposit_option_id — BIGINT — Primary key — NOT NULL
  • intr_rate_type — VARCHAR(20) — S/M
  • intr_rate_type_nm — VARCHAR(50) — 단리/복리
  • save_trm — VARCHAR(10) — 6개월, 12개월 등등
  • intr_rate — VARCHAR(20)
  • intr_rate2 — VARCHAR(20)
  • deposit_product_id — BIGINT — NOT NULL
  • fin_prdt_cd — VARCHAR(50) — NOT NULL
  • fin_id — BIGINT — NOT NULL

deposit_product

  • deposit_product_id — BIGINT — Primary key — NOT NULL
  • dcls_month — VARCHAR(6) — YYYYMM
  • kor_co_nm — VARCHAR(100) — NOT NULL
  • fin_prdt_nm — VARCHAR(100) — NOT NULL
  • join_way — VARCHAR(200) — 인터넷, 영업점
  • mtrt_int — VARCHAR(500)
  • spcl_cnd — VARCHAR(500)
  • join_deny — VARCHAR(10) — 1이면 가입 불가
  • join_member — VARCHAR(200) — 개인/법인
  • etc_note — VARCHAR(500)
  • max_limit — VARCHAR(100)
  • dcls_strt_day — VARCHAR(8) — NOT NULL — YYYYMMDD
  • dcls_end_day — VARCHAR(8) — NOT NULL — YYYYMMDD
  • fin_co_subm_day — VARCHAR(20)
  • product_type — VARCHAR(1) — NOT NULL — 예금 : 1
  • persona_id — BIGINT — NOT NULL
  • fin_co_no — VARCHAR(20) — NOT NULL
  • fin_prdt_cd — VARCHAR(50) — NOT NULL
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL
  • fin_id — BIGINT — NOT NULL

financial_companies

  • fin_id — BIGINT — Primary key — NOT NULL
  • fin_co_no — VARCHAR(20) — NOT NULL
  • dcls_month — VARCHAR(6) — NOT NULL — YYYYMM
  • kor_co_nm — VARCHAR(100) — NOT NULL
  • dcls_chrg_man — VARCHAR(100)
  • homp_url — VARCHAR(255)
  • cal_tel — VARCHAR(50)
  • area_cd — VARCHAR(10)
  • area_nm — VARCHAR(50)
  • exis_yn — CHAR(1)
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

information_board

  • post_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • category — ENUM('교육 주제', '교육 대상') — NOT NULL
  • media_url — VARCHAR(500)
  • created_by_admin — VARCHAR(50)
  • cor_name — VARCHAR(50) — NOT NULL
  • last_modified_time — DATETIME — NOT NULL
  • created_time — DATETIME — NOT NULL

mydata_card_holdings

  • holding_id — BIGINT — Primary key — NOT NULL
  • card_id — INT — NOT NULL — 카드 ID (카드고릴라 idx)
  • fin_id — BIGINT — NOT NULL
  • discountinued — BOOLEAN — NOT NULL
  • card_name — VARCHAR(255) — NOT NULL
  • res_card_no — VARCHAR(50) — NOT NULL — 123-***-456789
  • res_sleep_yn — CHAR(1) — Y/N
  • res_card_type — VARCHAR(100) — 체크, 신용
  • res_traffic_yn — VARCHAR(30)
  • res_image_link — VARCHAR(512)
  • res_issue_date — VARCHAR(8) — YYYYMMDD
  • res_valid_period — VARCHAR(10) — YYYYMM
  • res_state — VARCHAR(50) — 정상, 해지, 정지
  • created_time — DATETIME — NOT NULL — 초 단위 포함
  • last_modified_time — DATETIME — NOT NULL
  • user_id — BIGINT — NOT NULL

mydata_card_transactions

  • transaction_id — BIGINT — Primary key — NOT NULL
  • fin_id — BIGINT — NOT NULL
  • card_id2 — INT — NOT NULL — 카드 ID (카드고릴라 idx)
  • user_id — BIGINT — NOT NULL
  • card_name — VARCHAR(255) — NOT NULL
  • res_used_date — VARCHAR(8) — NOT NULL — YYYYMMDD
  • res_used_time — VARCHAR(6) — NOT NULL — HHMMSS
  • res_card_no — VARCHAR(50) — NOT NULL — 123-****-456789
  • res_card_no1 — VARCHAR(50) — 추가 정보
  • res_card_name — VARCHAR(100) — NOT NULL
  • res_member_store_name — VARCHAR(200) — NOT NULL
  • res_used_amount — BIGINT — NOT NULL
  • res_payment_type — VARCHAR(2) — NOT NULL — 일시불, 할부
  • res_installment_month — VARCHAR(10)
  • res_approval_no — VARCHAR(30) — NOT NULL
  • res_payment_due_date — VARCHAR(8) — YYYYMMDD
  • res_home_foreign_type — VARCHAR(2) — NOT NULL
  • res_member_store_corp_no — VARCHAR(30)
  • res_member_store_type — VARCHAR(30)
  • res_member_store_tel_no — VARCHAR(30)
  • res_member_store_addr — VARCHAR(255)
  • res_member_store_no — VARCHAR(50)
  • res_cancel_yn — VARCHAR(2) — NOT NULL
  • res_cancel_amount — BIGINT
  • res_vat — BIGINT
  • res_cash_back — BIGINT
  • res_krw_amt — BIGINT
  • comm_start_date — VARCHAR(8) — NOT NULL
  • comm_end_date — VARCHAR(8) — NOT NULL
  • res_account_currency — VARCHAR(10) — NOT NULL
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

mydata_saving_accounts

  • account_id — BIGINT — Primary key — NOT NULL
  • res_account — VARCHAR(50) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • fin_id — BIGINT — NOT NULL
  • res_account_status — VARCHAR(20) — NOT NULL
  • res_account_display — VARCHAR(50) — NOT NULL — 123-****-456789
  • res_account_name — VARCHAR(100) — NOT NULL
  • res_account_nickname — VARCHAR(100)
  • res_account_holder — VARCHAR(100) — NOT NULL
  • res_final_round_no — VARCHAR(10)
  • res_account_start_date — VARCHAR(8) — NOT NULL — YYYYMMDD
  • res_account_end_date — VARCHAR(8) — YYYYMMDD
  • res_account_balance — BIGINT — NOT NULL
  • res_monthly_payment — BIGINT
  • res_valid_period — VARCHAR(10) — NOT NULL
  • res_type — VARCHAR(50) — NOT NULL
  • res_management_branch — VARCHAR(100) — NOT NULL
  • res_rate — VARCHAR(20)
  • res_contract_amount — BIGINT — 총 적금 목표
  • res_payment_methods — VARCHAR(100) — ex) 자동이체
  • res_last_tran_date — VARCHAR(8) — NOT NULL
  • comm_start_date — VARCHAR(8) — NOT NULL
  • comm_end_date — VARCHAR(8) — NOT NULL
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

mydata_user_account

  • account_id — BIGINT — Primary key — NOT NULL
  • res_account — VARCHAR(50) — NOT NULL
  • user_id — BIGINT — NOT NULL
  • fin_id — BIGINT — NOT NULL
  • res_account_balance — VARCHAR(30) — NOT NULL
  • res_withdrawal_amt — VARCHAR(30)
  • res_account_nickname — VARCHAR(100)
  • res_account_start_date — VARCHAR(8) — NOT NULL — YYYYMMDD
  • res_last_tran_date — VARCHAR(8) — NOT NULL — YYYYMMDD
  • res_loan_limit_amt — VARCHAR(30)
  • res_account_name — VARCHAR(100) — NOT NULL
  • res_account_holder — VARCHAR(100) — NOT NULL
  • res_management_branch — VARCHAR(100) — NOT NULL
  • res_interest_rate — VARCHAR(30)
  • res_account_display — VARCHAR(100) — NOT NULL
  • res_loan_end_date — VARCHAR(8) — YYYYMMDD
  • res_account_status — VARCHAR(20) — NOT NULL
  • comm_start_date — VARCHAR(8) — NOT NULL — YYYYMMDD
  • comm_end_date — VARCHAR(8) — NOT NULL — YYYYMMDD
  • res_account_tr_date — VARCHAR(8) — NOT NULL — YYYYMMDD
  • res_account_tr_time — VARCHAR(6) — NOT NULL — HHMMSS
  • res_account_out — VARCHAR(30) — NOT NULL
  • res_account_in — VARCHAR(30) — NOT NULL
  • res_after_tran_balance — VARCHAR(30) — NOT NULL
  • res_account_desc1 — VARCHAR(200)
  • res_account_desc2 — VARCHAR(200)
  • res_account_desc3 — VARCHAR(200)
  • res_account_desc4 — VARCHAR(200)
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

persona_answer_option

  • answer_option_id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — NOT NULL
  • answer_option_summary — VARCHAR(255) — NOT NULL
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

persona_questions

  • question_id — BIGINT — Primary key — NOT NULL
  • question_text — VARCHAR(255) — NOT NULL
  • question_answer — VARCHAR(255)
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

persona_recommend_products

  • id — BIGINT — Primary key — NOT NULL
  • persona_type_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • priority_rank — TINYINT
  • recommended_at — DATETIME(3)

persona_types

  • persona_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • persona_image — VARCHAR(255) — NOT NULL
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

product_alerts

  • alert_id — BIGINT — Primary key — NOT NULL
  • product_type — ENUM('1', '2', '3') — NOT NULL — 1: 예금, 2: 적금, 3: 카드
  • product_id — BIGINT — NOT NULL
  • alert_sent_at — DATETIME
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

quiz

  • quiz_id — BIGINT — Primary key — NOT NULL
  • quiz_text — VARCHAR(255) — NOT NULL
  • quiz_answer — BOOLEAN — NOT NULL
  • quiz_user_answer — BOOLEAN
  • user_id — BIGINT — NOT NULL
  • fin_id — BIGINT — NOT NULL

saving_option

  • saving_option_id — BIGINT — Primary key — NOT NULL
  • fin_co_no2 — VARCHAR(20) — NOT NULL
  • fin_id — BIGINT — NOT NULL
  • intr_rate_type — VARCHAR(20)
  • intr_rate_type_nm — VARCHAR(50) — 단리/복리
  • rsrv_type — VARCHAR(50)
  • rsrv_type_nm — VARCHAR(50) — 정액/자유
  • save_trm — VARCHAR(10)
  • intr_rate — VARCHAR(20)
  • intr_rate2 — VARCHAR(20)

saving_product

  • saving_product_id — BIGINT — Primary key — NOT NULL
  • fin_co_no2 — VARCHAR(20) — NOT NULL
  • fin_id — BIGINT — NOT NULL
  • dcls_month — VARCHAR(6) — YYYYMM
  • kor_co_nm — VARCHAR(100)
  • fin_prdt_nm — VARCHAR(100)
  • join_way — VARCHAR(200)
  • mtrt_int — VARCHAR(500)
  • spcl_cnd — VARCHAR(500)
  • join_deny — VARCHAR(10) — 1 : 제한됨
  • join_member — VARCHAR(200)
  • etc_note — VARCHAR(500)
  • max_limit — VARCHAR(100)
  • dcls_strt_day — VARCHAR(8) — YYYYMMDD
  • dcls_end_day — VARCHAR(8) — YYYYMMDD
  • fin_co_subm_day — VARCHAR(20)
  • product_type — VARCHAR(1) — NOT NULL — 2 : 적금
  • persona_id — BIGINT — NOT NULL
  • fin_prdt_cd — VARCHAR(50)
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL

user_answers

  • answer_id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • fin_id — BIGINT — NOT NULL
  • answer_value — VARCHAR(3)

user_badge

  • user_badge_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • badge_id — INT — NOT NULL
  • fin_id — BIGINT — NOT NULL
  • granted_time — DATETIME(3) — NOT NULL

user_favorites

  • favorite_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_time — DATETIME — NOT NULL
  • last_modified_time — DATETIME — NOT NULL
  • deposit_product_id — BIGINT — NOT NULL
  • saving_product_id — BIGINT — NOT NULL
  • fin_co_no2 — VARCHAR(20) — NOT NULL
  • fin_id — BIGINT — NOT NULL
  • card_id2 — INT — NOT NULL — 카드 ID (카드고릴라 idx)

user_likes

  • like_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • saving_product_id — BIGINT — NOT NULL
  • fin_co_no2 — VARCHAR(20) — NOT NULL
  • deposit_product_id — BIGINT — NOT NULL
  • fin_id — BIGINT — NOT NULL
  • card_id2 — INT — NOT NULL — 카드 ID (카드고릴라 idx)

users

  • user_id — BIGINT — Primary key — NOT NULL
  • social_provider — VARCHAR(50) — ex) 카카오, 구글
  • social_id — VARCHAR(100)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — 소셜 로그인 사용 시 NULL 가능
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image_url — VARCHAR(512)
  • created_time — DATETIME — NOT NULL
  • last_modified_time — TIMESTAMP — NOT NULL
  • is_social_login — BOOLEAN — NOT NULL
  • persona_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • exp — INT — NOT NULL — default = 0
  • fin_id — BIGINT — NOT NULL