travel

Tables (12)

admins

  • id — bigint(20) — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • folder — varchar(255)
  • avatar — varchar(255)
  • email_verified_at — timestamp
  • password — varchar(255) — NOT NULL
  • status — tinyint(4) — NOT NULL
  • role_id — bigint(20) — NOT NULL
  • remember_token — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp

failed_jobs

  • id — bigint(20) — 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

migrations

  • id — int(10) — Primary key — NOT NULL
  • migration — varchar(255) — NOT NULL
  • batch — int(11) — NOT NULL

model_has_permissions

  • model_id — bigint(20) — Primary key — NOT NULL
  • model_type — varchar(255) — Primary key — NOT NULL
  • permission_id — bigint(20) — Foreign key → permissions.id — NOT NULL

model_has_roles

  • model_id — bigint(20) — Primary key — NOT NULL
  • model_type — varchar(255) — Primary key — NOT NULL
  • role_id — bigint(20) — Foreign key → roles.id — NOT NULL

password_resets

  • email — varchar(255) — NOT NULL
  • token — varchar(255) — NOT NULL
  • created_at — timestamp

permissions

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • guard_name — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

product_categories

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)
  • slug — varchar(255)
  • image — varchar(255) — NOT NULL
  • status (staus) — tinyint(4) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

products

  • id — bigint(20) — Primary key — NOT NULL
  • category_id — bigint(20) — Foreign key → product_categories.id — NOT NULL
  • name — varchar(255)
  • slug — varchar(255)
  • image — varchar(255) — NOT NULL
  • image_details — text — NOT NULL
  • describe — text — NOT NULL
  • created_at — timestamp
  • updated_ad — timestamp

role_has_permissions

  • role_id — bigint(20) — Primary key — NOT NULL
  • permission_id — bigint(20) — Foreign key → permissions.id — NOT NULL

roles

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • guard_name — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

users

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • email_verified_at — timestamp
  • password — varchar(255) — NOT NULL
  • remember_token — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp