quiz_competition - Laravel Schema Designer

users

id increments
user_type enum
timestamps timestamps
softDeletes softDeletes

subscription_plans

id increments
name string
validity integer
validity_type enum
status enum
timestamps timestamps
softDeletes softDeletes

users_subscriptions

id increments
user_id ^FK integer
subscription_id ^FK integer
subscription_details json
purchase_date date
start_date date
end_date date
payment_status enum
txn_id string
status enum
timestamps timestamps

groups

id increments
teacher_id ^FK integer
name string
status enum
timestamps timestamps

group_members

id increments
group_id ^FK integer
name string
points string
timestamps timestamps

levels

id increments
name string
status enum
timestamps timestamps

questions

id increments
level_id ^FK integer
questions longText
answers json
currect_answer longText
status enum
timestamps timestamps
softDeletes softDeletes

group_questions

id increments
group_id ^FK integer
question_id ^FK integer
points string
group_member_id ^FK integer
status enum
timestamps timestamps
softDeletes softDeletes

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