aqar_cloud - Laravel Schema Designer

estates

id increments
name_ar string
name_en string
type enum
status enum
sk_number string
address string
manage_ratio double
notes longText
city_id ^FK integer
estate_owner_id ^FK integer
estate_manager_id ^FK integer
timestamps timestamps

cities

id increments
name_ar string
name_en string
timestamps timestamps

users

id increments
name string
email string
phone string
activation_code string
user_type enum
market_ratio double
market_link string
market_balance double
timestamps timestamps

estate_manager

id increments
name string
phone string
email string
activation_code string
extra_messages integer
sub_date date
sub_status enum
reactivate_date date
inreactivate_date date
start_package_date date
end_package_date date
account_owner_name string
iban string
accept_terms_conditions boolean
bank_id ^FK integer
subtype_id ^FK integer
marketer_id ^FK integer
package_id ^FK integer
timestamps timestamps
user_type enum

sub_types

id increments
timestamps timestamps
name_ar string
name_en string
descr_ar longText
descr_en longText

packages

id increments
name_ar string
name_en string
descr_ar longText
descr_en longText
message_num integer
employee_num integer
estate_num integer
timestamps timestamps

units

id increments
descr_ar longText
descr_en longText
name string
estate_id ^FK integer
timestamps timestamps

contracts

id increments
start_rent_date date
end_rent_date date
due_date date
due_cycle enum
electricity_consum boolean
water_consum boolean
electricity_consum_cost integer
water_consum_cost integer
contract_num string
rent_refresh boolean
rent_amount integer
file_path string
estate_id ^FK integer
renter_id ^FK integer
unit_id ^FK integer
timestamps timestamps

banks

id increments
name_ar string
name_en string
timestamps timestamps

payment_methods

id increments
name_ar string
name_en string
timestamps timestamps
key string

invoices

id increments
type enum
required_cost double
paid_cost string
payment_method_id ^FK integer
estate_id ^FK integer
timestamps timestamps

services_requests

id increments
estate_id ^FK integer
unit_id ^FK integer
renter_id ^FK integer
service_provider_id ^FK integer
timestamps timestamps
ticket_status boolean
type enum
complain_text longText
service_date date
service_time time
periority enum
image string
address string
lat double
lng double

service_providers

id increments
timestamps timestamps
name string
phone string
email string
service_ratio double
service_id ^FK integer
city_id ^FK integer
default_provider boolean
user_type enum

services

id increments
timestamps timestamps
name_ar string
name_en string

static_pages

id increments
timestamps timestamps
key string
title_ar string
title_en string
contant_ar string
content_en string

questions

id increments
timestamps timestamps
queation_ar string
question_en string
answer_ar longText
answer_en longText

sub_type_features

id increments
timestamps timestamps
sub_type_id ^FK integer
name_ar string
name_en string

commnets

id increments
timestamps timestamps
user_id integer
user_type string
comment longText

contacts

id increments
timestamps timestamps
name string
email string
phone string
content string

settings

id increments
timestamps timestamps
about_ajar_ar longText
about_ajar_en longText
vision_ar longText
vision_en longText
goals_ar longText
goals_en longText
why_use_ajar_ar longText
why_use_ajar_en longText
descr_ar longText
descr_en longText
email string
phone string
owner_text_ar longText
owner_text_en longText
manager_text_ar longText
manager_text_en longText
renter_text_ar longText
renter_text_en longText
facebook string
twitter string
linkedin string
adv_1_title_ar string
adv_1_title_en string
adv_1_text_ar longText
adv_1_text_en longText
adv_2_tilte_ar string
adv_2_tilte_en string
adv_2_text_ar longText
adv_2_text_en longText
adv_3_tilte_ar string
adv_3_tilte_en string
adv_3_text_ar longText
adv_3_text_en longText
adv_4_title_ar string
adv_4_title_en string
adv_4_text_ar longText
adv_4_text_en longText
added_value_tax double
payment_gate_ratio double
rents_ratio double
services_ratio double
superadmin_ratio double

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