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