mlp_management-rights - Laravel Schema Designer

legal_cases

id increments
parent_id ^FK bigInteger
case_type enum
timestamps timestamps
softDeletes softDeletes

legal_case_mlr_info

id increments
legal_case_id ^FK bigInteger
body_corporate_consent_due_date datetime
body_corporate_consent_status string
body_corporate_consent_note string
buyer_letting_license_status string
buyer_letting_license_license_number string
buyer_letting_license_obtain_date datetime
buyer_letting_license_due_date datetime
letting_pool_count integer
total_lots integer
lots_in_letting_pool integer
timestamps timestamps
softDeletes softDeletes

legal_case_clients

id increments
legal_case_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

legal_case_agent

id increments
legal_case_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

legal_case_mlr_participants

id increments
legal_case_id ^FK bigInteger
type enum
role enum
license_number string
name string
email string
phone_number string
mobile_number string
fax string
address string
suburbs string
postal_code string
state string
timestamps timestamps
softDeletes softDeletes

mlr_financial

id increments
legal_case_id ^FK bigInteger
name string
email string
business_phone_number string
phone_number string
fax string
address string
suburbs string
postal_code string
state string
verification_duedate datetime
verification_period string
minimum_net_profit decimal (15,2)
unencumbered_equipment text
leased_equipment text
rental_agreement text
nominated_stocktake_date datetime
maximum_stock_valuation decimal (15,2)
purchase_price decimal (15,2)
purchase_deposit decimal (15,2)
purchase_balance decimal (15,2)
apportionment_purchase_plants decimal (15,2)
apportionment_purchase_furnitures decimal (15,2)
apportionment_purchase_chattels decimal (15,2)
apportionment_purchase_fixtures decimal (15,2)
apportionment_purchase_goodwill decimal (15,2)
apportionment_purchase_restrictive_covenant decimal (15,2)
timestamps timestamps
softDeletes softDeletes

mlr_compliance

id increments
legal_case_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes
current_payable_renumeration decimal (15,2)
renumeration_year_ending_date datetime
aggrement_document_lists string
prescribe_period string
restriction_area string
details string
completion_date datetime
completion_place string
lender_company string
approval_date datetime
loan_amount decimal (15,2)
contract_date datetime
seller_name string
buyer_name string
unit_description string
prior_to_completion string
after_completion string

mlr_special_condition

id increments
legal_case_id ^FK bigInteger
title string
priority string
status string
due_date datetime
description text
timestamps timestamps
softDeletes softDeletes

mlr_compliance_employee

id increments
mlr_compliance_id ^FK bigInteger
name string
period string
salary decimal (15,2)
timestamps timestamps
softDeletes softDeletes

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