Home
iadapt
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users_details
id
increments
timestamps
timestamps
softDeletes
softDeletes
fname
string
(50)
lname
string
(50)
sex
string
(10)
bday
date
phone
string
(11)
fk_entity_details
integer
fk_farm_details
integer
fk_user_id
integer
entity_details
id
increments
timestamps
timestamps
softDeletes
softDeletes
entity_name
string
(255)
nature_of_entity
string
(255)
business_permit_no
string
(255)
region
string
(100)
province
string
(100)
city
string
(100)
brgy
string
(100)
long
string
(255)
lat
string
(255)
fk_users_details_id
integer
demands
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_users_acc_id
integer
fk_crops_id
integer
qty
float
proposed_delivery_date
datetime
status
tinyInteger
tracking_number
string
(7)
fk_consolidated_demands_id
integer
bids
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_consolidated_demands_id
integer
fk_users_acc_id
integer
status
tinyInteger
fk_planting_plan
integer
qty
float
(10,2)
fk_batch_bids_id
integer
amount_receivable
string
fk_planting_plan_id
integer
crops
id
increments
timestamps
timestamps
name
string
(255)
qty
float
unit
string
(50)
class
string
(10)
seasonality
string
(255)
crop_type
string
(50)
fk_crop_pricing_id
FK
integer
fk_crop_production_id
integer
fk_varieties_id
integer
fk_crop_classes_id
integer
marketing_agreement_logs
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_demands_id
tinyInteger
status
tinyInteger
supply_agreement_logs
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_bids_id
integer
status
tinyInteger
crop_records
id
increments
timestamps
timestamps
seed_provider
string
(100)
fk_crop_id
FK
integer
farm_size
float
(10,2)
no_of_hills
integer
varieties
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_crop_id
integer
variety_name
string
(255)
crop_pricing
id
increments
timestamps
timestamps
softDeletes
softDeletes
fgp
float
(10,2)
srp
float
(10,2)
consolidated_demands
id
increments
timestamps
timestamps
softDeletes
softDeletes
total_amount_fgp
float
(10,2)
total_amount_srp
float
(10,2)
consolidated_demands_control_number
string
(255)
total_remaining_qty
float
(10,2)
fk_crops_id
integer
status
string
(15)
tracking_number
string
(11)
class
string
(255)
proposed_delivery_date
date
delivery_address
id
increments
timestamps
timestamps
softDeletes
softDeletes
region
string
(255)
city
string
(255)
brgy
string
(255)
landmark_description
string
(255)
fk_demands_id
integer
crop_production
id
increments
timestamps
timestamps
fk_crop_id
integer
dr
float
(10,2)
dh
float
(10,2)
maturity_from
integer
maturity_to
integer
harvesting
string
(255)
qty_hills
bigInteger
farm_details
id
increments
timestamps
timestamps
softDeletes
softDeletes
farm_name
string
(255)
farm_size
float
(10,2)
region
string
(100)
province
string
(100)
city
string
(100)
brgy
string
(100)
long
string
(100)
lat
string
(100)
fk_users_details_id
integer
crop_classes
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_crop_id
integer
name
string
(10)
checked_out_demands
id
increments
timestamps
timestamps
softDeletes
softDeletes
total_amount
float
(10,2)
dellivery_method
string
fk_demands_id
integer
fk_batch_tracking_number
string
(255)
batch_checked_out
id
increments
timestamps
timestamps
softDeletes
softDeletes
batch_tracking_number
string
(255)
planting_plan
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_consolidated_demands_id
integer
fk_bids_id
integer
farm_size
float
(10,2)
no_of_hills
float
fk_planting_plan_photos
integer
sowing_date
date
transplanting_date
date
status
string
seed_provider
string
(255)
batch_bids
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_users_acc_id
integer
batch_tracking_number
string
(255)
total_amount_receivable
float
(10,2)
planting_plan_images
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_planting_plan_id
integer
filename
longText
crop_production_harvesting_model
id
increments
timestamps
timestamps
softDeletes
softDeletes
fk_crops_id
integer
week_no
integer
value
double
×
Comments for iadapt
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01