smart_farm - Laravel Schema Designer

users

timestamps timestamps
softDeletes softDeletes
id increments
title string
email string
firstname string
lastname string
password string
phone string
address jsonb
other_info jsonb
role string

farms

id increments
reg_id string
name string
owner_name string
milk_tank_no jsonb
member_place string
vet_id integer
phone string
address jsonb
location string
timestamps timestamps
softDeletes softDeletes

cows

id increments
farm_id integer
cow_no string
cow_rfid string
name string
breed_id integer
birth_date date
cow_father_no string
cow_mother_no string
cow_district string
picture json
cow_status string
timestamps timestamps
previous_reg_no string
softDeletes softDeletes

vaccine

vaccine_id increments
timestamps timestamps
vaccine_name string
vaccine_schedule string
vaccine_period string

cow_vaccine

cow_id integer
vaccine_id integer

antibiotic

antibiotic_id increments
timestamps timestamps
softDeletes softDeletes
antibiotic_notification boolean
antibiotic_name string
cow_id integer
antibiotic_status boolean

cow_healths

id increments
created_at datetime
softDeletes softDeletes
topic string
detail text
use_antibiotic boolean

farm_milk_centers

farm_id integer
milk_center_id integer

milk_centers

id increments
timestamps timestamps
name string

cow_milking

id increments
cow_id integer
created_at datetime
morning_milk_amount float
evening_milk_amount float

cow_cmts

id increments
created_at datetime
front_left char (1)
front_right char (1)
rear_left char (1)
rear_right char (1)

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