Plan_user
Tables (4)
User
- user_id — Primary key — NOT NULL
- is_deleted
- 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