azaapidb - Laravel Schema Designer

users

id increments
timestamps timestamps
phone string
code integer
active tinyInteger
password string

profiles

id increments
timestamps timestamps
user_id ^FK integer
lastname string (255)
firstname string (255)
email string
link string
status boolean
dob date

lotteries

id increments
timestamps timestamps
name string
status boolean

results

timestamps timestamps
tirage_id ^FK integer
id increments
number integer
win1 integer
win2 integer
lotto4 integer
lotto5 string

tickets

id increments
timestamps timestamps
user_id ^FK integer
lottery_id ^FK integer
numticket integer
date datetime
status boolean
paycheck boolean
wincheck boolean
winamount string
price float

numbers

id increments
timestamps timestamps
ticket_id ^FK integer
tirage_id ^FK integer
date date
number string

ticketDetails

id increments
timestamps timestamps
ticket_id integer
price float
number integer
game_id integer
option integer

games

id increments
timestamps timestamps
label string
status boolean

tirages

id increments
timestamps timestamps
lottery_id ^FK integer
draw boolean
date datetime

limits

id increments
timestamps timestamps
tirage_id ^FK integer
limit integer
date date
game_id ^FK integer

blockednumber

id increments
timestamps timestamps
tirage_id ^FK integer
number integer
game_id ^FK integer

historyLimits

id increments
timestamps timestamps
limit_id ^FK integer
date datetime
limit integer
tirage_id integer
game_id integer

ticket_content

id increments
timestamps timestamps
tirage_id ^FK integer
price string
number string
option string
game_id ^FK integer

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