atar - Laravel Schema Designer

rf_communities

id increments
name string (191)
country_id ^FK integer
currency_id ^FK integer
district_id ^FK integer
city_id ^FK integer
map json
is_active boolean
created_by bigInteger
updated_by bigInteger
softDeletes softDeletes
timestamps timestamps

districts

id increments
timestamps timestamps
softDeletes softDeletes

cities

id increments
timestamps timestamps
softDeletes softDeletes

currencies

id increments
name_ar string (250)
name_en string (250)
code string (5)
is_active boolean
timestamps timestamps
softDeletes softDeletes

rf_buildings

id increments
name string (191)
rf_community_id ^FK integer
no_floors integer
year_build date
map json
is_active boolean
created_by bigInteger
updated_by bigInteger
softDeletes softDeletes
timestamps timestamps

files

id increments
timestamps timestamps
softDeletes softDeletes

rf_units

id increments
name string (191)
category_id ^FK integer
type_id ^FK integer
rf_community_id ^FK integer
rf_building_id ^FK integer
year_build date
map json
tenant_id bigInteger
owner_id bigInteger
views bigInteger
status_id integer
is_active boolean
is_buy boolean
is_market_place boolean
created_by bigInteger
updated_by bigInteger
timestamps timestamps
softDeletes softDeletes

rf_specifications

id increments
name_ar string (191)
name_en string (191)
type string (191)
icon string (191)
parent_id ^FK bigInteger
input_details json
is_active boolean
timestamps timestamps

rf_unit_areas

id increments
name_ar string (191)
name_en string (191)
value decimal (12,2)
rf_unit_id ^FK integer
timestamps timestamps
softDeletes softDeletes

countries

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

rf_specification_unit

id increments
rf_unit_id ^FK bigInteger
rf_specification_id ^FK integer
value string (191)
timestamps timestamps

rf_unit_rooms

id increments
name_ar string (191)
name_en string (191)
value integer
rf_unit_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

rf_unit_marketplaces

id increments
type enum
amount_type enum
price decimal (12,2)
tax_rate float
deposite decimal (12,2)
rf_unit_id ^FK bigInteger
booking_status_id integer
timestamps timestamps
softDeletes softDeletes

rf_leases

id increments
start_date date
end_date date
handover_date date
tenant_type enum
rf_user_id bigInteger
contract_number string (191)
deal_owner_id bigInteger
rental_type enum
rental_total_amount double (10.2)
fit_out_status_id ^FK bigInteger
payment_schedule_id ^FK bigInteger
lease_escalations_type_id ^FK bigInteger
security_deposit_amount float (11.2)
security_deposit_due_date float (8.11)
terms_conditions text
status_id bigInteger
is_sub_lease boolean
is_terms boolean
source string (191)
updated_by bigInteger
created_by bigInteger
timestamps timestamps
softDeletes softDeletes

rf_companies

id increments
user_id bigInteger
name_ar string (150)
name_en string (150)
commercial_registration_no integer
tax_identifier_no string
address string (150)
website string
source string
is_active boolean
timestamps timestamps
softDeletes softDeletes

rf_lease_escalations

id increments
type enum
start_date date
end_date date
amount double (10.2)
percentage string
rf_lease_id ^FK bigInteger
timestamps timestamps

rf_sub_leases

id increments
rf_lease_id ^FK bigInteger
tenant_type enum
name_ar string (150)
name_en string (150)
registration_no string
tax_identifier_no string
note text
timestamps timestamps
softDeletes softDeletes

rf_lease_unit

id increments
rf_unit_id ^FK bigInteger
rf_lease_id ^FK bigInteger
rental_annual_type enum
annual_rental_amount double (10.2)
property_history json
timestamps timestamps

rf_lease_specifications

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

rf_additional_fees

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

rf_additional_fees_lease

id increments
rf_lease_id ^FK bigInteger
rf_additional_fees ^FK bigInteger
calculation_basis_id ^FK bigInteger
payment_frequency_id ^FK bigInteger
value double (10,2)
timestamps timestamps
softDeletes softDeletes

rf_company_user

id increments
user_id ^FK bigInteger
rf_company_id ^FK bigInteger
timestamps timestamps

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