금융상품 관리 데이터셋
테이블 (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)