Plan_user

Tables (4)

User

  • user_id — Primary key — NOT NULL
  • is_deleted
  • email
  • name
  • password
  • fb_auth_id (Field5)
  • kakao_auth_id
  • new_password
  • new_password_limited_until
  • login_fail
  • login_lock
  • birth_date
  • rrn
  • mobile
  • gender
  • user_type
  • biz_id
  • is_korean
  • businessnumber
  • investor_registration_status
  • investor_showcase_status
  • investor_type
  • BORROWER_TYPE
  • ci
  • di
  • account_invest_status
  • account_invest_bank
  • encrypted_account_invest_num
  • change_account_invest_bank
  • change_account_invest_num
  • account_invest_risk_agree_sign
  • account_invest_risk_agree_sign_date
  • account_loan_bank
  • encrypted_account_loan_num
  • recommender
  • last_login
  • PARENT_USER_id
  • ACCOUNT_SHOWCASE_STATUS
  • ACCOUNT_SHOWCASE_BANK
  • encrypted_account_showcase_num
  • CHANGE_ACCOUNT_SHOWCASE_BANK
  • encrypted_change_account_showcase_num
  • CHANGE_ACCOUNT_SHOWCASE_STATUS
  • investor_account_enrolled_secured
  • crn_last_half
  • signup_platform
  • connected_at
  • encrypt_rrn_last_half_pkcs7
  • secured_account_updated_time
  • sub_signup_platform
  • created
  • modified
  • temp_password
  • verification_account
  • verification_identification
  • agree_secured_invest_term
  • agree_unsecured_invest_term
  • address
  • detail_address
  • job
  • … +9

user_finance

  • id — Primary key — NOT NULL
  • user_id — Foreign key → user_info.id — NOT NULL
  • investor_type
  • borrower_type
  • investor_registration_status
  • investor_showcase_status
  • jb_investor_unique_number
  • jb_investor_customer_number
  • account_invest_status
  • account_invest_bank
  • encrypted_account_invest_num
  • account_invest_risk_agree_sign
  • account_invest_risk_agree_sign_date
  • account_loan_bank
  • encrypted_account_loan_num
  • account_showcase_status
  • account_showcase_bank
  • encrypted_account_showcase_num
  • change_account_showcase_status
  • change_account_showcase_bank
  • encrypted_change_account_showcase_num
  • investor_account_enrolled_secured
  • secured_account_updated_time
  • verification_account
  • verification_identification
  • id_card_issue_date
  • created_at
  • updated_at

user_info

  • id — BIGINT — Primary key — NOT NULL
  • user_state — VARCHAR(2)
  • parent_user_id — BIGINT
  • biz_id — BIGINT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • new_password — VARCHAR(255)
  • new_password_limited — BIGINT
  • login_fail_count — INT
  • login_lock_limited — BIGINT
  • user_type — VARCHAR(20)
  • gender — VARCHAR(5)
  • ci — VARCHAR(255)
  • di — VARCHAR(255)
  • pf_di — VARCHAR(255)
  • recommender — BIGINT
  • signup_platform — VARCHAR(20)
  • sub_signup_platform — VARCHAR(20)
  • last_accessed_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

user_info_details

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_info.id — NOT NULL
  • name — VARCHAR(255)
  • name_en — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • birth_date — VARCHAR(255)
  • country — VARCHAR(3)
  • rrn — VARCHAR(255)
  • address — VARCHAR(255)
  • detailed_address — VARCHAR(255)
  • post_code — VARCHAR(255)
  • job — VARCHAR(255)
  • passport_number — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME