TouchPoint-User

테이블 (4)

CERTIFICATION

  • USER_ID — VARCHAR2(30 BYTE) — PK_CERTIFICATION" PRIMARY KEY ("USER_ID")
  • EMAIL — VARCHAR2(255 BYTE) — NOT NULL
  • CERTIFICAION_NUMBER — VARCHAR2(6 BYTE) — NOT NULL

LOGIN_ATTEMPT

  • ATTEMPT_ID — NUMBER — 기본 키 — PK_LOGIN_ATTEMPT" PRIMARY KEY ("ATTEMPT_ID")
  • USER_ID — VARCHAR2(20 BYTE) — 외래 키 → 회원.회원아이디 — NOT NULL — FK_LOGIN_ATTEMPT_USER_ID" FOREIGN KEY ("USER_ID")
  • FAILED_LOGIN_CNT — NUMBER — NOT NULL
  • CAPTCHA_ACTIVE — CHAR(1 BYTE) — NOT NULL — CHECK_LOGIN_ATTEMPT_CAPTCHA_ACTIVE" CHECK (CAPTCHA_ACTIVE IN ('Y', 'N'))

USER_SOCIAL

  • PROVIDER — VARCHAR2(20 BYTE) — NOT NULL
  • USER_ID — VARCHAR2(20 BYTE) — 외래 키 → 회원.회원아이디 — NOT NULL — FK_USER_SOCIAL_USER" FOREIGN KEY ("USER_ID")
  • PROVIDER_USER_ID — VARCHAR2(50 BYTE) — NOT NULL

회원 (USERS)

  • USER_CD — NUMBER — 기본 키 — NOT NULL — PK_USER" PRIMARY KEY
  • 회원아이디 (USER_ID) — VARCHAR2(20 BYTE) — UNIQUE_USER_ID" UNIQUE
  • 패스워드 (PASSWORD) — VARCHAR2(255 BYTE)
  • 이메일 (EMAIL) — VARCHAR2(50 BYTE)
  • 전화번호 (PHONE_NO) — VARCHAR2(15 CHAR)
  • 이름 (NAME) — VARCHAR2(50 BYTE)
  • 회원가입일 (JOIN_DT) — DATE — NOT NULL
  • 회원상태 (USER_ST) — CHAR(1 BYTE) — NOT NULL — CHK_USER_ST" CHECK (USER_ST IN ('Y', 'N'))
  • 소셜로그인유무 (SOCIAL_USER) — CHAR(1 BYTE) — NOT NULL — CHK_SOCIAL_USER" CHECK (SOCIAL_USER IN ('Y', 'N', 'B'))
  • 광고수신동의여부 (AD_AGREED) — CHAR(1 BYTE) — NOT NULL — CHK_AD_AGREED" CHECK (AD_AGREED IN ('Y', 'N'))
  • 회원권한 (USER_ROLE) — VARCHAR2(20 BYTE) — NOT NULL