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)