atarcloudTenant - Laravel Schema Designer

users

id increments
first_name string (191)
last_name string (191)
phone_number string (20)
locale string (5)
country_code string (5)
email string (191)
timestamps timestamps
softDeletes softDeletes
address string (191)
national_id string (191)
privacy_policy_accepted_at datetime
last_login_at datetime
is_active boolean
gender enum
profile_image string (191)
invited boolean
profile_type string (191)
record_classification string (191)
creation_source string (191)
creation_date datetime
comapp_id string (191)
maximo_id string (191)
crm_id string (191)
birthdate datetime

communities

id increments
name_ar string (191)
name_en string (191)
is_active boolean
district_id integer
timestamps timestamps
softDeletes softDeletes

buildings

id increments
name string (191)
model_type string (191)
model_id integer
is_active boolean
year_built date
timestamps timestamps
softDeletes softDeletes

units

id increments
name string (191)
category_id ^FK integer
sub_category_id ^FK integer
status_id smallInteger
is_active boolean
model_type string (191)
model_id integer
owner_id ^FK integer
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

cities

id increments
name_ar string (191)
name_en string (191)
is_active boolean
country_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

districts

id increments
name_ar string (191)
name_en string (191)
is_active boolean
city_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

countries

id increments
name_ar string (191)
name_en string (191)
is_active boolean
timestamps timestamps
softDeletes softDeletes

files

id increments
model_type string (191)
model_id integer
path string (191)
tag string (191)
file_name string (191)
notes string (191)
order smallInteger
is_active boolean
timestamps timestamps
softDeletes softDeletes

categories

id increments
name_ar string (191)
name_en string (191)
status boolean
parent_id integer
image string (191)
type tinyInteger
timestamps timestamps
softDeletes softDeletes

pages

id increments
name_ar string (191)
name_en string (191)
description_ar text
description_en text
is_active boolean
type tinyInteger
model_type string (191)
timestamps timestamps
softDeletes softDeletes

locations

id increments
lat string (191)
lng string (191)
is_active boolean
map string
model_id bigInteger
model_type string (191)
timestamps timestamps
softDeletes softDeletes

directories

id increments
phone_number string (15)
logo string (191)
is_active boolean
category_id integer
entity_name string (191)
representative_name string (191)
email string (191)
timestamps timestamps
softDeletes softDeletes

suggestions

id increments
initiator_id ^FK integer
title string (191)
description text
timestamps timestamps
softDeletes softDeletes

statuses

id increments
name_ar string (191)
name_en string (191)
is_active boolean
type string (30)
timestamps timestamps
softDeletes softDeletes

settings

id increments
key string (191)
value string (191)
is_active boolean
type string (191)
timestamps timestamps
softDeletes softDeletes

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01