Full Schema
Tables / Fields
account_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
accounts
| Field name | Type |
|---|
| test_color | varchar(255) |
| test_checkbox | tinyint(1) |
| name | varchar(255) |
| first_name | varchar(255) |
| last_name | varchar(255) |
| email | varchar(255) |
| phone | varchar(255) |
| fax | varchar(255) |
| website | varchar(255) |
| address | varchar(255) |
| city | varchar(255) |
| zip | varchar(255) |
| state | int(11) |
| country | int(11) |
| description | varchar(255) |
| status | int(11) |
| assigned_to | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
accounts_cases
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| accounts_id | int(10) unsigned |
| cases_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| accounts_id | int(10) unsigned |
| contacts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
accounts_contracts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| accounts_id | int(10) unsigned |
| contracts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
accounts_invoices
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| accounts_id | int(10) unsigned |
| invoices_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
accounts_invoices_users
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| accounts_id | int(10) unsigned |
| invoices_id | int(10) unsigned |
| users_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
accounts_meetings
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| accounts_id | int(10) unsigned |
| meetings_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
accounts_opportunities
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| accounts_id | int(10) unsigned |
| opportunities_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
campaign_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
campaign_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
campaigns
| Field name | Type |
|---|
| name | varchar(255) |
| description | varchar(255) |
| assigned_to | int(11) |
| status | int(11) |
| budget | double |
| forecast | double |
| actual | double |
| impressions | int(11) |
| currency | int(11) |
| campaign_type | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
campaigns_accounts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| campaigns_id | int(10) unsigned |
| accounts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
campaigns_tasks
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| campaigns_id | int(10) unsigned |
| tasks_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
case_priorities
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
case_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
case_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
cases
| Field name | Type |
|---|
| subject | varchar(255) |
| description | varchar(255) |
| assigned_to | int(11) |
| case_number | int(11) |
| status | int(11) |
| priority | int(11) |
| type | int(11) |
| resolution | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
| Field name | Type |
|---|
| first_name | varchar(255) |
| last_name | varchar(255) |
| email | varchar(255) |
| phone | varchar(255) |
| fax | varchar(255) |
| website | varchar(255) |
| address | varchar(255) |
| city | varchar(255) |
| state | int(11) |
| zip | varchar(255) |
| country | int(11) |
| description | varchar(255) |
| status | int(11) |
| email_receive | tinyint(1) |
| assigned_to | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
contract_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
contract_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
contracts
| Field name | Type |
|---|
| name | varchar(255) |
| description | varchar(255) |
| discount | double |
| taxes | double |
| shipping | double |
| subtotal | double |
| total | double |
| currency | int(11) |
| signed_by | int(11) |
| assigned_to | int(11) |
| contract_type | int(11) |
| start_date | int(11) |
| end_date | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
contracts_lineitems
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| contracts_id | int(10) unsigned |
| lineitems_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
countries
| Field name | Type |
|---|
| code | varchar(255) |
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
currency
| Field name | Type |
|---|
| name | varchar(255) |
| code | varchar(255) |
| symbol | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
datalet_types
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| name | varchar(255) |
| created_at | timestamp |
| updated_at | timestamp |
datalets
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| name | varchar(255) |
| label | varchar(255) |
| type | int(11) |
| role_id | int(11) |
| field_id | int(11) |
| module_id | int(11) |
| relationship_id | int(11) |
| size | int(11) |
| display_order | int(11) |
| active | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
discount_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
document_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
document_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
documents
| Field name | Type |
|---|
| name | varchar(255) |
| description | varchar(255) |
| assigned_to | int(11) |
| file_link | varchar(255) |
| document_type | int(11) |
| document_status | int(11) |
| expire_date | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
documents_accounts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| documents_id | int(10) unsigned |
| accounts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
documents_cases
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| documents_id | int(10) unsigned |
| cases_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
documents_contracts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| documents_id | int(10) unsigned |
| contracts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
documents_meetings
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| documents_id | int(10) unsigned |
| meetings_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
documents_opportunities
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| documents_id | int(10) unsigned |
| opportunities_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
documents_tasks
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| documents_id | int(10) unsigned |
| tasks_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
documents_users
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| documents_id | int(10) unsigned |
| users_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
failed_jobs
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| uuid | varchar(255) |
| connection | text |
| queue | text |
| payload | longtext |
| exception | longtext |
| failed_at | timestamp |
fields
| Field name | Type |
|---|
| name | varchar(255) |
| label | varchar(255) |
| module_id | int(11) |
| validation | varchar(255) |
| input_type | varchar(255) |
| data_type | varchar(100) |
| field_length | int(11) |
| required | int(11) |
| is_nullable | tinyint(4) |
| default_value | varchar(255) |
| read_only | tinyint(4) |
| disabled | tinyint(4) |
| related_module_id | int(11) |
| related_field_id | varchar(255) |
| related_value_id | varchar(255) |
| decimal_places | int(11) |
| status | tinyint(4) |
| id | bigint(20) unsigned |
| created_at | timestamp |
| updated_at | timestamp |
group_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
groups
| Field name | Type |
|---|
| name | varchar(255) |
| description | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
groups_accounts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| groups_id | int(10) unsigned |
| accounts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| created_at | timestamp |
| updated_at | timestamp |
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| name | varchar(128) |
| mask | varchar(128) |
| created_at | timestamp |
| updated_at | timestamp |
invoice_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
invoices
| Field name | Type |
|---|
| name | varchar(255) |
| description | varchar(255) |
| assigned_to | int(11) |
| status | int(11) |
| currency | int(11) |
| amount | double |
| tax | double |
| total | double |
| subtotal | double |
| discount | double |
| billing_address | varchar(255) |
| billing_city | varchar(255) |
| billing_zip | varchar(255) |
| billing_state | int(11) |
| billing_country | int(11) |
| shipping_address | varchar(255) |
| shipping_city | varchar(255) |
| shipping_zip | varchar(255) |
| shipping_state | int(11) |
| shipping_country | int(11) |
| sign_date | int(11) |
| expire_date | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
lead_sources
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
lead_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
lead_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
leads
| Field name | Type |
|---|
| first_name | varchar(255) |
| last_name | varchar(255) |
| email | varchar(255) |
| phone | varchar(255) |
| fax | varchar(255) |
| website | varchar(255) |
| address | varchar(255) |
| city | varchar(255) |
| state | int(11) |
| zip | varchar(255) |
| country | int(11) |
| description | varchar(255) |
| status | int(11) |
| email_receive | tinyint(1) |
| assigned_to | int(11) |
| lead_type | int(11) |
| lead_source | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
leads_accounts_opportunities
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| leads_id | int(10) unsigned |
| accounts_id | int(10) unsigned |
| opportunities_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
lineitems
| Field name | Type |
|---|
| product_id | int(11) |
| quantity | int(11) |
| price | double |
| unit_price | double |
| cost | double |
| discount | double |
| discount_type | int(11) |
| taxes | double |
| gross | double |
| net | double |
| description | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
logs
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| module_id | int(11) |
| type | varchar(16) |
| message | varchar(200) |
| user_id | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
meeting_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
meeting_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
meetings
| Field name | Type |
|---|
| name | varchar(255) |
| description | varchar(255) |
| start_date | int(11) |
| end_date | int(11) |
| start_time | int(11) |
| end_time | int(11) |
| reminder_time | int(11) |
| location | varchar(255) |
| phone | varchar(255) |
| link | varchar(255) |
| meeting_password | varchar(255) |
| types | int(11) |
| status | int(11) |
| assigned_to | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
migrations
| Field name | Type |
|---|
| id | int(10) unsigned |
| migration | varchar(255) |
| batch | int(11) |
module_convertables
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| primary_module_id | int(11) |
| module_id | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
module_groups
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| name | varchar(255) |
| label | varchar(255) |
| view_order | int(11) |
module_subpanels
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| subpanel_filter | varchar(255) |
| name | varchar(255) |
| label | varchar(255) |
| module_id | varchar(255) |
| list_size | int(11) |
| list_order_column | varchar(255) |
| list_order | varchar(255) |
| relationship_id | int(11) |
| status | int(11) |
| saved_search_id | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
modules
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| name | varchar(100) |
| label | varchar(255) |
| description | varchar(255) |
| status | int(11) |
| faker_seed | int(11) |
| create_table | int(11) |
| view_order | int(11) |
| admin | int(11) |
| parent_id | int(11) |
| primary | int(11) |
| icon | varchar(128) |
| module_group_id | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
modules_datalets
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| modules_id | int(10) unsigned |
| datalets_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
modules_fields
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| modules_id | int(10) unsigned |
| fields_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
modules_subpanels
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| modules_id | int(10) unsigned |
| module_subpanels_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
notes
| Field name | Type |
|---|
| subject | varchar(255) |
| description | varchar(255) |
| assigned_to | int(11) |
| file_location | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
notes_accounts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| notes_id | int(10) unsigned |
| accounts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
notes_cases
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| documents_id | int(10) unsigned |
| cases_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
notes_contracts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| notes_id | int(10) unsigned |
| contracts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
notes_meetings
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| notes_id | int(10) unsigned |
| meetings_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
notes_opportunities
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| notes_id | int(10) unsigned |
| opportunities_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
notes_tasks
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| notes_id | int(10) unsigned |
| tasks_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
notes_users
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| notes_id | int(10) unsigned |
| users_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
opportunities
| Field name | Type |
|---|
| name | varchar(255) |
| assigned_to | int(11) |
| type | int(11) |
| amount | double |
| probability | int(11) |
| close_date | int(11) |
| status | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
opportunities_cases
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| opportunities_id | int(10) unsigned |
| cases_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| accounts_id | int(10) unsigned |
| opportunities_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
opportunities_contracts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| opportunities_id | int(10) unsigned |
| contracts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
opportunities_meetings
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| opportunities_id | int(10) unsigned |
| meetings_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
opportunities_quotes
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| opportunities_id | int(10) unsigned |
| quotes_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
opportunities_quotes_accounts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| opportunities_id | int(10) unsigned |
| quotes_id | int(10) unsigned |
| accounts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
opportunity_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
opportunity_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
orders
| Field name | Type |
|---|
| first_name | varchar(255) |
| last_name | varchar(255) |
| email | varchar(255) |
| phone | varchar(255) |
| status | int(11) |
| currency | int(11) |
| amount | double |
| tax | double |
| total | double |
| subtotal | double |
| discount | double |
| billing_address | varchar(255) |
| billing_city | varchar(255) |
| billing_zip | varchar(255) |
| billing_state | int(11) |
| billing_country | int(11) |
| shipping_address | varchar(255) |
| shipping_city | varchar(255) |
| shipping_zip | varchar(255) |
| shipping_state | int(11) |
| shipping_country | int(11) |
| product | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
password_resets
| Field name | Type |
|---|
| email | varchar(255) |
| token | varchar(255) |
| created_at | timestamp |
permissions
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| module_id | int(11) |
| role_id | int(11) |
| can_read | int(11) |
| can_write | int(11) |
| can_delete | int(11) |
| can_export | int(11) |
| can_import | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
personal_access_tokens
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| tokenable_type | varchar(255) |
| tokenable_id | bigint(20) unsigned |
| name | varchar(255) |
| token | varchar(64) |
| abilities | text |
| last_used_at | timestamp |
| created_at | timestamp |
| updated_at | timestamp |
products
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
project_priorities
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
project_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
project_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
projects
| Field name | Type |
|---|
| name | varchar(255) |
| description | varchar(255) |
| assigned_to | int(11) |
| status | int(11) |
| priority | int(11) |
| type | int(11) |
| start_date | int(11) |
| end_date | int(11) |
| due_date | int(11) |
| completed_date | int(11) |
| estimated_hours | int(11) |
| actual_hours | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
projects_accounts
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| projects_id | int(10) unsigned |
| accounts_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
projects_tasks
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| projects_id | int(10) unsigned |
| tasks_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
quote_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
quotes
| Field name | Type |
|---|
| name | varchar(255) |
| description | varchar(255) |
| assigned_to | int(11) |
| status | int(11) |
| currency | int(11) |
| amount | double |
| tax | double |
| total | double |
| subtotal | double |
| discount | double |
| billing_address | varchar(255) |
| billing_city | varchar(255) |
| billing_zip | varchar(255) |
| billing_state | int(11) |
| billing_country | int(11) |
| shipping_address | varchar(255) |
| shipping_city | varchar(255) |
| shipping_zip | varchar(255) |
| shipping_state | int(11) |
| shipping_country | int(11) |
| expire_date | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
relationship_modules
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| module_id | int(11) |
| relationship_id | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
relationships
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| name | varchar(255) |
| modules | varchar(255) |
| related_field_types | varchar(255) |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
roles
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
settings
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| name | varchar(255) |
| value | varchar(255) |
| created_at | timestamp |
| updated_at | timestamp |
states
| Field name | Type |
|---|
| code | varchar(255) |
| abbreviation | varchar(255) |
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
subpanel_fields
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| field_id | int(11) |
| subpanel_id | int(11) |
| label | varchar(255) |
| created_at | timestamp |
| updated_at | timestamp |
task_priorities
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
task_status
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
task_types
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
tasks
| Field name | Type |
|---|
| subject | varchar(255) |
| description | varchar(255) |
| assigned_to | int(11) |
| task_types | int(11) |
| status | int(11) |
| task_priority | int(11) |
| due_date | int(11) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
themes
| Field name | Type |
|---|
| name | varchar(255) |
| id | bigint(20) unsigned |
| slug | varchar(64) |
| soft_delete | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
user_meetings
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| users_id | int(10) unsigned |
| meetings_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
users
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| name | varchar(255) |
| email | varchar(255) |
| email_verified_at | timestamp |
| password | varchar(255) |
| role_id | int(11) |
| slug | varchar(255) |
| remember_token | varchar(100) |
| created_at | timestamp |
| updated_at | timestamp |
users_tasks
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| users_id | int(10) unsigned |
| tasks_id | int(10) unsigned |
| status | int(11) |
| created_at | timestamp |
| updated_at | timestamp |
workflow_actions
| Field name | Type |
|---|
| id | bigint(20) unsigned |
| name | varchar(255) |
| created_at | timestamp |
| updated_at | timestamp |