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