Database Schema Documentation

Table: `addresses`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`title`	`varchar(255)`	No	`None`
`location`	`text`	No	`None`
`tel`	`varchar(255)`	Yes	`None`
`fax`	`varchar(255)`	Yes	`None`
`email`	`varchar(255)`	Yes	`None`
`postal_code`	`varchar(255)`	Yes	`None`
`status`	`varchar(255)`	Yes	`None`
`step`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `articles`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`category_id`	`bigint(20) unsigned`	Yes	`None`
`slug`	`varchar(255)`	No	`None`
`title`	`text`	No	`None`
`image`	`varchar(2048)`	Yes	`None`
`summary`	`text`	Yes	`None`
`description`	`text`	No	`None`
`attached_file_name`	`varchar(255)`	Yes	`None`
`attached_file`	`varchar(2048)`	Yes	`None`
`tags`	`varchar(255)`	No	`None`
`status`	`varchar(255)`	Yes	`None`
`step`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `categories`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`slug`	`varchar(255)`	No	`None`
`name`	`varchar(255)`	No	`None`
`description`	`text`	Yes	`None`
`categoryable_type`	`varchar(255)`	Yes	`None`
`status`	`tinyint(4)`	No	`0`
`step`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `companies`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`logo`	`varchar(2048)`	No	`None`
`title`	`text`	No	`None`
`priority`	`tinyint(4)`	Yes	`None`
`url`	`varchar(255)`	No	`None`
`nofollow`	`tinyint(4)`	No	`0`
`status`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `contact_requests`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`name`	`varchar(255)`	No	`None`
`mobile`	`varchar(255)`	No	`None`
`email`	`varchar(255)`	Yes	`None`
`title`	`varchar(255)`	No	`None`
`description`	`text`	No	`None`
`seen`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `contact_us`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`tel`	`varchar(255)`	No	`None`
`fax`	`varchar(255)`	No	`None`
`email`	`varchar(255)`	No	`None`
`address`	`text`	No	`None`
`map_src`	`text`	No	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `events`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`category_id`	`bigint(20) unsigned`	Yes	`None`
`slug`	`varchar(255)`	No	`None`
`title`	`varchar(255)`	No	`None`
`image`	`varchar(2048)`	Yes	`None`
`summary`	`text`	Yes	`None`
`description`	`text`	No	`None`
`tags`	`varchar(255)`	No	`None`
`status`	`varchar(255)`	Yes	`None`
`step`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `failed_jobs`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`uuid`	`varchar(255)`	No	`None`
`connection`	`text`	No	`None`
`queue`	`text`	No	`None`
`payload`	`longtext`	No	`None`
`exception`	`longtext`	No	`None`
`failed_at`	`timestamp`	No	`current_timestamp()`

Table: `features`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`title`	`varchar(255)`	No	`None`
`image`	`varchar(2048)`	Yes	`None`
`description`	`longtext`	No	`None`
`status`	`tinyint(4)`	No	`0`
`step`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `general_settings`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`title`	`varchar(255)`	No	`None`
`mobile`	`varchar(255)`	No	`None`
`email`	`varchar(255)`	No	`None`
`description`	`text`	No	`None`
`keywords`	`text`	No	`None`
`logo`	`text`	No	`None`
`icon`	`text`	No	`None`
`catalogue_url`	`text`	Yes	`None`
`catalogue_file`	`varchar(2048)`	Yes	`None`
`virtual_tour_url`	`varchar(255)`	Yes	`None`
`update_mode`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `home_settings`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`intro_video`	`text`	No	`None`
`copyright`	`varchar(255)`	No	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `honors`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`category_id`	`bigint(20) unsigned`	Yes	`None`
`slug`	`varchar(255)`	No	`None`
`title`	`text`	No	`None`
`image`	`varchar(2048)`	Yes	`None`
`summary`	`text`	Yes	`None`
`description`	`text`	No	`None`
`attached_file_name`	`varchar(255)`	Yes	`None`
`attached_file`	`varchar(2048)`	Yes	`None`
`tags`	`text`	No	`None`
`status`	`varchar(255)`	Yes	`None`
`step`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `links`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`name`	`varchar(255)`	No	`None`
`url`	`varchar(255)`	No	`None`
`priority`	`tinyint(4)`	Yes	`None`
`nofollow`	`tinyint(4)`	No	`0`
`status`	`varchar(255)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `menus`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`parent_id`	`bigint(20) unsigned`	Yes	`None`
`url`	`varchar(255)`	No	`None`
`name`	`varchar(255)`	No	`None`
`priority`	`tinyint(4)`	Yes	`None`
`nofollow`	`tinyint(4)`	No	`0`
`status`	`varchar(255)`	Yes	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `migrations`

Column	Type	Nullable	Default
`id`	`int(10) unsigned`	No	`None`
`migration`	`varchar(255)`	No	`None`
`batch`	`int(11)`	No	`None`

Table: `news`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`category_id`	`bigint(20) unsigned`	Yes	`None`
`slug`	`varchar(255)`	No	`None`
`title`	`text`	No	`None`
`image`	`varchar(2048)`	Yes	`None`
`summary`	`text`	Yes	`None`
`description`	`text`	No	`None`
`attached_file_name`	`varchar(255)`	Yes	`None`
`attached_file`	`varchar(2048)`	Yes	`None`
`tags`	`text`	No	`None`
`status`	`varchar(255)`	Yes	`None`
`step`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `order_files`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`user_id`	`bigint(20) unsigned`	No	`None`
`order_id`	`bigint(20) unsigned`	No	`None`
`file_path`	`varchar(2048)`	Yes	`None`
`file_size`	`bigint(20)`	No	`None`
`file_type`	`varchar(255)`	No	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `order_product_attribute_value`

Column	Type	Nullable	Default
`order_id`	`bigint(20) unsigned`	No	`None`
`product_attribute_value_id`	`bigint(20) unsigned`	No	`None`

Table: `orders`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`user_id`	`bigint(20) unsigned`	No	`None`
`product_id`	`bigint(20) unsigned`	No	`None`
`name`	`varchar(255)`	No	`None`
`mobile`	`varchar(255)`	No	`None`
`amount`	`varchar(255)`	No	`None`
`seen`	`tinyint(4)`	No	`0`
`status`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `otps`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`token`	`varchar(255)`	No	`None`
`user_id`	`bigint(20) unsigned`	No	`None`
`otp_code`	`varchar(255)`	No	`None`
`login_id`	`varchar(255)`	No	`None`
`type`	`tinyint(1)`	No	`0`
`used`	`tinyint(1)`	No	`0`
`status`	`tinyint(1)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

🔗 Relationships:

Column	References
`user_id`	`users(id)`

Table: `pages`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`slug`	`varchar(255)`	No	`None`
`title`	`varchar(255)`	No	`None`
`banner`	`varchar(2048)`	Yes	`None`
`summary`	`text`	Yes	`None`
`body`	`text`	No	`None`
`tags`	`text`	No	`None`
`status`	`varchar(255)`	Yes	`None`
`step`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `password_reset_tokens`

Column	Type	Nullable	Default
`email`	`varchar(255)`	No	`None`
`token`	`varchar(255)`	No	`None`
`created_at`	`timestamp`	Yes	`None`

Table: `permission_role`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`permission_id`	`bigint(20) unsigned`	No	`None`
`role_id`	`bigint(20) unsigned`	No	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `permission_user`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`permission_id`	`bigint(20) unsigned`	No	`None`
`user_id`	`bigint(20) unsigned`	No	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `permissions`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`name`	`varchar(50)`	No	`None`
`slug`	`varchar(255)`	No	`None`
`resource`	`varchar(20)`	No	`System`
`system`	`tinyint(1)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `personal_access_tokens`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`tokenable_type`	`varchar(255)`	No	`None`
`tokenable_id`	`bigint(20) unsigned`	No	`None`
`name`	`varchar(255)`	No	`None`
`token`	`varchar(64)`	No	`None`
`abilities`	`text`	Yes	`None`
`last_used_at`	`timestamp`	Yes	`None`
`expires_at`	`timestamp`	Yes	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `product_attribute_values`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`product_id`	`bigint(20) unsigned`	Yes	`None`
`product_attribute_id`	`bigint(20) unsigned`	No	`None`
`value`	`text`	No	`None`
`selectable`	`tinyint(4)`	No	`0`
`status`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `product_attributes`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`name`	`varchar(255)`	No	`None`
`unit`	`varchar(255)`	Yes	`None`
`selectable`	`tinyint(4)`	No	`0`
`status`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `products`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`slug`	`varchar(255)`	No	`None`
`title`	`text`	No	`None`
`image`	`varchar(2048)`	Yes	`None`
`back_image`	`varchar(2048)`	Yes	`None`
`summary`	`text`	Yes	`None`
`description`	`text`	No	`None`
`features`	`longtext`	Yes	`None`
`tags`	`text`	No	`None`
`status`	`tinyint(4)`	No	`0`
`step`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `ratings`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`user_id`	`bigint(20) unsigned`	Yes	`None`
`rating`	`varchar(255)`	No	`None`
`description`	`text`	Yes	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

🔗 Relationships:

Column	References
`user_id`	`users(id)`

Table: `role_user`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`role_id`	`bigint(20) unsigned`	No	`None`
`user_id`	`bigint(20) unsigned`	No	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `roles`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`name`	`varchar(255)`	No	`None`
`slug`	`varchar(255)`	No	`None`
`description`	`text`	Yes	`None`
`system`	`tinyint(1)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `sessions`

Column	Type	Nullable	Default
`id`	`varchar(255)`	No	`None`
`user_id`	`bigint(20) unsigned`	Yes	`None`
`ip_address`	`varchar(45)`	Yes	`None`
`user_agent`	`text`	Yes	`None`
`payload`	`longtext`	No	`None`
`last_activity`	`int(11)`	No	`None`

Table: `sliders`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`title`	`varchar(255)`	Yes	`None`
`image`	`varchar(2048)`	No	`None`
`url`	`varchar(255)`	Yes	`None`
`description`	`varchar(255)`	Yes	`None`
`status`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `social_media`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`title`	`varchar(255)`	No	`None`
`icon`	`varchar(255)`	Yes	`None`
`url`	`varchar(255)`	No	`None`
`nofollow`	`tinyint(4)`	No	`0`
`status`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `steps`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`user_id`	`bigint(20) unsigned`	No	`None`
`stepable_id`	`bigint(20) unsigned`	No	`None`
`stepable_type`	`varchar(255)`	No	`None`
`value`	`varchar(255)`	No	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `ticket_files`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`ticket_id`	`bigint(20) unsigned`	No	`None`
`file_path`	`text`	No	`None`
`file_size`	`bigint(20)`	No	`None`
`file_type`	`varchar(255)`	No	`None`
`status`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `tickets`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`sender_id`	`bigint(20) unsigned`	No	`None`
`receiver_id`	`bigint(20) unsigned`	Yes	`None`
`parent_id`	`bigint(20) unsigned`	Yes	`None`
`subject`	`varchar(255)`	Yes	`None`
`description`	`text`	No	`None`
`seen`	`tinyint(4)`	No	`0`
`status`	`tinyint(4)`	No	`0`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `users`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`name`	`varchar(255)`	Yes	`None`
`username`	`varchar(255)`	Yes	`None`
`email`	`varchar(255)`	Yes	`None`
`email_verified_at`	`timestamp`	Yes	`None`
`mobile`	`varchar(255)`	Yes	`None`
`mobile_verified_at`	`timestamp`	Yes	`None`
`profile_photo_path`	`varchar(2048)`	Yes	`None`
`password`	`varchar(255)`	Yes	`None`
`two_factor_secret`	`text`	Yes	`None`
`two_factor_recovery_codes`	`text`	Yes	`None`
`two_factor_confirmed_at`	`timestamp`	Yes	`None`
`user_type`	`tinyint(4)`	Yes	`1`
`status`	`tinyint(4)`	Yes	`1`
`current_team_id`	`bigint(20) unsigned`	Yes	`None`
`remember_token`	`varchar(100)`	Yes	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `videos`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`slug`	`varchar(255)`	No	`None`
`title`	`varchar(255)`	No	`None`
`thumbnail`	`varchar(2048)`	No	`None`
`video`	`varchar(2048)`	No	`None`
`summary`	`text`	Yes	`None`
`description`	`text`	No	`None`
`tags`	`varchar(255)`	No	`None`
`status`	`varchar(255)`	No	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`

Table: `views`

Column	Type	Nullable	Default
`id`	`bigint(20) unsigned`	No	`None`
`user_id`	`bigint(20) unsigned`	Yes	`None`
`viewable_id`	`bigint(20) unsigned`	No	`None`
`viewable_type`	`varchar(255)`	No	`None`
`user_ip`	`varchar(255)`	No	`None`
`created_at`	`timestamp`	Yes	`None`
`updated_at`	`timestamp`	Yes	`None`