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