Database Table "hyp_Clients Website Ext. Record"
Table Description
Normal Storage |
Archive Storage |
Deleted Storage(Recycle) |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| Client Number | Integer | 0 | Edit | Hidden Read Only Key Field |
ClientNumber | |
| Account Status | Values List: 0 = Blocked (cannot Sign-in)1 = Pending Approval 2 = Approved 3 = On Hold (Readonly) |
Status | 0 | Select | AccountStatus | |
| Send OTP over | Values List: 0 = Authenticator App1 = SMS 2 = Email 3 = Phone Call |
Status | 0 | Select | SendOtpOver | |
| Last Registration Step | Integer | 0 | Edit | Read Only | LastRegistrationStep | |
| Registration Complete Until Step | Integer | 0 | Edit | Read Only | RegistrationCompleteUntilStep | |
| First Reg. Page Date | Date | 0 | SelectEdit | Read Only | FirstRegPageDate | |
| Registration Date | Date | 0 | SelectEdit | Read Only | RegistrationDate | |
| Agree to Terms Checkbox | Date | 0 | SelectEdit | Read Only | AgreeToTermsCheckbox | |
| Last Sign-in Date | Date | 0 | SelectEdit | Read Only | LastSign-inDate | |
| Last Sign-in Details | String | 30 | SelectEdit | Read Only | LastSign-inDetails | |
| Last Password Change | FixDT | 0 | SelectEdit | Read Only | LastPasswordChange | |
| Last Password Recovery Request UTC | FixDT | 0 | SelectEdit | Read Only | LastPasswordRecoveryRequestUtc | |
| Last Quiz | String | 30 | SelectEdit | Read Only | LastQuiz | |
| Last Quiz Date | Date | 0 | SelectEdit | Read Only | LastQuizDate | |
| Last Doc Upload Date | Date | 0 | SelectEdit | Read Only | LastDocUploadDate | |
| Last Shopping Date | Date | 0 | SelectEdit | Read Only | LastShoppingDate | |
| Last Payment Date | Date | 0 | SelectEdit | Read Only | LastPaymentDate | |
| Last Contract Signing at | FixDT | 0 | SelectEdit | Read Only | LastContractSigningAt | |
| Must Sign Contract (Again) | Bool | 0 | Select | MustSignContractAgain | ||
| EMail Token | String | 12 | Edit | Hidden Read Only |
EmailToken | |
| EMail Token at UTC | FixDT | 0 | SelectEdit | Read Only | EmailTokenAtUtc | |
| EMail Verification Status | Values List: 0 = Not Asked1 = Waiting 2 = Verified |
Status | 0 | Select | Read Only | EmailVerificationStatus |
| Phone Token | String | 12 | Edit | Hidden Read Only |
PhoneToken | |
| Phone Token at UTC | FixDT | 0 | SelectEdit | Read Only | PhoneTokenAtUtc | |
| Phone Verification Status | Values List: 0 = Not Asked1 = Waiting 2 = Verified |
Status | 0 | Select | Read Only | PhoneVerificationStatus |
| Portal Password | String | 50 | Edit | Hidden Read Only |
PortalPassword | |
| API Password | String | 15 | Edit | Hidden Read Only |
ApiPassword | |
| Time Based OTP Token | String | 12 | Edit | Hidden Read Only |
TimeBasedOtpToken | |
| Time Based OTP Token at UTC | FixDT | 0 | SelectEdit | Read Only | TimeBasedOtpTokenAtUtc |