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