iadapt - Laravel Schema Designer

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

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