test

Tables (4)

usage_details_2025_01

  • 2025-01-01) — TO

usage_details_2025_02

  • 2025-02-01) — TO

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