Home
E-clinic
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for E-clinic
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01