ras - Laravel Schema Designer

doctors

id increments
timestamps timestamps
username string (200)
email string (150)
password string (200)
phone string (50)
alter_phone string (50)
code string (20)
governorate string (50)
active enum
remember_token string (120)

patients

id increments
timestamps timestamps
username string (200)
date_birth date
email string (200)
phone string (50)
hospital string (50)
address string (150)
doctorid ^FK integer
code string (10)
gender enum

tests

id increments
pikup_from string (20)
Code string (10)
date_Pickup date
comment text
patient_id ^FK integer
doctorid ^FK integer
adminid ^FK integer
courrier_id ^FK integer
lab_id ^FK integer
active enum
type enum
status enum
date_request date
timestamps timestamps
result_pdf string (200)

courriers

id increments
timestamps timestamps
username string (100)
email string (150)
phone string (50)
code string (10)
active enum
rate string (5)

labs

id increments
timestamps timestamps
name string (100)
address string (100)
phone string (50)
second_phone string (50)
time_dliver string (50)
code string (10)
active enum
rate string (5)

hospitals

id increments
timestamps timestamps
name string (100)
address string (150)
phone string (50)
second_phone string (50)
working_days string
work_start string (5)
work_end string (5)
doctorid ^FK integer
type enum

processes

id increments
timestamps timestamps
doctorid ^FK integer
patient_id ^FK integer
test_id ^FK integer
courrier_id ^FK integer
lab_id ^FK integer
code string (50)

admins

id increments
timestamps timestamps
username string (200)
email string (150)
password string (200)
phone string (50)
remember_token string (120)

super_admins

id increments
timestamps timestamps
username string (200)
email string (200)
password string (200)
phone string
remember_token string (120)

questions

id increments
timestamps timestamps
question string (200)

answers

id increments
timestamps timestamps
answer enum
questionid ^FK integer
doctorid ^FK integer

progress

id increments
timestamps timestamps
status enum
date date
test_id ^FK integer

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