BobbyStone - Laravel Schema Designer

app_card

id increments
name string (50)
type enum
cost integer
health integer
strength integer
picture string (100)
effect_id ^FK integer

app_card_effect

id increments
name string (50)
description string
player_affected enum
type enum
quantity integer

app_card_value

id increments
health integer
strength integer
can_attack boolean
card_id ^FK integer
user ^FK integer

app_user

id increments
password string (128)
last_login datetime
is_superuser boolean
username string (150)
first_name string (30)
last_name string (150)
email string (254)
is_staff boolean
is_active boolean
date_joined datetime

app_deck

id increments
name string (50)
user_id ^FK integer

app_deck_cards

id increments
deck_id ^FK integer
card_id ^FK integer

app_game

id increments
turn integer
owner_mana integer
opponent_mana integer
opponent_health integer
owner_health integer
opponent_id ^FK integer
opponent_deck_id ^FK integer
owner_id ^FK integer
owner_deck_id ^FK integer
player_turn_id ^FK integer
rule_id ^FK integer

app_rule

id increments
name string (50)
players_health integer
cards_in_deck integer
cards_to_begin integer
cards_to_draw integer

app_game_log

id increments
start_game datetime
end_game datetime
round_number integer
game_id ^FK integer
looser_id ^FK integer
winner_id ^FK integer

app_game_log_action

id increments
date datetime
turn integer
action string (50)
payload string
game_log_id ^FK integer
user_id ^FK integer

app_game_opponnent_board_card_values

id increments
game_id ^FK integer
cardvalue_id ^FK integer

app_game_opponent_deck_cards

id increments
game_id ^FK integer
card_id ^FK integer

app_game_opponent_graveyard_cards

id increments
game_id ^FK integer
card_id ^FK integer

app_game_opponent_hand_cards

id increments
game_id ^FK integer
card_id ^FK integer

app_game_owner_board_values

id increments
game_id ^FK integer
cardvalued_id ^FK integer

app_game_owner_deck_cards

id increments
game_id ^FK integer
card_id ^FK integer

app_game_owner_graveyard_cards

id increments
game_id ^FK integer
card_id ^FK integer

app_game_owner_hand_cards

id increments
game_id ^FK integer
card_id ^FK integer

app_user_groups

id increments
user_id ^FK integer
groupe_id ^FK integer

auth_group

id increments
name string (80)

auth_permission

id increments
content_type_id integer
codename string (100)
name string (255)

auth_group_permissions

id increments
groupe_id ^FK integer
permission_id ^FK integer

app_user_permission

id increments
user_id ^FK integer
permission_id ^FK integer

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