new_user

테이블 (10)

auth_user (아직 미정) (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • user_grade (Field)
  • risk_level_summary (Field2)
  • terms_date (Field3)
  • created_at (Field5)
  • updated_at (Field6)
  • last_login (Field4) — opencex
  • deny (Field7) — 보류

user_addition (Untitled7)

  • id (Key) — 기본 키 — NOT NULL
  • user_name_eng_first (Field3)
  • user_name_eng_last (Field2)
  • nationality (Field18) — 보류
  • user_ci_srl (Field17) — 보류
  • passport_number (Field8)
  • license_number (Field9)
  • company_name (Field13)
  • dev_name (Field12)
  • spot (Field6)
  • work_tel_no (Field)
  • representative_name (Field7)
  • business_number (Field16)
  • job_cd (Field10)
  • indst_dvd_cd (Field11)
  • cap_src_cd (Field15)
  • tr_obj_use_cd (Field5)
  • cap_src_comment (Field14)
  • tr_obj_use_comment (Field4)
  • idType (Field19) — 보류

user_addr (Untitled8)

  • id (Key) — 기본 키 — NOT NULL
  • addr (Field)
  • addr_detail (Field2)
  • addr_division (Field3)
  • zip_code (Field4)
  • issuingCountry (Field5)
  • idcard_issuingCountry (Field6)
  • created_at (Field7)
  • updated_at (Field8)

user_auth_password (Untitled9)

  • id (Key) — 기본 키 — NOT NULL
  • user_auth_password (Field2)
  • user_auth_password_fail (Field3)
  • user_auth_password_data (Field4)
  • created_at (Field5)
  • updated_at (Field6)

user_carf_info (Untitled6)

  • id (Key) — 기본 키 — NOT NULL
  • carf_type (Field)
  • carf_status (Field2)
  • comment (Field3)
  • created_at (Field4)
  • updated_at (Field5)

user_certification (Untitled10)

  • id (Key) — 기본 키 — NOT NULL
  • user_auth_otp (Field)
  • user_auth_phone (Field2)
  • user_auth_email (Field3)
  • user_auth_name (Field4)
  • user_auth_idcard (Field5)
  • user_auth_kyc (Field6)
  • user_auth_pledge (Field7) — 삭제
  • user_auth_bank (Field8)
  • user_auth_resident (Field9) — 삭제

user_info (아직 미정) (Untitled3)

  • id (Key) — 기본 키 — NOT NULL
  • user_name (Field3)
  • user_sex (Field)
  • user_email1 (Field4)
  • user_email2 (Field5)
  • user_password (Field13)
  • user_birth (Field6)
  • nationality (Field8)
  • user_auth_phone_com (Field2)
  • user_auth_phone_1 (Field7)
  • user_auth_phone_2 (Field11)
  • user_auth_phone_3 (Field12)
  • created_at (Field9)
  • updated_at (Field10)

user_kyc_log (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (Field9) — 이관
  • submission_id (Field)
  • status (Field2) — 삭제 예정
  • comment (Field3) — 테이블:cdd_edd 컬럼:ck_comment
  • reviewer_id (Field11) — 테이블:cdd_edd 컬럼:ck_duty_id
  • reject_type (Field6) — opencex
  • reject_labels (Field7) — opencex
  • kyc_information (Field8) — 보류
  • kyc_type (Field10) — 테이블:cdd_edd 컬럼:cdd_edd_division
  • created_at (Field4) — 테이블:cdd_edd 컬럼:exe_date
  • updated_at (Field5) — 삭제 예정

user_otp (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • user_srl (Field7)
  • name (Field5) — opencex
  • user_auth_otp_secret (Field)
  • user_auth_otp_fail (Field2)
  • last_t (Field6) — opencex
  • created_at (Field3)
  • updated_at (Field4)

user_setting_status (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • ----------시스템 플래그---------- (-----------)
  • user_password_flag (Field)
  • user_auth_password_flag (Field6)
  • email_flag (Field17)
  • sms_flag (Field15)
  • user_dupl (Field2)
  • is_gton (Field16)
  • ----------약관 동의 플래그--------- (-------------)
  • terms_flag (Field13)
  • terms_priv_flag (Field12)
  • terms_3rd_flag (Field14)
  • created_at (Field19)
  • updated_at (Field20)