Medical insurance - Laravel Schema Designer

insureds

id integer
number integer
name string
gender string
birthdate string
national_number integer
address_id ^FK bigInteger

insurance_contracts

id integer
number integer
date date
end_date date
cost float
cost_type string
insured_id ^FK bigInteger

doctors

id integer
name string
gender string
phone integer
specialization_id ^FK bigInteger
address_id ^FK bigInteger

visits

id integer
number integer
date date
type string
insured_id ^FK bigInteger
contract_id ^FK bigInteger
doctor_id ^FK bigInteger

specializations

id integer
name string

diagnoses

visit_id ^FK bigInteger
content string

medical_services

id integer
name string
capacity float

contract_service

contract_id ^FK bigInteger
medical_service_id ^FK bigInteger

visit_medicine

id integer
visit_id ^FK bigInteger
medicine_name string
quantity integer

rejection

id integer
visit_id ^FK bigInteger
content string

addresses

id integer
city string
area string
street string

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