Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| program_id | VARCHAR | 36 | √ | null |
|
|
||
| old_data_id | INT | 10 | √ | null |
|
|
||
| id | VARCHAR | 36 | null |
|
|
|||
| VARCHAR | 255 | √ | null |
|
|
|||
| email_verified_at | DATETIME | 19 | √ | null |
|
|
||
| name | VARCHAR | 255 | null |
|
|
|||
| mobile | VARCHAR | 15 | √ | null |
|
|
||
| password | VARCHAR | 255 | null |
|
|
|||
| adm_type | VARCHAR | 3 | √ | 0 |
|
|
||
| type | TINYINT | 3 | null |
|
|
1-Admin,2-Facilitator,3-Learner,4-Alumni |
||
| status | BIT | 1 | √ | 1 |
|
|
0:Inactive,1:Active |
|
| organisation_id | VARCHAR | 36 | √ | null |
|
|
||
| centre_id | VARCHAR | 36 | √ | null |
|
|
||
| project_id | VARCHAR | 36 | √ | null |
|
|
||
| remember_token | VARCHAR | 100 | √ | null |
|
|
||
| image | VARCHAR | 255 | √ | profilepic/1.svg |
|
|
||
| otp | INT | 10 | √ | null |
|
|
||
| otp_timestamp | DATETIME | 19 | √ | null |
|
|
||
| tenant_id | VARCHAR | 36 | null |
|
|
|||
| fcm_id | VARCHAR | 255 | √ | null |
|
|
||
| gender | VARCHAR | 10 | √ | null |
|
|
||
| created_platform | TINYINT | 3 | √ | null |
|
|
||
| created_at | DATETIME | 19 | √ | null |
|
|
||
| updated_at | DATETIME | 19 | √ | null |
|
|
||
| deleted_at | TIMESTAMP | 19 | √ | null |
|
|
||
| is_super_facilitator | TINYINT | 3 | √ | 0 |
|
|
0:No,1:Yes |
|
| is_master_trainer | TINYINT | 3 | √ | 0 |
|
|
0:No,1:Yes |
|
| reference_id | INT | 10 | √ | null |
|
|
Depends on roles.This can be id from centre,org,project and program |
|
| reg_status | TINYINT | 3 | √ | 1 |
|
|
||
| is_logged_in | TINYINT | 3 | √ | null |
|
|
1:Yes |
|
| is_reg_mail_send | TINYINT | 3 | √ | null |
|
|
0:No,1:Yes |
|
| is_quest_employee | TINYINT | 3 | √ | null |
|
|
0:No,1:Yes |
|
| state | VARCHAR | 36 | √ | null |
|
|
||
| created_by | VARCHAR | 36 | √ | null |
|
|
||
| is_approved | TINYINT | 3 | √ | 1 |
|
|
0:No,1:Yes |
|
| approval_group | VARCHAR | 36 | √ | null |
|
|
||
| approved_by | VARCHAR | 36 | √ | null |
|
|
||
| is_email_verified | TINYINT | 3 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
