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