redbin - Laravel Schema Designer

warehouses

id increments
service_area_id integer
name string (200)
internal_name string (200)
address_1 string (200)
address_2 string (200)
city string (200)
state string (200)
postal_code string (20)
country_id integer
timestamps timestamps

orders

id increments
service_area_id integer
customer_id integer
number integer
type enum
dropoff_date date
dropoff_address integer
dropoff_timeslot integer
pickup_date date
pickup_address integer
pickup_timeslot integer
cancel_reason enum
cancelled_at datetime
financial_status enum
source string (200)
notes text
timestamps timestamps
softDeletes softDeletes

users

timestamps timestamps

customers

id increments
user_id integer
service_area_id integer
billing_provider_customer_id string (100)
billing_started_at date
billing_day integer
timestamps timestamps
softDeletes softDeletes

order_items

id increments
order_id integer
storable_id increments
quantity integer
customer_storable_id integer
timestamps timestamps
softDeletes softDeletes

service_areas

id increments
country_id integer
name string (100)
currency_code string (3)
is_user_visible boolean
timestamps timestamps

customer_storables

id increments
warehouse_id integer
customer_id integer
storable_id integer
bin_id integer
price float
status enum
notes text
timestamps timestamps

neighborhoods

id increments
name string (200)
service_area_id integer
sales_tax_rate decimal
taxable_shipping boolean
timestamps timestamps

neighborhood_postal_codes

id increments
neighborhood_id integer
postal_code string (30)

neighborhood_warehouses

id increments
neighborhood_id integer
warehouse_id integer

storables

id increments
service_area_id integer
is_bin boolean
name string (200)
description text
external_length decimal
external_width decimal
external_height decimal
internal_length decimal
internal_width decimal
internal_height decimal
price float
is_taxable boolean
prepaid_month_count integer
storage_method enum
timestamps timestamps

bins

id increments
storable_id integer
customer_id integer
code string (32)
birth_date datetime
death_date datetime
timestamps timestamps

customer_storable_logs

id increments
customer_storable_id integer
user_id integer
action enum
message text
timestamps timestamps

customer_bin_items

id increments
customer_storable_id integer
name string (200)
description text
image_id integer
timestamps timestamps

images

id increments
filename string (200)
filesize integer
width integer
type string (200)
height string
variations text
timestamps timestamps

discount_codes

id increments
service_area_id integer
code string (32)
type enum
is_recurring boolean
amount float
timestamps timestamps
softDeletes softDeletes

fulfillments

id increments
service_area_id integer
order_id integer
order_item_id integer
customer_storable_id integer
dropoff_date date
dropoff_address integer
dropoff_timeslot integer
pickup_date date
pickup_address integer
pickup_timeslot integer
status enum
timestamps timestamps
softDeletes softDeletes

fulfillment_events

id increments
fulfillment_id integer
type enum
timestamps timestamps
softDeletes softDeletes

addresses

id increments
name string (200)
company string (200)
address_1 string (200)
address_2 string (200)
city string (200)
state string (200)
postal_code string (50)
country_id integer
timestamps timestamps

customer_addresses

id increments
customer_id integer
address_id string

customer_storable_images

id increments
customer_storable_id integer
image_id integer
timestamps timestamps

vehicles

id increments
service_area_id integer
name string (200)
registration_number string (15)
timestamps timestamps

vehicle_roles

id increments
slug string
name string (200)
description text
timestamps timestamps

vehicle_vehicle_roles

id increments
vehicle_id integer
vehicle_role_id integer

invoices

id increments
customer_id integer
number integer
order_id integer
discount_code_id integer
total_items_price float
subtotal_price float
total_discounts float
delivery_fee float
total_tax float
total_price float
status enum
payment_attempts integer
due_at date
timestamps timestamps
softDeletes softDeletes

employees

id increments
user_id integer
timestamps timestamps
softDeletes softDeletes

employee_service_areas

id increments
employee_id integer
service_area_id integer

employee_jobs

id increments
name string (200)
slug string (200)
timestamps timestamps

employee_employee_jobs

id increments
employee_id integer
employee_job_id integer

invoice_items

id increments
invoice_id integer
customer_storable_id integer
billing_cycle_start date
billing_cycle_end date
billing_cycle_count integer
price float
total float
is_prorated boolean
timestamps timestamps
softDeletes softDeletes

invoice_transactions

id increments
invoice_id integer
billing_provider_transaction_id string (50)
type enum
amount float
status enum
timestamps timestamps
softDeletes softDeletes

delivery_timeslots

id increments
neighborhood_id integer
day enum
start_at time
end_at time
timestamps timestamps

delivery_assignments

id increments
employee_id integer
date date
driving_timeslot_id integer
vehicle_id integer
timestamps timestamps
softDeletes softDeletes

customer_payment_methods

id increments
customer_id integer
address_id integer
billing_provider_token string (50)
card_type string (25)
cardholder_name string (175)
masked_number string (50)
expiration_date integer
issuing_bank string (100)
prepaid tinyInteger
expired tinyInteger
is_default boolean
timestamps timestamps
softDeletes softDeletes

settings

id increments
service_area_id integer
key string (100)
value text
timestamps timestamps

delivery_blackouts

id increments
service_area_id integer
neighborhood_id integer
name string (100)
start_at date
end_at date
timestamps timestamps

notification_templates

id increments
name string (100)
slug string (100)
email text
sms string (200)
push string (100)
timestamps timestamps

user_devices

id increments
name string (100)
platform enum
push_token text
timestamps timestamps