festival - Laravel Schema Designer

users

id increments
cell_number string (20)
cell_operator enum
operator_type enum
status string (10)
name string (300)
timestamps timestamps
softDeletes softDeletes

categories

id increments
parent_id ^FK integer
title string (500)
content string (5000)
image string (50)
activate boolean
timestamps timestamps
softDeletes softDeletes

credits

id increments
user_id ^FK integer
game_id ^FK integer
status enum
amount float (500)
stock float
description string (5000)
timestamps timestamps
softDeletes softDeletes

games

id increments
category_id ^FK integer
question string (255)
levelA integer
levelB integer
attached ^FK integer
timestamps timestamps
softDeletes softDeletes

devices

id increments
device_code string (50)
mac string (30)
cell_number string (20)
manufacturer string (100)
os string (50)
version string (50)
model string (100)
imei string (255)
app_version string (255)
ip string (50)
token string (100)
previous_header_token string (100)
user_id integer
verified boolean
timestamps timestamps
softDeletes softDeletes

device_logs

id increments
param1 text
param2 text
param3 text
param4 text
param5 text
timestamps timestamps
softDeletes softDeletes

entities

id increments
title string (500)
caption string (500)
timestamps timestamps
softDeletes softDeletes

files

id increments
path string (1000)
extentions string (1000)
hash string (3000)
original_name string (1000)
size integer
user_id ^FK integer
entity_type ^FK integer
entity_id integer
timestamps timestamps
softDeletes softDeletes

firewall

id increments
ip_address string (50)
whitelisted tinyInteger
timestamps timestamps
softDeletes softDeletes

hit_logs

id increments
url string (255)
url_specific_param string (255)
ip string (255)
user_agent string (255)
session_id string (255)
entity_type ^FK integer
entity_id integer
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes

invoices

id increments
action_id ^FK integer
amount string (100)
otp string (1000)
ip string (20)
status enum
timestamps timestamps
softDeletes softDeletes

log_accesses

id increments
user_id ^FK integer
controller string (100)
action string (255)
ip_address string (20)
url string (2000)
description string (1000)
content string (4000)
timestamps timestamps
softDeletes softDeletes

log_errors

id increments
user_id ^FK integer
ip string (20)
url string (2000)
message text
stack text
timestamps timestamps
softDeletes softDeletes

roles

id increments
user_id ^FK integer
title string (255)
caption string (255)
timestamps timestamps
softDeletes softDeletes

sms_items

id increments
user_id ^FK integer
receiver_id ^FK integer
message string (1000)
extra_numbers string (255)
sender string (30)
scheduled_time timestamp
status enum
return_id bigInteger
delivery_code integer
timestamps timestamps
softDeletes softDeletes

users_roles

id increments
user_id ^FK integer
role_id ^FK integer
timestamps timestamps
softDeletes softDeletes

verify_numbers

id increments
cell_number string (11)
verification_code string (50)
token string (100)
timestamps timestamps
softDeletes softDeletes

actions

id increments
game_id ^FK integer
user_id ^FK integer
answer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

games_answers

id increments
value string (300)
game_id ^FK integer
is_answer tinyInteger
timestamps timestamps
softDeletes softDeletes

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