asd

Tables (3)

email_verifications

  • verification_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • code — VARCHAR(10) — NOT NULL
  • purpose — VARCHAR(30) — NOT NULL
  • is_verified — TINYINT — NOT NULL
  • verification_token — VARCHAR(200)
  • expires_at — DATETIME — NOT NULL
  • verified_at — DATETIME
  • created_at — DATETIME — NOT NULL

members

  • member_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • birth_date — DATE — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • required_terms_agreed — TINYINT — NOT NULL
  • optional_terms_agreed — TINYINT — NOT NULL
  • login_fail_count — INT — NOT NULL
  • is_locked — TINYINT — NOT NULL
  • locked_at — DATETIME
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

refresh_tokens

  • token_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • token — VARCHAR(500) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL