Home
Texas
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
bigIncrements
client_id
FK
bigInteger
name
string
(299)
email
string
(299)
user_name
string
(299)
password
string
(299)
pin
string
(299)
status
tinyInteger
verification_status
tinyInteger
profile_pic
string
(299)
security_question_id
FK
integer
security_question_answer
string
(299)
role_id
FK
bigInteger
timestamps
timestamps
roles
id
bigIncrements
role
string
(299)
client_id
FK
bigInteger
added_by
bigInteger
role_visibility
tinyInteger
timestamps
timestamps
seurity_questions
id
increments
question_status
tinyInteger
question
string
(299)
timestamps
timestamps
password_resets
id
bigIncrements
user_id
FK
bigInteger
reqest_type
tinyInteger
email
string
(299)
ip_address
string
(299)
token
string
(299)
timestamps
timestamps
permissions
id
bigIncrements
name
string
(299)
display_name
string
(299)
description
text
visibility_status
tinyInteger
module_id
FK
integer
timestamps
timestamps
permission_used
id
bigIncrements
permission_id
FK
bigInteger
role_id
FK
bigInteger
timestamps
timestamps
clients
id
bigIncrements
client_name
string
(299)
key_hash
string
(299)
domain_name
string
(299)
url_authenticate
text
prefix
string
(299)
currency_id
FK
integer
deposit_limit
double
(50)
withdraw_limit
double
invoice_generation_date_id
FK
integer
client_category_id
FK
bigInteger
allow_print
tinyInteger
maximum_downline
integer
status
tinyInteger
timestamps
timestamps
currencies
id
increments
name
string
(100)
code
string
(10)
symbol
string
(10)
timestamps
timestamps
invoice_generation_dates
id
increments
value
string
(299)
timestamps
timestamps
client_categories
id
bigIncrements
category
string
(299)
timestamps
timestamps
IP_white_lists
id
bigIncrements
user_id
FK
bigInteger
client_id
bigInteger
ip
string
(50)
timestamps
timestamps
contact_persons
id
bigIncrements
client_id
FK
bigInteger
position_id
FK
integer
line
string
(299)
skype
string
(299)
wechat
string
(299)
whatsapp
string
(299)
bbm
string
(299)
nohp
string
(299)
email
string
(299)
timestamps
timestamps
game_masters
id
bigIncrements
game_id
bigInteger
game_category_id
FK
bigInteger
game_provider_id
FK
bigInteger
game_type_id
FK
bigInteger
game_code
string
(299)
game_name
string
(299)
game_icon
string
(299)
status
tinyInteger
timestamps
timestamps
game_category
id
bigIncrements
category
string
(299)
timestamps
timestamps
company_positions
id
increments
position
text
status
tinyInteger
timestamps
timestamps
password_change_history
id
increments
request_id
bigInteger
reset_type
string
(500)
user_id
FK
bigInteger
requested_ip
string
(50)
request_status
tinyInteger
requested_date
datetime
processed_date
datetime
timestamps
timestamps
oauth_secret_token
id
increments
user_id
FK
bigInteger
hash_key
text
timestamps
timestamps
operators
id
bigIncrements
user_id
FK
bigInteger
client_id
FK
bigInteger
level
integer
status
tinyInteger
timestamps
timestamps
players
id
bigIncrements
user_id
FK
bigInteger
process_state
tinyInteger
player_verified
tinyInteger
telephone
bigInteger
game_session_token
string
(299)
referred_by
bigInteger
depost_count
bigInteger
game_token
string
(299)
gt_created_at
datetime
timestamps
timestamps
master_banks
id
bigIncrements
bank_name
string
(299)
bank_link
text
isvisible
tinyInteger
alternative_link
text
logo
string
(299)
order
integer
timestamps
timestamps
rejection_notes
id
increments
user_id
bigInteger
note
text
timestamps
timestamps
permission_modules
id
increments
name
string
(299)
timestamps
timestamps
available_bank_groups
id
bigIncrements
group_name
string
(299)
description
string
(299)
status
tinyInteger
timestamps
timestamps
client_bank_account
id
bigIncrements
client_id
FK
bigInteger
master_bank_id
FK
bigInteger
available_bank_group_id
FK
bigInteger
account_name
string
(299)
account_number
string
(299)
status
tinyInteger
visibility_status
tinyInteger
added_by
bigInteger
timestamps
timestamps
bank_group_config
id
increments
client_id
FK
bigInteger
available_bank_group_id
FK
bigInteger
x_deposit
integer
limit
bigInteger
master_bank_id
FK
bigInteger
timestamps
timestamps
master_bank_visibilities
id
increments
client_id
FK
bigInteger
master_bank_id
FK
bigInteger
bank_status
tinyInteger
home_visibility_status
tinyInteger
alternative_bank
FK
bigInteger
timestamps
timestamps
transactions
id
increments
user_id
FK
bigInteger
client_id
FK
bigInteger
transaction_type_id
FK
integer
amount
double
request_status
tinyInteger
verified_by
FK
bigInteger
timestamps
timestamps
client_bank_account_id
FK
bigInteger
game_providers
id
bigIncrements
provider_name
string
(299)
timestamps
timestamps
game_types
id
bigIncrements
game_type
string
(299)
timestamps
timestamps
player_bank_accounts
id
increments
user_id
FK
bigInteger
default
tinyInteger
nickname
string
(299)
master_bank_id
FK
bigInteger
bank_account_number
string
(20)
verification_status
tinyInteger
current_bank_group_id
FK
bigInteger
timestamps
timestamps
blogs
id
bigIncrements
status
tinyInteger
added_by
FK
bigInteger
client_id
FK
bigInteger
slug
string
(299)
title
text
summery
text
content
text
featured_image
string
(299)
timestamps
timestamps
transaction_types
id
increments
type
string
(299)
timestamps
timestamps
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01