Home
blood_bank
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
clients
id
increments
timestamps
timestamps
name
string
(255)
email
string
(255)
date_of_birth
date
phone
string
(11)
blood_type_id
FK
integer
password
string
(255)
last_donation
date
city_id
FK
integer
governorates
id
increments
timestamps
timestamps
name
string
(255)
cities
id
increments
timestamps
timestamps
name
string
(255)
governorate_id
FK
integer
donation_requests
id
increments
timestamps
timestamps
client_id
FK
integer
patient_name
string
(255)
patient_age
smallInteger
bags_number
smallInteger
hospital_name
string
(255)
hosiptal_latitude
decimal
(10,8)
hospital_longitude
decimal
(11,8)
city_id
FK
integer
phone
string
(11)
blood_type_id
FK
integer
notes
string
(255)
notifications
id
increments
timestamps
timestamps
client_id
FK
integer
donation_request_id
FK
integer
title
string
(255)
content
string
(255)
contacts
id
increments
timestamps
timestamps
title
string
(255)
conent
text
email
string
(255)
name
string
(255)
phone
string
(11)
blood_type
id
increments
timestamps
timestamps
name
string
(255)
blood_client
id
increments
blood_type_id
FK
integer
client_id
FK
integer
city_client
id
increments
city_id
FK
integer
client_id
FK
integer
settings
id
increments
timestamps
timestamps
phone
string
(11)
email
string
(255)
facebook_url
string
(255)
twitter_url
string
(255)
youtube_url
string
(255)
instagram_url
string
(255)
whatsapp_url
string
(255)
google_url
string
(255)
about
mediumText
android_app_url
string
(255)
ios_app_url
string
(255)
articles
id
increments
timestamps
timestamps
title
string
(255)
image_url
string
(255)
description
string
(255)
content
mediumText
categories
id
increments
timestamps
timestamps
name
string
(255)
article_category
id
increments
article_id
FK
integer
category_id
FK
integer
article_client
id
increments
article_id
FK
integer
client_id
FK
integer
client_notification
id
increments
timestamps
timestamps
client_id
FK
integer
notification_id
FK
integer
is_read
boolean
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01