bot - Laravel Schema Designer

interactions

id bigIncrements
name string
type enum
conversation_id bigInteger
timestamps timestamps
softDeletes softDeletes

interaction_options

id bigIncrements
text json
value string
goto_interaction_id bigInteger
interaction_id bigInteger
timestamps timestamps
softDeletes softDeletes

conversations

id bigIncrements
name string
status boolean
start_interaction_id bigInteger
intent_id bigInteger
bot_id bigInteger
timestamps timestamps
softDeletes softDeletes

intents

id bigIncrements
name string
keywords longText

interaction_integrations

id bigIncrements
name string
url string
type_method string
body_variables string
request_headers json
request_parameters json
response_fields json
interaction_id bigInteger
timestamps timestamps
softDeletes softDeletes

bots

id increments
name string
description text
status boolean
timestamps timestamps
softDeletes softDeletes

interaction_media

id bigIncrements
interaction_id bigInteger
media_id bigInteger

interaction_locations

id bigIncrements
name string
address string
lat float (10,6)
lng float (10,6)
type string
interaction_id bigInteger
timestamps timestamps
softDeletes softDeletes

media

id bigIncrements
title string
url text
type enum
ext string
timestamps timestamps
softDeletes softDeletes

interaction_questions

id increments
text json
variable_name string
goto_interaction_id bigInteger
interaction_id bigInteger
timestamps timestamps
softDeletes softDeletes

interaction_text

id increments
text json
goto_interaction_id bigInteger
interaction_id bigInteger
timestamps timestamps
softDeletes softDeletes

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