wonderlive - Laravel Schema Designer

users

id bigIncrements
nickname string (100)
email string (150)
email_verified_at timestamp
password string
provider_id string (50)
provider_name string (50)
is_public boolean
locale_id ^FK bigInteger
timestamps timestamps

password_resets

id uuid
email string
token string
timestamps timestamps

personal_access_tokens

id bigIncrements
tokenable morphs
name string
token string (64)
abilities text
last_used_at timestamp
expires_at timestamp
timestamps timestamps

user_push_notifications

id bigIncrements
live boolean
auction boolean
call boolean
activity boolean
user_id ^FK bigInteger
timestamps timestamps

user_informations

id bigIncrements
first_name string (50)
last_name string (50)
cover string (150)
avatar string (150)
biography text
category_id ^FK bigInteger
mobile string (50)
birthday date
country string (50)
association_refund boolean
association_name string (50)
association_url string (150)
user_id ^FK bigInteger
timestamps timestamps

user_blacklists

id bigIncrements
message boolean
event boolean
blacklist_user_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

user_follows

id bigIncrements
user_follow_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

user_certifications

id bigIncrements
call_is_free boolean
call_pricing float
category_id ^FK bigInteger
is_active boolean
user_id bigInteger
user_certification_request_id ^FK bigInteger
timestamps timestamps

user_certification_requests

id bigIncrements
file string (150)
category_id ^FK bigInteger
fist_url string (150)
second_url string (150)
in_progress boolean
additional_information text
is_accepted boolean
is_refused boolean
reason_for_refusal text
user_id ^FK bigInteger
timestamps timestamps

admin_certification_history

id bigIncrements
action string (100)
user_certification_id ^FK bigInteger
user_certification_request_id ^FK bigInteger
admin_id ^FK bigInteger
timestamps timestamps

model_has_permissions

permission_id ^FK bigInteger
model_type string (255)
model_id bigInteger

permissions

id increments
name string
guard_name string
timestamps timestamps

roles

id increments
name string
guard_name string
timestamps timestamps

role_has_permissions

permission_id ^FK bigInteger
role_id ^FK bigInteger

model_has_roles

role_id ^FK bigInteger
model_type string (255)
model_id bigInteger

user_favorites

id bigIncrements
user_profil_id ^FK bigInteger
post_id ^FK bigInteger
live_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

user_threads

id bigIncrements
subject string (100)
user_id ^FK bigInteger
timestamps timestamps

admin_reports

id bigIncrements
category string (100)
message text
user_message_id ^FK bigInteger
user_review_id ^FK bigInteger
user_profil_id ^FK bigInteger
post_comment_id ^FK bigInteger
post_id ^FK bigInteger
live_id ^FK bigInteger
call_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

posts

id bigIncrements
biography text
is_draft boolean
is_comment_activated boolean
is_like_activated boolean
publication_at datetime
type enum
user_id ^FK bigInteger
timestamps timestamps

post_comments

id bigIncrements
message text
post_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

post_photos

id bigIncrements
name string (150)
post_id ^FK bigInteger
timestamps timestamps

post_videos

id bigIncrements
name string
post_id ^FK bigInteger
timestamps timestamps

post_likes

id bigIncrements
post_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

categories

id uuid
code string (100)
timestamps timestamps

user_reviews

id bigIncrements
message text
rating tinyInteger
user_profil_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

user_notifications

id bigIncrements
message string (150)
is_read boolean
user_id ^FK bigInteger
timestamps timestamps

user_follow_requests

id bigIncrements
user_follow_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

admin_notifications

id bigIncrements
message string (150)
is_read boolean
timestamps timestamps

user_thread_messages

id bigIncrements
message text
is_read boolean
user_thread_id bigInteger
user_recipient_id ^FK bigInteger
user_sender_id ^FK bigInteger
timestamps timestamps

post_locations

id bigIncrements
location string (200)
post_id ^FK bigInteger
timestamps timestamps

post_identify_users

id bigIncrements
post_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

post_tags

id bigIncrements
locale_id ^FK bigInteger
post_id ^FK bigInteger
timestamps timestamps

lives

id bigIncrements
status enum
cover string
title string (200)
description text
is_draft boolean
is_free boolean
fixed_price_token float
max_participant integer
max_ticket_per_participant smallInteger
start_at datetime
end_at datetime
duration smallInteger
agora_token string
user_id ^FK bigInteger
timestamps timestamps

live_tags

id bigIncrements
locale_id ^FK bigInteger
live_id ^FK bigInteger
timestamps timestamps

call_auction_participants

id bigIncrements
token float
call_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

live_co_hosts

id bigIncrements
user_id ^FK bigInteger
live_id ^FK bigInteger
timestamps timestamps

live_participants

id bigIncrements
is_vip boolean
vip_retribution_percent float
user_id ^FK bigInteger
live_id ^FK bigInteger
live_invitation_id ^FK bigInteger
timestamps timestamps

live_invitations

id bigIncrements
status string
is_vip boolean
is_send boolean
is_accept boolean
date_of_acceptance datetime
user_id ^FK bigInteger
live_id ^FK bigInteger
timestamps timestamps

live_tickets

id bigIncrements
number string (20)
is_disabled boolean
user_id ^FK bigInteger
live_id ^FK bigInteger
live_invitation_id ^FK bigInteger
live_ticket_transaction_id ^FK bigInteger
timestamps timestamps

user_calendars

id bigIncrements
start_at datetime
end_at datetime
live_id ^FK bigInteger
call_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

live_ticket_transactions

id bigIncrements
token float
transaction_id string
user_id ^FK bigInteger
live_id ^FK bigInteger
timestamps timestamps

live_interactions

id bigIncrements
type enum
user_id ^FK bigInteger
live_id ^FK bigInteger
timestamps timestamps

live_gifts

id bigIncrements
token_number smallInteger
transaction_id string
user_id ^FK bigInteger
live_id ^FK bigInteger
timestamps timestamps

calls

id bigIncrements
status enum
cover string (100)
title string (150)
description text
is_draft boolean
is_free boolean
is_auction boolean
is_fixed_price boolean
fixed_price_token float
auction_token_min float
auction_current_token float
auction_last_bidder_id ^FK bigInteger
validation_type enum
open_at datetime
close_at datetime
start_at datetime
end_at datetime
agora_token bigInteger
user_id ^FK bigInteger
timestamps timestamps

call_auction_registers

id bigIncrements
is_winner boolean
call_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

call_invitations

id bigIncrements
status enum
is_send boolean
is_accepted boolean
accepted_at datetime
call_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

call_ticket_transaction

id bigIncrements
status enum
token float
transaction_id string
call_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

call_tickets

id bigIncrements
ticket_number string (50)
call_id ^FK bigInteger
call_invitation_id ^FK bigInteger
call_ticket_transaction_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

call_participants

id bigIncrements
call_id ^FK bigInteger
call_invitation_id string
user_id ^FK bigInteger
timestamps timestamps

call_tags

id bigIncrements
locale_id ^FK bigInteger
call_id ^FK bigInteger
timestamps timestamps

locales

id uuid
code string (2)
timestamps timestamps

user_certified_user_calendars

id bigIncrements
start_at datetime
end_at datetime
live_id ^FK bigInteger
call_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

center_of_interests

id uuid
code string (100)
timestamps timestamps

user_center_of_interests

id bigIncrements
center_of_interest_id ^FK bigInteger
user_id ^FK bigInteger
timestamps timestamps

post_center_of_interests

id bigIncrements
center_of_interest_id ^FK bigInteger
post_id ^FK bigInteger
timestamps timestamps

live_center_of_interests

id bigIncrements
center_of_interest_id ^FK bigInteger
live_id ^FK bigInteger
timestamps timestamps

call_center_of_interests

id bigIncrements
center_of_interest_id ^FK bigInteger
call_id ^FK bigInteger
timestamps timestamps