yala-mobile - Laravel Schema Designer

news

id increments
media_type string
media_paths jsonb
title string (255)
content text
created_by integer
updated_by integer
timestamps timestamps
softDeletes softDeletes

activities

id increments
media_type string
media_paths jsonb
title string (255)
content text
start_at datetime
end_at datetime
created_by integer
updated_by integer
timestamps timestamps
softDeletes softDeletes

users

id increments
citizen_id string (255)
password string (255)
fullname string (255)
birth_date datetime
gender char (1)
phone string (255)
email string (255)
card_address string
card_moo string
card_tambon string
card_amphoe string
card_province string
card_zipcode string
use_card_address boolean
current_address string
current_moo string
current_tambon string
current_district string
current_province string
current_zipcode string
image_path string (255)
timestamps timestamps
softDeletes softDeletes

questionnaires

id increments
media_type string
media_paths jsonb
title string (255)
content text
start_at datetime
end_at datetime
cond_enable boolean
cond_age_from integer
cond_age_to integer
cond_gender char (1)
cond_area string
published_at datetime
created_by integer
updated_by integer
timestamps timestamps
softDeletes softDeletes

places

id increments
place_type_id integer
image_path string
name string (255)
google_map_url string (500)
office_hours jsonb
created_by integer
updated_by integer
timestamps timestamps
softDeletes softDeletes

otps

ref string
otp string
user_id integer
timestamps timestamps
verified_at datetime

user_questions

id increments
user_id integer
question_id integer
answer_id integer
timestamps timestamps
user_questionaire_id integer

user_notifications

id increments
user_id integer
source_type string
source_id integer
read_at datetime
created_at datetime

user_problems

id increments
user_id integer
problem_id integer
tags jsonb
content text
location string
image_paths jsonb
status string
timestamps timestamps
softDeletes softDeletes

persons

id increments
type string
inform_by string
proxy_relation string
proxy_prefix string
proxy_firstname string
proxy_lastname string
proxy_citizen_id string
proxy_address string (500)
proxy_phone string
proxy_image_path string
prefix string
firstname string
lastname string
birth_date datetime
nationality string
citizen_id string
marital_status string
marital_text string
monthly_income string
career string
career_text string
address text
phone string
disable_type string
citizen_card_image string
house_registration_image string
disabled_card_image string
refer_contact_prefix string
refer_contact_firstname string
refer_contact_lastname string
refer_contact_phone string
refer_contact_relation string
welfare_status string
welfare_move_date datetime
welfare_transfer_type string
welfare_relation string
transfer_prefix string
transfer_firstname string
transfer_lastname string
transfer_address string (500)
transfer_account_id string
transfer_account_name string
transfer_account_bank string
transfer_citizen_image string
transfer_house_registration_image string
transfer_book_image string
reviewed_at datetime
reviewed_by integer
is_approved boolean
rejected_reason string
timestamps timestamps
softDeletes softDeletes

problems

id increments
name string
tags jsonb
image_path string
timestamps timestamps
softDeletes softDeletes

user_activities

id increments
user_id integer
activity_id integer
timestamps timestamps
softDeletes softDeletes
applied_at datetime
checkin_at datetime

place_reserves

id increments
place_id integer
user_id integer
reserved_at datetime
checkin_at string
checkout_at datetime
reserved_date datetime
reserved_time_from datetime
reserved_time_to datetime
timestamps timestamps

hashtag

id increments
tag string
timestamps timestamps
softDeletes softDeletes

hashtag_posts

hashtag_id integer
post_id integer

facebook_posts

id increments
post_id integer
message text
post_at datetime
softDeletes softDeletes

related_departments

id increments
image_path string
name string
website_url string (500)
timestamps timestamps
softDeletes softDeletes

questions

id increments
text string
questionnaire_id string
sequence tinyInteger

answers

id increments
question_id integer
text string
sequence tinyInteger

place_types

id increments
name string
media_type string
media_data string
timestamps timestamps
softDeletes softDeletes

user_sessions

id increments
user_id integer
push_token string
device_name string
platform string
os_version string
app_version string
timestamps timestamps

forgot_passwords

id increments
timestamps timestamps
user_id integer
open_at datetime
finished_at datetime

broadcast_message

id increments
title_message string
message string
icon_name string
created_at datetime

user_questionnaires

id increments
user_id integer
questionnaire_id integer
created_at datetime

user_problem_progresses

id increments
type string
admin_id integer
user_problem_id integer
timestamps timestamps

disable_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

relation_types

id increments
name string
timestamps timestamps
softDeletes softDeletes

marital_type

id increments
name string
timestamps timestamps
softDeletes softDeletes

careers

id increments
timestamps timestamps
name string
softDeletes softDeletes