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
verified integer
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)
email_verif_token string (255)
email_verif_expire string (255)
last_email_verif_date datetime
active tinyInteger
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
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
novel_id ^FK integer
user_id ^FK integer
comment_rating integer
comment_content string (255)
active tinyInteger
created_at datetime
updated_at datetime
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
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_price integer
package_coin_show integer
package_coin_value integer
publish tinyInteger
active tinyInteger
created_at datetime
updated_at datetime
deleted_at datetime
published_at datetime

gooddreamer_transaction

id integer
created_at datetime
updated_at datetime

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