ilg - Laravel Schema Designer

clients

id increments
parent_id mediumInteger
type enum
name_en string (190)
name_ar string (190)
Identity_type enum
Identity_number string (255)
nationality string (190)
address text
country_code char (4)
phone_number string (20)
employee string (255)
employee_phone_number string (20)
email string (255)
nickname string (255)
bank string (255)
timestamps timestamps
softDeletes softDeletes
iban_number string (255)

client_attachments

id increments
client_id ^FK bigInteger
name string (255)
type string (255)
file string (255)
active boolean
timestamps timestamps

client_procedures

id increments
client_id ^FK bigInteger
type enum
statement text
decision_date date
timestamps timestamps

bank_accounts

id increments
account_number string (255)
account_name_en string (255)
account_name_ar string (255)
bank_id ^FK bigInteger
iban text
swift_number string (255)
address_en text
address_ar text
bank_address_en text
bank_address_ar string
currency_name string (255)
currency_code string (10)
minor_currency enum
timestamps timestamp

banks

id increments
name string (255)
timestamps timestamps

expense_types

id increments
name_en string (255)
name_ar string (255)
amount decimal (8,2)
type enum
timestamps timestamp

CaseType

id increments
name_en string (255)
name_ar string (255)

file_statuses

id increments
name_en string (255)
name_ar string (255)

basic_data

id increments
name_en string (255)
name_ar string (255)
amount decimal (8,2)
expense_type enum
type string (100)
timestamps timestamps

circulars

id increments
title string (255)
start_date date
end_date string
content text
timestamps timestamps

legal_cases

id increments
client_id ^FK bigInteger
case_type_id ^FK bigInteger
client_name string (255)
opponent_name string (255)
subject string (255)
case_reference_number string (255)
number_1 string (255)
number_2 string (255)
number_3 string (255)
date_of_receipt date
closing_date date
police_station_number integer
police_station_name string (255)
case_level enum
case_status_id ^FK bigInteger
floor smallInteger
courtroom string (255)
notification_status boolean
notes text
confidentiality_status boolean
timestamps timestamps

case_opponents

id increments
case_id ^FK bigInteger
name string (255)
id_number string (255)
code string (255)
home_address text
work_address text
country string (255)
nationality string (255)
home_phone string (255)
age smallInteger
job string (255)
email_address string
notes text
additional_notes text
work_phone string (255)
phone_number string (255)
timestamps timestamps
phone_number_2 string (255)
gender enum

case_guarantors

id increments
case_id ^FK bigInteger
name string (255)
Identity_type enum
Identity_number string (255)
nationality string
home_address text
work_address text
home_phone string (255)
work_phone string (255)
job string (255)
timestamps timestamps

case_attachments

id increments
timestamps timestamps

case_users

id increments
timestamps timestamps
case_id ^FK bigInteger
user_id ^FK bigInteger

case_levels

id increments
case_id ^FK bigInteger
decision_date date
session_date date
decision string (255)
timestamps timestamps

contracts

id increments
timestamps timestamps

under_study_cases

id increments
timestamps timestamps

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