RA
Tables (11)
high_net_worth (고액자산가)
- id — bitint — Primary key — NOT NULL
- name (이름) — varchar(255)
- workflow_id (결재 ID) — bigint
- ra_history_id (ra 결재 기록 ID) — bigint
- batch_execution_date (정기배치 수행일) — date
- national_id (자연인 ID) — varchar(255)
- evaluated_price (평가금액(총자산, 원화환산금액)) — varchar(255)
- recent_total_asset (가장 최근 총자산) — varchar(255)
- is_continuous_detected (연속 판정 여부) — tinyint
- approval_status (결재 상태) — varchar(10)
- evaluation_yymm (검출 기준일 (3개월 평잔 검출 기준일)) — datetime
- recent_judged_at (이전 판정 일시) — datetime
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
nationality (국가)
- id — bigint — Primary key — NOT NULL
- code (코드) — varchar
- name (국적 이름) — varchar
- english_name (영문명) — varchar
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
nationality_category (항목)
- id — bigint — Primary key — NOT NULL
- group (그룹) — varchar
- name (이름) — varchar
- is_unconditional_high_risk (당연고 여부) — tinyint
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
nationality_category_content (국가별 항목)
- id — bigint — Primary key — NOT NULL
- nationality_id (국가 id) — bigint — Foreign key → nationality.id — NOT NULL
- category_id (카테고리 id) — bigint — Foreign key → nationality_category.id — NOT NULL
- code (코드) — varchar
- nationality_name (국가명) — varchar
- created_at (생성 일시) — datetime
- updated_at (수정 일시) — datetime
nationality_category_history (항목 이력)
- id — bigint — Primary key — NOT NULL
- category_id (카테고리 id) — bigint — Foreign key → nationality_category.id — NOT NULL
- version_id (버전 id) — bigint — Foreign key → nationality_version.id — NOT NULL
- group (그룹) — varchar
- name (이름) — varchar
- is_unconditional_high_risk (당연고 여부) — tinyint
- is_changed (변경여부) — tinyint
- is_deleted (삭제여부) — tinyint
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
nationality_history (국가 변경 이력)
- id — bigint — Primary key — NOT NULL
- nationality_id (국가 id) — bigint — Foreign key → nationality.id — NOT NULL
- version_id (버전 id) — bigint — Foreign key → nationality_version.id — NOT NULL
- code (코드) — varchar
- name (국적 이름) — varchar
- english_name (영문명) — varchar
- is_changed (변경여부) — tinyint
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
nationality_version (국가 버전)
- id — bigint — Primary key — NOT NULL
- workflow_id (결재 ID) — bigint
- type (타입) — varchar
- is_enabled (활성화 여부) — tinyint
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
ra_coin_risk_category (거래 코인위험 항목)
- id — bigint — Primary key — NOT NULL
- name (이름) — varchar
- weight (가중치) — decimal
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
ra_coin_risk_detail (거래 코인 위험)
- id — bigint — Primary key — NOT NULL
- coin_risk_category_id (코인위험 항목 ID) — bigint — Foreign key → ra_coin_risk_category.id — NOT NULL
- ra_history_detail_id (RA 실행이력 ID) — bigint
- score (위험점수) — decimal
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime
ra_history_transaction_service (거래 상품/서비스)
- id — bigint — Primary key — NOT NULL
- ra_transaction_service_category_id (ra 거래서비스 id) — bigint — Foreign key → ra_transaction_service_category.id — NOT NULL
- ra_history_detail_id (ra history detail id) — bigint
- score (위험점수) — decimal
- created_at (생성일시) — datetime
- updated_at (수정 일시) — datetime
ra_transaction_service_category (거래 상품/서비스 항목)
- id — bigint — Primary key — NOT NULL
- name (이름) — varchar
- weight (가중치) — decimal
- created_at (생성일시) — datetime
- updated_at (수정일시) — datetime