E-clinic - Laravel Schema Designer

DOCTORS

ID increments
PRICE double
DISCOUNT_NEXT_INTERVIEW double
CV binary
STAFF_ID ^FK integer

LABORATORIES

ID increments
CV binary
STAFF_ID ^FK integer

PATIENTS

ID bigIncrements
FIRST_NAME string (32)
LAST_NAME string (32)
PHONE string (32)
ADDRESS string (255)
PHOTO binary
EMAIL string (60)
PASSWORD string (60)
IS_ACTIVATED tinyInteger
remember_token string (100)

BOOKINGS

ID bigIncrements
DOCTOR_ID ^FK integer
PATIENT_ID ^FK bigInteger
TOTAL_PRICE double
FEE_PAYMENT_STATUS integer
RANDOM_TEXT string (5)
BOOKING_DATE string (20)
BOOKING_STATUS integer
ARRANGEMENT integer

MEDICALS_RECORDS

ID bigIncrements
DOCTOR_ID ^FK integer
PATIENT_ID ^FK bigInteger
SYMPTOMS_OF_PATIENT text
MEDICAL_RECORD_DATE string (20)
NEXT_INTERVIEW integer
NEXT_INTERVIEW_DATE string (20)
NOTES string (255)

NAMES_OF_ANALYZES

ID increments
ANALYSIS_NAME string (60)
NOTES string (255)
LABORATORY_ID ^FK integer

NAMES_OF_TREATMENTS

ID increments
TREATMENT_NAME string (60)
NOTES string (255)
DOCTOR_ID ^FK integer

REQUIRED_ANALYZES

id bigIncrements
ANALYSIS_ID ^FK integer
ANALYSIS_RESULT text
ANALYSIS_DATE string (20)
MEDICAL_RECORD_ID ^FK bigInteger
LABORATORY_ID ^FK integer
ANALYSIS_COMPLETED integer
VIEW_DR integer
VIEW_PATIENT integer

REQUIRED_TREATMENTS

ID bigIncrements
TREATMENT_ID ^FK integer
MEDICAL_RECORD_ID ^FK bigInteger

TYPES_OF_DISEASES

ID increments
Disease_NAME string (60)
NOTES string (255)
DOCTOR_ID ^FK integer

PERIODS_WORKS_DR

ID bigIncrements
WORK_DAY integer
FROM_HOUR integer
TO_HOUR integer
DOCTOR_ID ^FK integer

POSITIVE_DISEASES

ID bigIncrements
DISEASE_ID ^FK integer
MEDICAL_RECORD_ID ^FK bigInteger

STAFF

ID increments
FIRST_NAME string (32)
LAST_NAME string (32)
PHONE string (32)
ADDRESS string (255)
PHOTO binary
EMAIL string (60)
ROLE integer
USER_NAME string (32)
PASSWORD string (60)
remember_token string (100)

PATIENTS_ACTIVATION

ID increments
TOKEN string (191)
PATIENT_ID ^FK bigInteger

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