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)