Link Locality App - Laravel Schema Designer

customer

id increments
cutomer_unique_id string (191)
first_name string (191)
last_name string (191)
mobile integer
email string (191)
password string (191)
address text
about text
profile_img string (191)
location string (191)
society string (191)
RWA string (191)
latitude string
longitude string
otp smallInteger
is_provider boolean
status tinyInteger
timestamps timestamps

groups

id increments
customer_id integer
category_id integer
sub_category_id integer
group_name string (191)
area string (area)
latitude string
longitude string
approve tinyInteger
timestamps timestamps

friends_list

id increments
customer_id integer
friend_id integer
status tinyInteger
timestamps timestamps

group_member

id increments
customer_id integer
member_type tinyInteger
group_id integer
status integer
timestamps timestamps

group_category

id increments
category_text string (191)
parent_id integer
timestamps timestamps

post

id increments
entity_id integer
entity_type string
post_text text
post_media string
share integer
timestamps timestamps

post_likes

id increments
post_id integer
customer_id integer
like_value tinyInteger
timestamps timestamps

post_comment

id increments
entity_id integer
customer_id integer
comment_text text
timestamps timestamps

messages

id increments
customer_id integer
friend_id integer
messages_text text
is_group tinyInteger
group_id tinyInteger
is_service tinyInteger
timestamps timestamps

messages_recipient

id increments
receiver_id integer
message_id integer
is_read boolean
timestamps timestamps

post_a_ads

id increments
customer_id integer
postads_text text
postads_img string (191)
latitude string (191)
longitude string (191)
area string (191)
approve tinyInteger
timestamps timestamps

request

id increments
provider_id integer
customer_id integer
service_id integer
review_text text
review_star string
timestamps timestamps
status tinyInteger

service

id increments
customer_id integer
service_type string (191)
parent_id integer
service_charge string (191)
latitude string (191)
longitude string (191)
timestamps timestamps

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