subscriptions - Laravel Schema Designer

user

id increments
timestamps timestamps
softDeletes softDeletes
country_id ^FK integer
name string
login string
userid string (8)
partner_id ^FK integer

country

id increments
name string
short string (2)

subscription

id increments
timestamps timestamps
softDeletes softDeletes
subtype_id ^FK integer
platform_id ^FK integer
country_id ^FK integer
user_id ^FK integer
active boolean
type enum

subtype

id increments
name string
properties text

platform

id increments
name string
properties text

transaction

id increments
timestamps timestamps
softDeletes softDeletes
subscription_id ^FK integer
subtype_id ^FK integer
ipcountry_id ^FK integer
sum float
type enum
ip string

session

id increments
login_id ^FK integer
realm string
cam integer
start integer
end integer

login

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
ipcountry_id ^FK integer
ip string

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