lowa
admins
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| advocate_id | int(11) | Yes | NULL | |||
| name | varchar(191) | Yes | NULL | |||
| varchar(191) | No | |||||
| password | varchar(191) | No | ||||
| first_name | varchar(100) | Yes | NULL | |||
| last_name | varchar(100) | Yes | NULL | |||
| mobile | varchar(30) | Yes | NULL | |||
| registration_no | varchar(190) | Yes | NULL | |||
| associated_name | varchar(190) | Yes | NULL | |||
| address | text | Yes | NULL | |||
| city_id | int(11) | Yes | NULL | |||
| zipcode | varchar(190) | Yes | NULL | |||
| state_id | int(11) | Yes | NULL | |||
| country_id | int(11) | Yes | NULL | |||
| profile_img | varchar(190) | Yes | NULL | |||
| is_activated | tinyint(1) | No | 0 | |||
| is_account_setup | tinyint(1) | No | 0 | |||
| remember_token | varchar(100) | Yes | NULL | |||
| is_user_type | enum('SUPERADMIN', 'ADVOCATE', 'STAFF') | No | ADVOCATE | |||
| invitation_status | enum('accepted', 'sent') | No | sent | |||
| accepted_at | datetime | Yes | NULL | |||
| current_package | varchar(190) | Yes | NULL | |||
| payment_id | int(11) | Yes | 0 | |||
| started_at | date | Yes | NULL | |||
| expires_at | timestamp | Yes | NULL | |||
| last_login_at | timestamp | Yes | NULL | |||
| last_login_ip | varchar(190) | Yes | NULL | |||
| is_active | enum('Yes', 'No') | No | Yes | |||
| is_expired | enum('Yes', 'No') | No | No | |||
| otp | varchar(255) | Yes | NULL | |||
| otp_date | timestamp | Yes | NULL | |||
| is_otp_verify | enum('0', '1') | No | 0 | |||
| plateform | enum('App', 'Web') | No | Web | |||
| user_type | enum('Admin', 'User') | No | User | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No | |
| admins_email_unique | BTREE | Yes | No | 2 | A | No |
admin_password_resets
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| varchar(191) | No | |||||
| token | varchar(191) | No | ||||
| created_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| admin_password_resets_email_index | BTREE | No | No | 0 | A | No | ||
| admin_password_resets_token_index | BTREE | No | No | token | 0 | A | No |
admin_role
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| admin_id | int(11) | No | ||||
| role_id | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No | |
| role_id | BTREE | No | No | role_id | 2 | A | No | |
| admin_id | BTREE | No | No | admin_id | 2 | A | No |
advocate_clients
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| first_name | varchar(100) | No | ||||
| middle_name | varchar(100) | No | ||||
| last_name | varchar(100) | No | ||||
| gender | enum('Male', 'Female') | No | ||||
| varchar(190) | Yes | NULL | ||||
| mobile | varchar(20) | No | ||||
| alternate_no | varchar(20) | Yes | NULL | |||
| address | text | No | ||||
| country_id | int(11) | No | ||||
| state_id | int(11) | No | ||||
| city_id | int(11) | No | ||||
| reference_name | text | Yes | NULL | |||
| reference_mobile | varchar(255) | Yes | NULL | |||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | Yes | NULL | |||
| client_type | enum('single', 'multiple') | No | ||||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
all_taxes
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| name | text | No | ||||
| per | varchar(255) | No | ||||
| note | text | Yes | NULL | |||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
appointments
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| client_id | int(11) | Yes | NULL | |||
| advocate_id | int(11) | No | ||||
| type | enum('new', 'exists') | No | new | |||
| date | datetime | No | ||||
| time | time | No | ||||
| mobile | varchar(255) | No | ||||
| name | varchar(255) | Yes | NULL | |||
| note | text | Yes | NULL | |||
| is_active | enum('OPEN', 'CANCEL BY CLIENT', 'CANCEL BY ADVOCATE') | No | OPEN | |||
| updated_at | timestamp | No | current_timestamp() | |||
| created_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
case_logs
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| court_case_id | int(11) | No | ||||
| judge_type | int(11) | Yes | NULL | |||
| case_status | int(11) | Yes | NULL | |||
| court_no | varchar(190) | Yes | NULL | |||
| judge_name | varchar(190) | Yes | NULL | |||
| bussiness_on_date | datetime | Yes | NULL | |||
| hearing_date | datetime | Yes | NULL | |||
| remark | text | Yes | NULL | |||
| is_transfer | enum('Yes', 'No') | No | No | |||
| transfer_judge_type | int(11) | Yes | NULL | |||
| transfer_court_no | varchar(190) | Yes | NULL | |||
| updated_by | int(11) | Yes | NULL | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
case_members
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| case_id | int(11) | No | ||||
| employee_id | int(11) | No | ||||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
case_parties_involves
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| court_case_id | int(11) | Yes | NULL | |||
| position | varchar(190) | Yes | NULL | |||
| party_name | varchar(190) | Yes | NULL | |||
| party_advocate | varchar(190) | Yes | NULL | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
case_statuses
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| case_status_name | varchar(190) | No | ||||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
case_transfers
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| court_case_id | int(11) | No | ||||
| from_judge_type | int(11) | No | ||||
| to_judge_type | int(11) | No | ||||
| from_court_no | varchar(255) | No | ||||
| to_court_no | varchar(255) | No | ||||
| judge_name | varchar(255) | Yes | NULL | |||
| transfer_date | datetime | No | ||||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
case_types
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| parent_id | int(11) | No | ||||
| case_type_name | varchar(190) | No | ||||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
cities
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(30) | No | ||||
| state_id | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 48401 | A | No |
client_parties_invoives
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| client_id | int(11) | No | ||||
| advocate_id | int(11) | Yes | NULL | |||
| party_firstname | varchar(255) | Yes | NULL | |||
| party_middlename | varchar(255) | Yes | NULL | |||
| party_lastname | varchar(255) | Yes | NULL | |||
| party_mobile | varchar(255) | Yes | NULL | |||
| party_address | varchar(255) | Yes | NULL | |||
| party_advocate | varchar(255) | Yes | NULL | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
countries
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| sortname | varchar(3) | No | ||||
| name | varchar(150) | No | ||||
| phonecode | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 246 | A | No |
courts
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| court_type_id | int(11) | No | ||||
| court_name | varchar(190) | No | ||||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
court_cases
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| advo_client_id | int(11) | No | ||||
| client_position | enum('Respondent', 'Petitioner') | No | ||||
| party_name | varchar(190) | No | ||||
| party_lawyer | varchar(190) | No | ||||
| case_number | varchar(190) | Yes | NULL | |||
| case_types | int(11) | No | ||||
| case_sub_type | int(11) | Yes | NULL | |||
| case_status | int(11) | No | ||||
| act | varchar(190) | No | ||||
| priority | enum('High', 'Medium', 'Low') | No | Low | |||
| court_no | varchar(190) | No | ||||
| court_type | int(11) | No | ||||
| court | int(11) | No | ||||
| judge_type | int(11) | No | ||||
| judge_name | varchar(190) | Yes | NULL | |||
| filing_number | varchar(190) | No | ||||
| filing_date | datetime | No | ||||
| registration_number | varchar(190) | No | ||||
| registration_date | datetime | No | ||||
| remark | text | Yes | NULL | |||
| description | text | Yes | NULL | |||
| cnr_number | varchar(190) | Yes | NULL | |||
| first_hearing_date | date | Yes | NULL | |||
| next_date | datetime | Yes | NULL | |||
| updated_by | int(11) | Yes | NULL | |||
| police_station | text | Yes | NULL | |||
| fir_number | text | Yes | NULL | |||
| fir_date | date | Yes | NULL | |||
| is_nb | enum('Yes', 'No') | No | No | |||
| decision_date | date | Yes | NULL | |||
| nature_disposal | text | Yes | NULL | |||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
court_types
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| court_type_name | varchar(190) | No | ||||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
dumps
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| file | varchar(255) | No | ||||
| file_name | varchar(255) | No | ||||
| prefix | varchar(255) | Yes | NULL | |||
| encrypted | tinyint(1) | No | 0 | |||
| created_at | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
expenses
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| vendor_id | int(11) | No | ||||
| invoice_no | varchar(255) | No | ||||
| sub_total_amount | varchar(255) | No | ||||
| tax_amount | varchar(255) | Yes | NULL | |||
| total_amount | varchar(255) | No | ||||
| tax_id | int(11) | Yes | NULL | |||
| inv_status | enum('Due', 'Partially Paid', 'Paid') | No | Due | |||
| due_date | date | No | ||||
| inv_date | date | No | ||||
| remarks | text | Yes | NULL | |||
| tax_type | varchar(255) | Yes | NULL | |||
| json_content | text | Yes | NULL | |||
| invoice_created_by | int(11) | No | ||||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | datetime | No | ||||
| updated_at | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
expenses_items
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| vendor_id | int(11) | No | ||||
| invoice_id | int(11) | No | ||||
| tax_id | int(11) | Yes | NULL | |||
| tax | varchar(255) | Yes | 0 | |||
| category_id | text | No | ||||
| description | text | Yes | NULL | |||
| iteam_qty | int(11) | No | ||||
| item_amount | varchar(200) | No | ||||
| item_rate | varchar(255) | No | ||||
| created_at | datetime | No | ||||
| updated_at | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
expense_cats
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(255) | No | ||||
| description | text | Yes | NULL | |||
| advocate_id | int(11) | No | ||||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
general_settings
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| company_name | text | Yes | NULL | |||
| address | text | Yes | NULL | |||
| country | int(11) | Yes | NULL | |||
| state | int(11) | Yes | NULL | |||
| city | int(11) | Yes | NULL | |||
| pincode | int(11) | Yes | NULL | |||
| date_formet | int(11) | Yes | NULL | |||
| logo_img | text | Yes | NULL | |||
| favicon_img | text | Yes | NULL | |||
| timezone | text | Yes | NULL | |||
| updated_at | timestamp | No | current_timestamp() | |||
| created_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
invoices
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| client_id | int(11) | No | ||||
| invoice_no | varchar(255) | No | ||||
| sub_total_amount | varchar(255) | No | ||||
| tax_amount | varchar(255) | Yes | NULL | |||
| total_amount | varchar(255) | No | ||||
| inv_status | enum('Due', 'Partially Paid', 'Paid') | No | Due | |||
| due_date | date | No | ||||
| inv_date | date | No | ||||
| remarks | text | Yes | NULL | |||
| tax_type | varchar(255) | Yes | NULL | |||
| tax_id | int(11) | Yes | NULL | |||
| service_id | int(11) | Yes | NULL | |||
| json_content | text | Yes | NULL | |||
| invoice_created_by | int(11) | No | ||||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | datetime | No | ||||
| updated_at | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
invoice_items
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| client_id | int(11) | No | ||||
| invoice_id | int(11) | No | ||||
| tax_id | int(11) | Yes | NULL | |||
| tax | varchar(255) | Yes | 0 | |||
| item_description | text | Yes | NULL | |||
| iteam_qty | int(11) | No | ||||
| item_amount | varchar(200) | No | ||||
| item_rate | varchar(255) | No | ||||
| hsn | varchar(255) | Yes | NULL | |||
| service_id | int(11) | Yes | NULL | |||
| created_at | datetime | No | ||||
| updated_at | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
invoice_settings
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| invoice_formet | int(11) | No | 1 | |||
| prefix | text | Yes | NULL | |||
| client_note | text | Yes | NULL | |||
| term_condition | text | Yes | NULL | |||
| invoice_no | int(255) | No | 0 | |||
| receipt_no | int(11) | No | 0 | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
judges
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| judge_name | varchar(190) | No | ||||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
mailsetups
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||||
| mail_host | varchar(191) | No | ||||
| mail_port | varchar(191) | No | ||||
| mail_username | varchar(191) | No | ||||
| mail_email | varchar(191) | No | ||||
| mail_password | varchar(191) | No | ||||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL | |||
| mail_driver | text | No | ||||
| mail_encryption | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
migrations
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| migration | varchar(255) | No | ||||
| batch | int(11) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
newsletters
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| varchar(255) | No | |||||
| status | enum('unsbscribe', 'sbscribe') | No | unsbscribe | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
notifications
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | char(36) | No | ||||
| type | varchar(191) | No | ||||
| notifiable_id | int(10) | No | ||||
| notifiable_type | varchar(191) | No | ||||
| data | text | No | ||||
| read_at | timestamp | Yes | NULL | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
| notifications_notifiable_id_notifiable_type_index | BTREE | No | No | notifiable_id | 0 | A | No | |
| notifiable_type | 0 | A | No |
password_resets
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| varchar(191) | No | |||||
| token | varchar(191) | No | ||||
| created_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| password_resets_email_index | BTREE | No | No | 0 | A | No |
payment_mades
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| vendor_id | int(11) | No | ||||
| invoice_id | int(11) | No | ||||
| amount | bigint(200) | No | 0 | |||
| receiving_date | date | No | ||||
| payment_type | enum('Cash', 'Cheque', 'Net Banking', 'Other') | No | Cash | |||
| reference_number | varchar(255) | Yes | NULL | |||
| cheque_date | datetime | Yes | NULL | |||
| note | text | Yes | NULL | |||
| payment_received_by | int(11) | No | ||||
| created_at | datetime | No | ||||
| updated_at | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
payment_receiveds
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| client_id | int(11) | No | ||||
| invoice_id | int(11) | No | ||||
| receipt_number | int(11) | Yes | NULL | |||
| amount | varchar(200) | No | ||||
| receiving_date | datetime | No | ||||
| payment_type | enum('Cash', 'Cheque', 'Net Banking', 'Other') | No | Cash | |||
| cheque_date | date | Yes | NULL | |||
| reference_number | varchar(255) | Yes | NULL | |||
| note | text | Yes | NULL | |||
| payment_received_by | int(11) | No | ||||
| created_at | datetime | No | ||||
| updated_at | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
permissions
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| slug | varchar(255) | No | ||||
| description | text | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 62 | A | No |
permission_role
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| role_id | int(2) | No | ||||
| permission_id | int(2) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 122 | A | No | |
| permission_id | BTREE | No | No | permission_id | 122 | A | No | |
| role_id | BTREE | No | No | role_id | 4 | A | No |
roles
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| slug | varchar(255) | No | ||||
| description | text | Yes | NULL | |||
| is_active | enum('Yes', 'No') | No | ||||
| created_at | datetime | No | ||||
| updated_at | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
services
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| name | varchar(255) | Yes | NULL | |||
| amount | decimal(10,2) | Yes | NULL | |||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 14 | A | No |
settings
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| text | Yes | NULL | ||||
| text | Yes | NULL | ||||
| youtub | text | Yes | NULL | |||
| linked_in | text | Yes | NULL | |||
| text | Yes | NULL | ||||
| mobile | text | Yes | NULL | |||
| address | text | Yes | NULL | |||
| about_us | text | Yes | NULL | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
sql_backups
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| file_path | text | No | ||||
| date | datetime | No | ||||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
states
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(30) | No | ||||
| country_id | int(11) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4120 | A | No |
tasks
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| rel_type | varchar(191) | No | ||||
| rel_id | int(10) | No | ||||
| customer_id | int(11) | Yes | NULL | |||
| project_type_task_id | int(11) | Yes | NULL | |||
| task_subject | varchar(191) | No | ||||
| project_status | varchar(191) | No | ||||
| priority | varchar(191) | No | ||||
| start_date | date | No | ||||
| end_date | date | No | ||||
| description | text | Yes | NULL | |||
| checklist_complete_remarks | text | Yes | NULL | |||
| checklist_complete_signature | text | Yes | NULL | |||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL | |||
| critical_comment | text | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
| tasks_rel_type_index | BTREE | No | No | rel_type | 0 | A | No |
task_members
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| task_id | int(10) | No | ||||
| employee_id | int(10) | No | ||||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
| task_members_task_id_foreign | BTREE | No | No | task_id | 0 | A | No | |
| task_members_employee_id_foreign | BTREE | No | No | employee_id | 0 | A | No |
users
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| name | varchar(191) | No | ||||
| varchar(191) | No | |||||
| password | varchar(191) | No | ||||
| remember_token | varchar(100) | Yes | NULL | |||
| created_at | timestamp | Yes | NULL | |||
| updated_at | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
| users_email_unique | BTREE | Yes | No | 0 | A | No |
user_password_resets
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| varchar(255) | No | |||||
| id (Primary) | int(11) | No | ||||
| token | text | No | ||||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
vendors
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| advocate_id | int(11) | No | ||||
| first_name | varchar(255) | Yes | NULL | |||
| middle_name | varchar(255) | Yes | NULL | |||
| last_name | varchar(255) | Yes | NULL | |||
| company_name | varchar(255) | Yes | NULL | |||
| varchar(255) | Yes | NULL | ||||
| mobile | varchar(255) | No | ||||
| alternate_no | varchar(255) | Yes | NULL | |||
| address | text | No | ||||
| country_id | int(11) | No | ||||
| state_id | int(11) | No | ||||
| city_id | int(11) | No | ||||
| gst | varchar(255) | Yes | NULL | |||
| pan | varchar(255) | Yes | NULL | |||
| is_active | enum('Yes', 'No') | No | Yes | |||
| created_at | timestamp | No | current_timestamp() | |||
| updated_at | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
zone
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| zone_id (Primary) | int(10) | No | ||||
| country_code | char(2) | No | ||||
| zone_name | varchar(35) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | zone_id | 425 | A | No | |
| idx_country_code | BTREE | No | No | country_code | 212 | A | No | |
| idx_zone_name | BTREE | No | No | zone_name | 425 | A | No |