UserInfo
Shows OpenID Connect user profile information for standard claims.
Table Specific Information
Select
The 本製品 processes all filters client side within the 本製品.
SELECT * FROM UserInfo
Columns
| Name | Type | References | Description |
| UserId | String | The user ID of the user. | |
| Sub | String | The subject ID for the end user at the issuer. | |
| Name | String | The full name of the user. | |
| GivenName | String | The given, or first, name of the user. | |
| FamilyName | String | The surname or family name of the user. Also known as the last name. | |
| MiddleName | String | The middle name of the user. | |
| Picture | String | The URL of the profile picture of the user. | |
| String | The internationalized email address. | ||
| EmailVerified | Boolean | Indicates whether the user's email address is verified. | |
| Gender | String | The user's gender. | |
| Birthdate | Datetime | The user's birthday, in YYYY-MM-DD format. | |
| ZoneInfo | String | The time zone of the user. | |
| Locale | String | The locale of the user. | |
| PhoneNumber | String | The preferred telephone number of the user. | |
| StreetAddress | String | The full street address. Can include the house number and street name. | |
| Locality | String | The city or locality. | |
| Region | String | The state, province, prefecture, or region. | |
| PostalCode | String | The zip code or postal code. | |
| Country | String | The country. | |
| VerifiedAccount | Boolean | Indicates whether the account is verified. | |
| AccountType | String | The account type.
使用できる値は次のとおりです。PERSONAL, BUSINESS, PREMIER | |
| AgeRange | String | The account holder's age range. |