금융상품 관리 데이터셋

테이블 (19)

Copy Of entity (CopyOf파트너)

  • entity_id (Key) — integer(12) — 기본 키 — NOT NULL
  • entity_code (Field) — varchar(3)
  • entity_name (Field3) — varchar(100)
  • entity_code_coocon (Field4) — varchar(3)
  • entity_role_code (Field5) — varchar(20)
  • type (Field2) — varchar(50)
  • registration_number (Field6) — varchar(10)
  • corporation_number (Field7) — varchar(13)
  • status (Field8) — varchar(20)
  • created_at (Field10) — timestamp
  • updated_at (Field11) — timestamp
  • deleted_at (Field12) — timestamp

address (주소)

  • address_id (Key2) — 기본 키 — NOT NULL
  • entity_id (Key) — integer(12) — 외래 키 → entity.entity_id — NOT NULL
  • nation (Field)
  • sido_code (Field2)
  • sido (Field3)
  • sigungu_code (Field4)
  • sigungu (Field5)
  • dong_code (Field6)
  • dong (Field7)
  • postcode (Field8)
  • status (Field9)
  • created_at (Field10)
  • updated_at (Field11)
  • deleted_at (Field12)

bluebird_web (블루버드 로그)

  • event_id (Key) — 기본 키 — NOT NULL
  • event_name (Field)
  • creative_id (Key2) — 외래 키 → creatives.creative_id — NOT NULL
  • ..... (Field3)
  • created_at (Field4)
  • updated_at (Field5)
  • deleted_at (Field6)

cashnote_app (캐시노트 앱 로그)

  • event_id (Key) — 기본 키 — NOT NULL
  • event_name (Field)
  • creative_id (Key2) — 외래 키 → creatives.creative_id — NOT NULL
  • ..... (Field3)
  • created_at (Field4)
  • updated_at (Field5)
  • deleted_at (Field6)

cashnote_web (캐시노트 웹 로그)

  • event_id (Key) — 기본 키 — NOT NULL
  • event_name (Field)
  • creative_id (Key2) — 외래 키 → creatives.creative_id — NOT NULL
  • ..... (Field3)
  • created_at (Field4)
  • updated_at (Field5)
  • deleted_at (Field6)

contact (연락처)

  • contact_id (Key) — 기본 키 — NOT NULL
  • entity_id (Key2) — integer(12) — 외래 키 → entity.entity_id — NOT NULL
  • type (Field)
  • detaill (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

creative_templates (광고소재탬플릿)

  • creative_template_id (Key) — 기본 키 — NOT NULL
  • creative_template_name (Field)
  • creative_template_description (Field2)
  • finance_product_id (Key2) — integer — 외래 키 → finance_products.finance_product_id — NOT NULL
  • url (Field4)
  • .......... (Field8)
  • created_at (Field5)
  • updated_at (Field6)
  • deleted_at (Field7)

creatives (광고소재)

  • creative_id (Key) — 기본 키 — NOT NULL
  • creative_name (Field)
  • creative_description (Field2)
  • creative_template_id (Key2) — 외래 키 → creative_templates.creative_template_id — NOT NULL
  • ad_group_id (Field4)
  • .......... (Field8)
  • created_at (Field5)
  • updated_at (Field6)
  • deleted_at (Field7)

credit_sales (대출중개실적)

  • sales_id (Key) — 기본 키 — NOT NULL
  • finance_product_id (Key3) — integer — 외래 키 → finance_products.finance_product_id — NOT NULL
  • sales_amount (Field)
  • created_at (Field2)
  • updated_at (Field3)
  • deleted_at (Field4)

entity (파트너 개체)

  • entity_id (Key) — integer(12) — 기본 키 — NOT NULL
  • entity_code (Key2) — 외래 키 → ext_code_trans.int_code — NOT NULL
  • entity_code (Field) — varchar(3)
  • entity_name (Field3) — varchar(100)
  • type (Field2) — varchar(50)
  • registration_number (Field6) — varchar(10)
  • corporation_number (Field7) — varchar(13)
  • status (Field8) — varchar(20)
  • created_at (Field10) — timestamp
  • updated_at (Field11) — timestamp
  • deleted_at (Field12) — timestamp

ext_code_trans (외부코드변환)

  • int_code (Key2) — 기본 키 — NOT NULL
  • ext_code (Key22) — 외래 키 → loan_comparison_service.finance_product_code_coocon — NOT NULL
  • definition (Field)
  • created_at (Field2)
  • updated_at (Field3)
  • deleted_at (Field4)

finance_product_categories (금융상품 카테고리)

  • finance_product_category_id (Key) — integer — 기본 키 — NOT NULL
  • finance_product_category_code (Field) — varchar(3)
  • finance_product_category_name (Field2) — varchar(100)
  • entity_id (Key2) — integer(12) — 외래 키 → entity.entity_id — NOT NULL
  • status (Field4) — varchar(20)
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp
  • deleted_at (Field7) — timestamp

finance_products (금융상품)

  • finance_product_id (Key) — integer — 기본 키 — NOT NULL
  • finance_product_code (Key23) — 외래 키 → ext_code_trans.int_code — NOT NULL
  • finance_product_name (Field5) — varchar
  • finance_product_code_coocon (Key22) — 외래 키 → loan_comparison_service.finance_product_code_coocon — NOT NULL
  • finance_product_category_id (Key2) — integer(12) — 외래 키 → finance_product_categories.finance_product_category_id — NOT NULL
  • min_rate (Field10) — real
  • max_rate (Field11) — real
  • max_amount (Field12) — integer
  • min_score_nice (Field13) — integer
  • min_score_kcb (Field14) — integer
  • min_score_kcs (Field15) — integer
  • status (Field16) — varchar
  • url (Field17) — varchar
  • created_at (Field18) — timestamp
  • updated_at (Field19) — timestamp
  • deleted_at (Field2) — timestamp

loan_comparison_service (금리비교서비스)

  • id (Key) — 기본 키 — NOT NULL
  • finance_product_code_coocon (Key2) — 기본 키 — NOT NULL
  • API_channel (Field2)
  • result (Field3)
  • status (Field4)
  • error_detail (Field5)
  • max_rate (Field6)
  • min_rate (Field7)
  • max_amount (Field8)
  • ........... (Field9)
  • created_at (Field10)
  • updated_at (Field11)
  • deleted_at (Field12)

relation (관계)

  • subjective_actor (Key3) — integer(12) — 외래 키 → entity.entity_id — NOT NULL
  • objective_actor (Key4) — integer(12) — 외래 키 → Copy Of entity.entity_id — NOT NULL
  • relation_type (Field2)
  • created_at (Field)
  • updated_at (Field3)
  • deleted_at (Field4)

role (역할)

  • entity_role_id (Key) — integer(12) — 기본 키 — NOT NULL
  • entity_id (Key2) — integer(12) — 외래 키 → entity.entity_id — NOT NULL
  • entity_role_code (Field) — varchar(100)
  • entity_role_name (Field2) — varchar(100)
  • status (Field3) — varchar(20)
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp
  • deleted_at (Field6) — timestamp

safety_package_detail (안심패키지상품선택)

  • id (Key) — 기본 키 — NOT NULL
  • subscription_id (Key3) — 외래 키 → safety_package_subscription.subscription_id — NOT NULL
  • insurance_id (Key2) — 외래 키 → safety_package_insurance.insurance_id — NOT NULL
  • status (Field7)
  • ...... (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

safety_package_insurance (안심패키지 상품목록)

  • insurance_id (Key) — 기본 키 — NOT NULL
  • insurance_name (Field6)
  • finance_product_id (Key2) — integer — 외래 키 → finance_products.finance_product_id — NOT NULL
  • ...... (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)

safety_package_subscription (안심패키지 구독)

  • subscription_id (Key) — 기본 키 — NOT NULL
  • business_id (Field)
  • status (Field6)
  • ...... (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • deleted_at (Field5)