laravel-enso
Tables (47)
action_logs
- id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → users.id — NOT NULL
- url — varchar(255) — NOT NULL
- route — varchar(255) — NOT NULL
- method — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
activity_logs
- id — int(10) — Primary key — NOT NULL
- model_class — varchar(255) — NOT NULL
- model_id — varchar(255) — NOT NULL
- event — tinyint(4) — NOT NULL
- meta — longtext
- created_by — int(10) — Foreign key → users.id
- created_at — timestamp
- updated_at — timestamp
addresses
- id — int(10) — Primary key — NOT NULL
- addressable_type — varchar(255) — NOT NULL
- addressable_id — bigint(20) — NOT NULL
- country_id — int(10) — Foreign key → countries.id — NOT NULL
- is_default — tinyint(1) — NOT NULL
- apartment — varchar(255)
- floor — varchar(255)
- entry — varchar(255)
- building — varchar(255)
- building_type — varchar(255)
- number — varchar(255)
- street — varchar(255)
- street_type — varchar(255)
- sub_administrative_area — varchar(255)
- city — varchar(255) — NOT NULL
- administrative_area — varchar(255)
- postal_area — varchar(255)
- obs — text
- lat — double(10,6)
- long — double(10,6)
- created_at — timestamp
- updated_at — timestamp
avatars
- id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → users.id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
comment_user
- user_id — int(10) — Primary key — NOT NULL
- comment_id — int(10) — Foreign key → comments.id — NOT NULL
comments
- id — int(10) — Primary key — NOT NULL
- commentable_type — varchar(255) — NOT NULL
- commentable_id — bigint(20) — NOT NULL
- body — text — NOT NULL
- created_by — int(10) — Foreign key → users.id
- updated_by — int(10)
- created_at — timestamp
- updated_at — timestamp
companies
- id — int(10) — Primary key — NOT NULL
- mandatary_id — int(10)
- name — varchar(255) — NOT NULL
- email — varchar(255)
- phone — varchar(255)
- fax — varchar(255)
- mandatary_position — varchar(255)
- bank — varchar(255)
- bank_account — varchar(255)
- obs — text
- pays_vat — varchar(255) — NOT NULL
- created_by — int(10) — Foreign key → users.id
- updated_by — int(10)
- created_at — timestamp
- updated_at — timestamp
contacts
- id — int(10) — Primary key — NOT NULL
- company_id — int(10) — Foreign key → companies.id — NOT NULL
- person_id — int(10) — NOT NULL
- position — varchar(255)
- created_at — timestamp
- updated_at — timestamp
countries
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- iso_3166_2 — varchar(2) — NOT NULL
- iso_3166_3 — varchar(3) — NOT NULL
- capital — varchar(255)
- citizenship — varchar(255)
- country_code — varchar(3)
- currency — varchar(255)
- currency_code — varchar(255)
- currency_sub_unit — varchar(255)
- currency_symbol — varchar(3)
- currency_decimals — int(11)
- full_name — varchar(255)
- region_code — varchar(3) — NOT NULL
- sub_region_code — varchar(3) — NOT NULL
- eea — tinyint(1) — NOT NULL
- calling_code — varchar(3)
- flag — varchar(6)
- created_at — timestamp
- updated_at — timestamp
data_exports
- id — int(10) — Primary key — NOT NULL
- created_at — timestamp
- updated_at — timestamp
data_imports
- id — int(10) — Primary key — NOT NULL
- type — varchar(255) — NOT NULL
- summary — longtext — NOT NULL
- created_at — timestamp
- updated_at — timestamp
discussion_replies
- id — int(10) — Primary key — NOT NULL
- discussion_id — int(10) — NOT NULL
- body — text — NOT NULL
- created_by — int(10) — Foreign key → users.id
- created_at — timestamp
- updated_at — timestamp
discussions
- id — int(10) — Primary key — NOT NULL
- discussable_type — varchar(255) — NOT NULL
- discussable_id — bigint(20) — NOT NULL
- title — varchar(255) — NOT NULL
- body — text — NOT NULL
- created_by — int(10) — Foreign key → users.id
- created_at — timestamp
- updated_at — timestamp
documents
- id — int(10) — Primary key — NOT NULL
- documentable_type — varchar(255) — NOT NULL
- documentable_id — bigint(20) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
examples
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- position — varchar(255) — NOT NULL
- seniority — int(11) — NOT NULL
- project — varchar(255) — NOT NULL
- salary — int(11) — NOT NULL
- taxes — decimal(6,2) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- hired_at — date — NOT NULL
- created_at — timestamp
- updated_at — timestamp
failed_jobs
- id — int(10) — Primary key — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
files
- id — int(10) — Primary key — NOT NULL
- attachable_type — varchar(255) — NOT NULL
- attachable_id — bigint(20) — NOT NULL
- original_name — varchar(255) — NOT NULL
- saved_name — varchar(255) — NOT NULL
- size — int(11) — NOT NULL
- mime_type — varchar(255)
- created_by — int(10) — Foreign key → users.id
- created_at — timestamp
- updated_at — timestamp
how_to_posters
- id — int(10) — Primary key — NOT NULL
- video_id — int(10) — Foreign key → how_to_videos.id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
how_to_tag_how_to_video
- how_to_video_id — int(10) — Primary key — NOT NULL
- how_to_tag_id — int(10) — Foreign key → how_to_tags.id — NOT NULL
how_to_tags
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
how_to_videos
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- description — text
- created_at — timestamp
- updated_at — timestamp
import_templates
- id — int(10) — Primary key — NOT NULL
- type — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
jobs
- id — bigint(20) — Primary key — NOT NULL
- queue — varchar(255) — NOT NULL
- payload — longtext — NOT NULL
- attempts — tinyint(3) — NOT NULL
- reserved_at — int(10)
- available_at — int(10) — NOT NULL
- created_at — int(10) — NOT NULL
languages
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- display_name — varchar(255) — NOT NULL
- flag — varchar(255) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
logins
- id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → users.id — NOT NULL
- ip — varchar(255) — NOT NULL
- user_agent — text — NOT NULL
- created_at — timestamp
- updated_at — timestamp
menus
- id — int(10) — Primary key — NOT NULL
- parent_id — int(10) — Foreign key → menus.id
- permission_id — int(10)
- name — varchar(255) — NOT NULL
- icon — varchar(255) — NOT NULL
- order_index — int(11) — NOT NULL
- has_children — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
migrations
- id — int(10) — Primary key — NOT NULL
- migration — varchar(255) — NOT NULL
- batch — int(11) — NOT NULL
notifications
- id — varchar(255) — Primary key — NOT NULL
- type — varchar(255) — NOT NULL
- notifiable_type — varchar(255) — NOT NULL
- notifiable_id — bigint(20) — NOT NULL
- data — text — NOT NULL
- read_at — timestamp
- created_at — timestamp
- updated_at — timestamp
password_resets
- email — varchar(255) — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
people
- id — int(10) — Primary key — NOT NULL
- title — tinyint(4)
- name — varchar(255) — NOT NULL
- appellative — varchar(255)
- uid — varchar(255)
- email — varchar(255)
- phone — varchar(255)
- birthday — date
- gender — tinyint(4)
- obs — text
- created_by — int(10) — Foreign key → users.id
- updated_by — int(10)
- created_at — timestamp
- updated_at — timestamp
permission_role
- role_id — int(10) — Primary key — NOT NULL
- permission_id — int(10) — Foreign key → permissions.id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
permissions
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(255)
- type — tinyint(4) — NOT NULL
- is_default — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
preferences
- id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → users.id — NOT NULL
- value — longtext — NOT NULL
- created_at — timestamp
- updated_at — timestamp
reactions
- id — int(10) — Primary key — NOT NULL
- reactable_type — varchar(255) — NOT NULL
- reactable_id — bigint(20) — NOT NULL
- type — tinyint(4) — NOT NULL
- created_by — int(10) — Foreign key → users.id
- created_at — timestamp
- updated_at — timestamp
role_user_group
- user_group_id — int(10) — Primary key — NOT NULL
- role_id — int(10) — Foreign key → roles.id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
roles
- id — int(10) — Primary key — NOT NULL
- menu_id — int(10) — Foreign key → menus.id
- name — varchar(255) — NOT NULL
- display_name — varchar(255) — NOT NULL
- description — varchar(255)
- created_at — timestamp
- updated_at — timestamp
sessions
- id — varchar(255) — NOT NULL
- user_id — int(11)
- ip_address — varchar(45)
- user_agent — text
- payload — text — NOT NULL
- last_activity — int(11) — NOT NULL
team_user
- user_id — int(10) — Primary key — NOT NULL
- team_id — int(10) — Foreign key → teams.id — NOT NULL
- created_at — timestamp
- updated_at — timestamp
teams
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
telescope_entries
- sequence — bigint(20) — Primary key — NOT NULL
- uuid — char(36) — NOT NULL
- batch_id — char(36) — NOT NULL
- family_hash — varchar(255)
- should_display_on_index — tinyint(1) — NOT NULL
- type — varchar(20) — NOT NULL
- content — text — NOT NULL
- created_at — datetime
telescope_entries_tags
- entry_uuid — char(36) — Foreign key → telescope_entries.uuid — NOT NULL
- tag — varchar(255) — NOT NULL
telescope_monitoring
- tag — varchar(255) — NOT NULL
tutorials
- id — int(10) — Primary key — NOT NULL
- permission_id — int(10) — Foreign key → permissions.id — NOT NULL
- element — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- placement — tinyint(4) — NOT NULL
- order_index — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
uploads
- id — int(10) — Primary key — NOT NULL
- created_at — timestamp
- updated_at — timestamp
user_groups
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(255)
- created_at — timestamp
- updated_at — timestamp
users
- id — int(10) — Primary key — NOT NULL
- person_id — int(10) — NOT NULL
- group_id — int(10) — NOT NULL
- role_id — int(10) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255)
- is_active — tinyint(1) — NOT NULL
- created_by — int(10) — Foreign key → users.id
- updated_by — int(10)
- remember_token — varchar(100)
- created_at — timestamp
- updated_at — timestamp
versionings
- id — int(10) — Primary key — NOT NULL
- versionable_type — varchar(255) — NOT NULL
- versionable_id — bigint(20) — NOT NULL
- version — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp