gooddreamer_db - Laravel Schema Designer

gooddreamer_user_data

id integer
uuid string (255)
user_uri string (255)
fullname string (255)
email string (255)
country_code string (255)
phone string (255)
gender tinyInteger
username string (255)
dob date
age integer
photo_profile_path string (255)
photo_profile_filename string
is_guest boolean
password string (255)
otp_pass string (255)
otp_valid_until datetime
personal_bio string (255)
apns_token string (255)
fcm_token string (255)
google_token string (255)
device_token string
email_verif_token string (255)
email_verif_expire string (255)
last_email_verif_date datetime
active tinyInteger
referral_code string (255)
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_admin

id integer
username string (255)
email string (255)
password string (255)
status tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_author

id integer
admin_id ^FK integer
uuid string (255)
author_name string (255)
status tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_novel

id integer
language_id ^FK integer
author_id ^FK integer
uuid string (255)
novel_title string (255)
novel_sinopsis text
novel_cover_path string (255)
nover_cover_filename string
novel_rating float
novel_price integer
active tinyInteger
status tinyInteger
bundle tinyInteger
free_chapter smallInteger
published_by ^FK integer
published_at datetime
created_at datetime
updated_at datetime
deleted_at datetime

data_language

id integer
uuid string (255)
language_name string (255)
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

data_category

id integer
uuid string (255)
category_name string (255)
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

pivot_novel_category

novel_id ^FK integer
category_id ^FK integer

gooddreamer_novel_chapter

id integer
novel_id ^FK integer
chapter_title string (255)
chapter_content longText
active tinyInteger
status tinyInteger
created_at datetime
updated_at string
deleted_at datetime
published_at datetime

gooddreamer_novel_comment

id integer
user_id ^FK integer
comment_rating integer
comment_content string (255)
active tinyInteger
created_at datetime
updated_at datetime
novel_id ^FK integer
deleted_at datetime

gooddreamer_user_wallet

id increments
user_id ^FK integer
wallet_credit integer
created_at datetime
updated_at datetime

gooddreamer_content

id integer
uuid string
content_name string (255)
content_sort smallInteger
content_icon_path string (255)
content_icon_filename string (255)
content_slug string (255)
type smallInteger
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_content_item

id integer
content_id ^FK integer
novel_id ^FK integer
item_sort smallInteger
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_user_collection

id integer
user_id ^FK integer
novel_id ^FK integer
type tinyInteger
hidden tinyInteger
expired_at datetime
created_at datetime
hidden_at datetime

data_param

id integer
param_name string (255)
param_value string (255)
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

data_app_version

id integer
version_code integer
version_name string (255)
version_message string (255)
version_date datetime
version_status tinyInteger
android_status tinyInteger
ios_status tinyInteger
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

admin_log

id integer
admin_id ^FK integer
log_desc text
created_at datetime

api_key

id integer
username string (255)
token_hash string (255)
type integer
active integer

gooddreamer_package

id integer
uuid string (255)
package_name string (255)
package_sub_name string (255)
package_price integer
package_coin_value integer
discount_value integer
discount_percentage float
publish tinyInteger
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime
published_at datetime

gooddreamer_transaction

id integer
user_id ^FK integer
package_id ^FK integer
payment_id ^FK integer
transaction_status tinyInteger
transaction_coin_value integer
referral_user_id ^FK integer
created_at datetime
updated_at datetime

gooddreamer_promo

id integer
promo_content text
promo_path string
promo_filename string
promo_start_date date
promo_end_date date
promo_url string (255)
directive_type enum
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_notification_scheduler

id integer
ns_content text
ns_path string (255)
ns_filename string (255)
ns_start_date datetime
ns_end_date datetime
ns_hour time
ns_repeat_day string (255)
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_notification_send_list

id integer
ns_id ^FK integer
user_id integer
notif_load longText
send_schedule datetime
send_status tinyInteger
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_user_wallet_item

id integer
wallet_id ^FK integer
reffable_id integer
reffable_type string (255)
item_name string
item_type enum
transaction_item enum
created_at datetime
updated_at datetime

gooddreamer_novel_transaction

id integer
user_id ^FK integer
novel_id ^FK integer
transaction_status tinyInteger
transaction_coin_value integer
created_at datetime
updated_at datetime

gooddreamer_bonus_coin

id integer
receiver_id ^FK integer
sender_id ^FK integer
reward_item_id ^FK integer
bonus_type enum
transaction_status tinyInteger
transaction_coin_value integer
created_at datetime
updated_at datetime

gooddreamer_reward

id integer
novel_id ^FK integer
reward_slug enum
reward_start_date date
reward_end_date date
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime
published_at datetime

gooddreamer_reward_item

id integer
reward_id ^FK integer
chapter_id ^FK integer
day_enum integer
coin_value integer
recurrring integer
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime
published_at datetime

gooddreamer_user_novel_progression

id integer
user_id ^FK integer
uc_id ^FK integer
novel_id ^FK integer
curr_chapter_id ^FK integer
curr_progression float
total_chapter_read integer
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_user_chapter_progression

id integer
novel_progression_id ^FK integer
chapter_id ^FK integer
progression float
created_at datetime
updated_at datetime
deleted_at datetime
is_completed tinyInteger

gooddreamer_payment_data

id integer
payment_gateway_name string
paygate_id string
merchant_code string
callback_virtual_account_id string
owner_id string
external_id string
account_number string
bank_code string
amount integer
trx_timestamp datetime
trx_id string
created_at datetime
updated_at datetime

gooddreamer_user_reward

id integer
user_id ^FK integer
reward_item_id ^FK integer
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_user_freebies

id integer
user_id ^FK integer
origin_novel_id ^FK integer
novel_id ^FK integer
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_user_referral_point

id integer
user_id ^FK integer
inv_user_id integer
type enum
point integer
created_at datetime
updated_at datetime

gooddreamer_admin_refpoint

id integer
point_inviter integer
point_invitation integer
active tinyInteger
created_at datetime
updated_at datetime

gooddreamer_giveaway_period

id integer
winner_id ^FK integer
period_name string
period_start_date datetime
period_end_date date
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_giveaway_leaderboard

id integer
period_id ^FK integer
user_id ^FK integer
total_point integer
created_at datetime
updated_at datetime
deleted_at datetime

gooddreamer_giveaway_notification

id integer
user_id ^FK integer
period_id ^FK integer
gn_title text
gn_content text
gn_path string (255)
gn_filename text
gn_send_datetime datetime
created_at datetime
updated_at datetime
deleted_at datetime