Description:
The gusers table stores user (customer / end user) profiles, including personal information, verification states, billing details, preferences, and metadata used for authentication, identification, and rental eligibility. Single-table inheritance: dtype = 0 rows are end users, dtype = 1 rows are user groups. Use for cohorts, repeat usage, churn proxies, and user segmentation.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique internal identifier for the user. |
uuid |
TEXT | Universally unique identifier. |
dtype |
NUMBER | Discriminator for user type: 0 => end user, 1 => user group. |
auth_id |
TEXT | Authentication ID from external identity provider. |
birthdate |
DATE | Date of birth. |
city |
TEXT | City from user’s registered address. |
country |
TEXT | Country of residence. |
created_at |
TIMESTAMP_TZ | Timestamp when the user profile was created. |
updated_at |
TIMESTAMP_TZ | Timestamp of last user profile update. |
created_by |
NUMBER | ID of the user/system who created this record. |
updated_by |
NUMBER | ID of the user/system who last updated this record. |
email |
TEXT | User’s email address. |
email_is_verified |
BOOLEAN | Whether the email address has been verified. |
email_verification_code |
TEXT | Code sent to user for email verification. |
email_verification_code_valid_until |
TIMESTAMP_NTZ | Expiry for the email verification code. |
first_name |
TEXT | First name of the user. |
last_name |
TEXT | Last name of the user. |
license_verification_state |
NUMBER | State of driver’s license verification (enum): 0 => no verification started. 1 => verification has been initiated. 2 => user uploaded data and verification is in progress. 3 => user has been verified successfully. 4 => user couldn’t be verified. 5 => user needs to try again. 6 => verification successful but needs additional processing. 7 => expired (document valid-until date is before now). 8 => review (verification needs to be reviewed by the customer’s team; only active when using fully-automatic mode on Veriff). 9 => pending reverification (user has to reverify their driving license). |
phone |
TEXT | User’s phone number. |
phone_is_verified |
BOOLEAN | Whether the phone number has been verified. |
phone_verification_code |
NUMBER | Code sent for phone verification. |
phone_verification_code_valid_until |
TIMESTAMP_NTZ | Expiry for the phone verification code. |
postcode |
TEXT | Postal/ZIP code from user’s address. |
referral_code |
TEXT | User’s personal referral code. |
street |
TEXT | Street portion of the user’s address. |
stripe_id |
TEXT | Associated Stripe customer ID for payments. |
referring_user_id |
NUMBER | ID of the user who referred this customer. |
language |
TEXT | Preferred language. |
backend_notes |
TEXT | Internal notes about the user. |
gender |
NUMBER | User’s gender (enum): 0 => FEMALE, 1 => MALE. |
gender_name |
TEXT | String label for gender. |
receive_newsletter |
BOOLEAN | Whether the user is subscribed to newsletters. |
sepa_state |
NUMBER | State of the SEPA mandate (enum): 0 => NONE, 1 => BLOCK, 2 => ALLOW. |
sepa_state_name |
TEXT | String label for sepa_state. |
credit_score |
NUMBER | Numeric credit score for risk assessment. |
manual_verification_state |
NUMBER | Manual review status (e.g., pending, passed, rejected). |
custom_properties |
VARIANT | Flexible JSON field for additional user data. Sample value: { "accountSetupSkipped": true, "birthPlace": "Tulln" }. |
block_state |
NUMBER | Whether the user is blocked or restricted (enum): 0 => NOT_BLOCKED, 1 => BLOCKED_UNKNOWN, 2 => BLOCKED_BY_ADMIN, 3 => BLOCKED_BY_ADMINDELETE, 4 => GROUP_DELETED, 5 => GROUP_BLOCKED_MANUAL_APPROVAL_REQUIRED, 6 => GROUP_BLOCKED_MANUAL_APPROVAL_REJECTED. |
block_state_name |
TEXT | String label for block_state. |
payment_properties |
VARIANT | Payment configuration/properties (JSON). Sample value: { "onfido-applicant-id": "2a1-c7-44b-b6-876e3" }. |
user_device |
VARIANT | Metadata about the user’s device(s). Sample value: { "deviceFamily": "Z Flip5", "osFamily": "Android", "osMajor": "15", "osMinor": null, "osPatch": null, "osPatchMinor": null, "userAgentFamily": null, "userAgentMajor": null, "userAgentMinor": null, "userAgentPatch": null }. |
payment_state |
NUMBER | Status of the user’s current payment setup (enum): 0 => OPEN, 1 => CLOSED, 2 => IN_PAYMENT, 3 => AWAITING_RETRY, 4 => PAID, 5 => FAILED, 6 => DISPUTED, 7 => COLLECTIONS, 8 => PUSH_WAITING_FOR_USER, 9 => PUSH_CANCELLED_BY_USER, 10 => PUSH_BANK_REFUSED, 11 => NOTIFIED, 12 => DISPUTE_LOST. |
payment_state_name |
TEXT | String label for payment_state. |
owner_id |
NUMBER | ID of account owner (used in enterprise/multi-user scenarios). |
ext_ref |
TEXT | External reference ID. |
sign_in_methods |
NUMBER | Bitmap of enabled sign-in methods (EnumSet): 1 => EMAIL, 2 => SMS, 4 => SOCIAL_GOOGLE, 8 => SOCIAL_APPLE, 16 => SOCIAL_FACEBOOK, 32 => API, 64 => PIM_OPENID, 128 => GAIYO, 256 => EMAIL_CODE. |
home_billable_branch_id |
NUMBER | Default branch used for billing purposes. |
driving_license_categories |
ARRAY | List of categories the user’s license supports (e.g., A, B, C). |
billing_period |
NUMBER | User’s selected billing period (enum): 0 => NONE, 1 => WEEKLY, 2 => MONTHLY. |
billing_period_name |
TEXT | String label for billing_period. |
external_references |
VARIANT | Arbitrary external reference info from other systems. |
license_expiration_date |
DATE | Date when the user’s license expires. |
vat_number |
TEXT | User’s VAT (Value Added Tax) registration number. |
impersonate_uuid |
TEXT | If impersonated, UUID of the impersonator. |
check_rental_requirements |
BOOLEAN | Whether the user should be checked for rental eligibility. |
billable_branch_payment_properties |
VARIANT | Billing settings specific to the branch. Sample value: { "73": { "invoicing": true } } (where 73 is the branch_id). |
pgs_payment_properties |
VARIANT | Payment Gateway System properties (JSON). |
dashboard_properties |
VARIANT | Dashboard preferences, views, and customizations. |
default_cost_center_id |
NUMBER | Default cost center ID. |
company_registration_number |
TEXT | For business users: their legal registration number. |
credit_status |
NUMBER | Creditworthiness status flag (RatingStatus: PENDING/GREEN/YELLOW/RED/FAILED). |
billing_cycle |
NUMBER | Frequency of billing (enum): 0 => PAY_AS_YOU_GO, 1 => HOURLY, 2 => DAILY, 3 => WEEKLY, 4 => BI_WEEKLY, 5 => MONTHLY. |
billing_cycle_name |
TEXT | String label for billing_cycle. |
source_type |
NUMBER | Source/payment-source type (enum): 0 => APPLE_PAY, 1 => CREDIT_CARD, 2 => GOOGLE_PAY, 3 => PAY_PAL, 4 => IDEAL, 5 => SOFORT, 6 => BANCONTACT, 7 => KLARNA, 8 => GENERIC_PUSH, 9 => GENERIC_RECURRING, 10 => SEPA. |
source_type_name |
TEXT | String label for source_type. |
use_receipt_instead_of_invoice |
BOOLEAN | Whether to issue receipts instead of invoices. |
newsletter_options |
VARIANT | Fine-grained preferences for newsletters. Sample value: { "receiveMarketingOffers": false, "receiveNews": false }. |
settings |
VARIANT | General user settings/preferences. Sample value: { "drivingLogReminderSettings": { "adaptiveReminderDays": [ 1, 3, 7 ], "enabled": false, "reminderType": "ADAPTIVE" }, "drivingLogSubmissionGracePeriodDays": 10, "requireDrivingLog": false, "shouldIgnoreBCategoryRentalRequirement": false }. |
custom_external_verification_state |
TEXT | Custom state for external user verification. |
id_verification_state |
TEXT | Status of ID verification. Sample values: UNVERIFIED, CREATED, PROCESSING, VERIFIED, REJECTED, RETRY, VERIFIED_BUT_NEEDS_CHECK, EXPIRED_LICENSE, REVIEW, PENDING_REVERIFICATION. |
id_expiration_date |
DATE | Expiry date of the provided ID. |
id_document_type |
TEXT | Type of identification document submitted (e.g., passport, ID card). |
appsflyer_id |
TEXT | AppsFlyer attribution identifier for the user. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | Timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | Timestamp of last record update in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |