test
Tables (4)
user_auths
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- auth_provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(200)
- refresh_token — VARCHAR(500)
- refresh_token_expires_at — TIMESTAMP
- last_login_at — TIMESTAMP
- login_fail_count — INTEGER
- account_locked_until — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(50)
- updated_by — VARCHAR(50)
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMP
users
- id — BIGSERIAL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100)
- name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- resident_number — VARCHAR(256)
- user_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- birth_date — DATE
- gender — VARCHAR(10)
- zip_code — VARCHAR(10)
- address — VARCHAR(200)
- address_detail — VARCHAR(200)
- business_number — VARCHAR(20)
- business_name — VARCHAR(100)
- marketing_agreed — BOOLEAN
- marketing_agreed_at — DATE
- terms_agreed_at — DATE
- privacy_agreed_at — DATE
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(50)
- updated_by — VARCHAR(50)
- deleted — BOOLEAN — NOT NULL
- deleted_at — TIMESTAMP