Home
BOUser
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (3)
users
id
increments
uuid
uuid
first_name
string
(50)
last_name
string
(50)
email
string
(100)
phone
string
(50)
active
boolean
public_phone
boolean
public_sale
boolean
notify_chat
boolean
notify_interaction
boolean
notify_alert
boolean
notify_advice
boolean
timestamps
timestamps
softDeletes
softDeletes
projects
id
increments
user_id
integer
label
string
(255)
active
boolean
timestamps
timestamps
softDeletes
softDeletes
searches
id
bigIncrements
uuid
uuid
user_id
integer
project_id
integer
real_estate_details_id
mediumInteger
type
tinyInteger
funding_type
tinyInteger
rent
boolean
time_limit_type
tinyInteger
main_house
boolean
active
boolean
timestamps
timestamps
softDeletes
softDeletes
cities
json
real_estate_details
id
increments
label
string
(255)
property_type
tinyInteger
room_count
tinyInteger
area
smallInteger
budget
mediumInteger
works_type
tinyInteger
ground_area_type
tinyInteger
parking_type
tinyInteger
dpe_ges_rank
char
dpe_consumption_rank
char
details
text
timestamps
timestamps
softDeletes
softDeletes
sales
id
increments
user_id
integer
project_id
integer
real_estate_details_id
integer
price
integer
active
boolean
geoloc_google_ref
string
timestamps
timestamps
softDeletes
softDeletes
chats
id
increments
pro_id
integer
user_id
integer
bookmarked
boolean
timestamps
timestamps
softDeletes
softDeletes
attachments
id
increments
interaction_id
integer
message_id
integer
document_token
string
(255)
document_type
tinyInteger
timestamps
timestamps
softDeletes
softDeletes
interactions
id
increments
pro_id
integer
search_id
integer
chat_id
integer
interaction_type
tinyInteger
viewed_at
datetime
timestamps
timestamps
softDeletes
softDeletes
pros
id
increments
uuid
uuid
company
string
(255)
address
string
(500)
zip
string
(50)
city
string
(100)
phone
string
(50)
email
string
(255)
timestamps
timestamps
softDeletes
softDeletes
pro_ranking
id
increments
pro_id
integer
user_id
integer
rank
tinyInteger
comments
string
(255)
timestamps
timestamps
softDeletes
softDeletes
sale_estimates
id
increments
sale_id
integer
property_type
tinyInteger
room_count
tinyInteger
area
smallInteger
price
integer
timestamps
timestamps
softDeletes
softDeletes
progress
id
increments
project_id
integer
sale_id
integer
step
tinyInteger
timestamps
timestamps
softDeletes
softDeletes
messages
id
increments
uuid
uuid
chat_id
integer
index
smallInteger
message
text
user_to_pro
boolean
has_attachment
boolean
timestamps
timestamps
softDeletes
softDeletes
×
Comments for BOUser
nicocmn . 31 March 2021
Le champ "has_attachment" de la table messages à vraiment une utilité ?
nicocmn . 31 March 2021
Je pense qu'il devrait y avoir une relation entre les messages et les interactions, sans on ne peut pas retrouver facilement quel interaction correspond à quel message
nicocmn . 17 April 2021
la table attachments devrait être rattachés a la table messages. Un user ou un pro peut poster un message avec fichiers.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01