DCBoard
Tables (3)
Copy Of users (CopyOfusers)
- id — NUMBER — Primary key — NOT NULL
- 이메일 (email) — VARCHAR2(255) — NOT NULL
- 비밀번호 (password) — VARCHAR2(255) — NOT NULL
- 이름 (name) — VARCHAR2(50) — NOT NULL
- 역할 (role) — VARCHAR2(50) — NOT NULL
- 생성일 (created_dt) — TIMESTAMP — NOT NULL
- 수정일 (updated_dt) — TIMESTAMP — NOT NULL
- 삭제일 (deleted_dt) — TIMESTAMP
- 실패횟수 (failed_count) — NUMBER — NOT NULL
- 잠김여부 (is_locked) — VARCHAR2(1) — NOT NULL
user_sessions
- id — NUMBER — Primary key — NOT NULL
- user_id — NUMBER — Foreign key → users.id — NOT NULL
- access_token — VARCHAR2(255) — NOT NULL
- refresh_token — VARCHAR2(255) — NOT NULL
- 생성일 (created_dt) — TIMESTAMP — NOT NULL
- at만료일 (at_expires_dt) — TIMESTAMP — NOT NULL
- rt만료일 (rt_expires_dt) — TIMESTAMP — NOT NULL
users
- id — NUMBER — Primary key — NOT NULL
- 이메일 (email) — VARCHAR2(255) — NOT NULL
- 비밀번호 (password) — VARCHAR2(255) — NOT NULL
- 이름 (name) — VARCHAR2(50) — NOT NULL
- 역할 (role) — VARCHAR2(50) — NOT NULL
- 생성일 (created_dt) — TIMESTAMP — NOT NULL
- 수정일 (updated_dt) — TIMESTAMP — NOT NULL
- 삭제일 (deleted_dt) — TIMESTAMP
- 실패횟수 (failed_count) — NUMBER — NOT NULL
- 잠김여부 (is_locked) — VARCHAR2(1) — NOT NULL