feedback-survey - Laravel Schema Designer

channels

id increments
tag string (250)
name string (500)
status binary
timestamps timestamps

triggers

id increments
type enum
event string (250)
category enum
description string (500)
channel_id ^FK integer
questionnaire_id ^FK integer
timestamps timestamps

questionnaires

id increments
question_en string (1000)
question_bn string (1000)
choice_type enum
choices json
order integer
status binary
timestamps timestamps

responses

id increments
msisdn string (11)
attempt_id ^FK integer
question_id ^FK integer
choice json
timestamps timestamps

attempts

id increments
uuid string (54)
msisdn string (11)
type string (250)
event string (250)
channel string (250)
trigger_matches json
taken binary
tried_at timestamp
platform string (500)
device_id string (1000)
model string (500)
arpu string (100)
customer_behavior enum
loyalty_level string (100)
district string
city string
thana string
pick_agent_id integer
cfl_status enum
cfl_status_updated_at timestamp
remarks string (1000)
timestamps timestamps

rules

id increments
tag string (250)
trigger_id ^FK integer
values json
timestamps timestamps

feedbacks

id increments
attempt_id ^FK integer
category string (500)
sub_category string (500)
outcome string (500)
timestamps timestamps

buckets

id increments
rule_id ^FK integer
quota integer
served integer
timestamps timestamps

change_logs

id increments
timestamps timestamps
type string (500)
changes json

hits

id increments
trigger_id ^FK integer
channel_id ^FK integer
msisdn string (11)
timestamps timestamps

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