payments - Laravel Schema Designer

customers

id increments
name string
timestamps timestamps

orders

id increments
customer_id ^FK bigInteger
subscription_id ^FK bigInteger
next_payment_at datetime
amount bigInteger
timestamps timestamps

subscriptions

id increments
start_at datetime
end_at datetime
timestamps timestamps
frequency bigInteger

order_items

id increments
order_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
price bigInteger
timestamps timestamps

products

id increments
price bigInteger
timestamps timestamps

payments

id increments
payment_type_id ^FK bigInteger
order_id ^FK bigInteger
amount bigInteger
timestamps timestamps

payment_statistics

id increments
payment_id ^FK bigInteger
customer_id ^FK bigInteger
order_id ^FK bigInteger
subscription_id ^FK bigInteger
payment_type_id ^FK bigInteger
product_id ^FK bigInteger
quantity integer
amount bigInteger
timestamps timestamps

payment_type

id increments
name string
timestamps timestamps

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