EMAIL&OTP
Tables (7)
auth_email
- EMAIL_AUTH_ID (email_auth_id) — INT — Primary key — NOT NULL
- SECURITY_ID (security_id) — INT — Foreign key → member.SECURITY_ID — NOT NULL
- AUTH_EMAIL (auth_email) — VARCHAR(704)
- Field
authentication_log
- AUTH_LOG_ID (auth_log_id) — BIGINT — Primary key
- SECURITY_ID (security_id) — INT — Foreign key → member.SECURITY_ID — NOT NULL
- AUTH_LOG_DETAIL_ID (auth_log_detail_id) — BIGINT — Foreign key → authentication_log_detail.AUTH_LOG_DETAIL_ID
- AUTH_CAUSE (auth_cause) — NVARCHAR(20)
- AUTH_INFO (auth_info) — VARCHAR(704)
- AUTH_METHOD (auth_method) — CHAR(1)
- IPADDR (ipaddr) — VARCHAR(15)
- AUTH_RESULT (auth_result) — VARCHAR(7)
- AUTH_RESULT_CODE (auth_result_code) — INT
- AUTH_ERROR_MSG (auth_error_msg) — NVARCHAR(128)
- CREATED_DATE (created_date) — DATETIME
- YMD — CHAR(8)
authentication_log_detail
- AUTH_LOG_DETAIL_ID (auth_log_detail_id) — BIGINT — Primary key
- REC_CERT (rec_cert) — VARCHAR(1984)
- K_CERT_NUM (k_cert_num) — VARCHAR(36)
- BIRTH_DAY (birth_day) — NVARCHAR(44)
- NAME (name) — NVARCHAR(152)
- GENDER (gender) — NVARCHAR(1)
- PHONE (phone) — NVARCHAR(64)
- PHONE_COMPANY (phone_company) — NVARCHAR(10)
email_authentication
- AUTHENTICATION_ID (auth_id) — INT — Primary key — NOT NULL
- SECURITY_ID (security_id) — INT — Foreign key → member.SECURITY_ID — NOT NULL
- EMAIL (email) — VARCHAR(704)
- AUTHENTICATION_KEY (authentication_key) — CAHR(6)
- AVAILABLE_PERIOD (available_period) — DATETIME
- STATUS_YN (status_yn) — CHAR(1)
- CREATED_DATE (created_date) — DATETIME
member
- SECURITY_ID (security_id) — INT — Primary key — NOT NULL
- SECURITY_NAME (security_name) — NVARCHAR(50)
otp
- OTP_ID (otp_id) — INT — Primary key — NOT NULL
- SECURITY_ID (security_id) — INT — Foreign key → member.SECURITY_ID — NOT NULL
- OTP_SECUKEY (otp_secukey) — VARCHAR(32) — NOT NULL
- CREATED_DATE (created_date) — DATETIME
- OTP_USE_YN (otp_use_yn) — VARCHAR(1)
otp_log
- OTP_LOG_ID (otp_log_id) — BIGINT — Primary key — NOT NULL
- OTP_ID (otp_id) — INT — Foreign key → otp.OTP_ID — NOT NULL
- OTP_ACT (otp_act) — NVARCHAR(20)
- OTP_RESULT (otp_result) — VARCHAR(7)
- OTP_RESULT_CODE (otp_result_code) — INT
- OTP_ERROR_MSG (otp_error_msg) — NVARCHAR(128)
- CREATED_DATE (created_date) — DATETIME
- YMD — CHAR(8)