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
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

sub_types

id increments
timestamps timestamps

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 integer
timestamps timestamps

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