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