manket - Laravel Schema Designer

manket_clients

id increments
email string (255)
password string (45)
fname string (45)
sname string (45)

manket_members

manket_client_id ^FK integer
username string (45)
address text
ref_id string (45)
avatar string (45)
device_id string (255)
app_version string (45)
birthday date

manket_users

manket_client_id ^FK integer
phone string (45)
lang_id tinyInteger
manket_company_id ^FK integer

manket_companies

id increments
manket_company_type_id ^FK integer
name string (45)
tax_admin string (45)
tax_number string (45)
phone string (45)
email string (45)
address text
city string (45)
province string (45)

manket_projects

id increments
manket_user_id ^FK integer

manket_surveys

id increments
manket_user_id ^FK integer
manket_project_id ^FK integer
title text
limit string (45)
md_sex string (45)
md_age string (45)
md_marital string (45)
md_country string (45)
md_province string (45)
md_city string (45)
md_demographic string (45)

manket_survey_questions

id increments
manket_survey_id ^FK integer
manket_survey_question_type_id ^FK integer
no integer
text text
info text
asset char

manket_survey_questions_answers

id increments
manket_member_id ^FK integer
manket_survey_question_id ^FK integer
value string (45)
timestamps timestamps

manket_survey_questions_types

id increments
name string (45)

manket_member_demographics

id increments
manket_member_id ^FK integer
age string (45)
marital string (45)
educartion string (255)
interests string
lifestyle string
job string
finance string
internet string
others string
country string
province string
city string
zipcode string
language string
sex string

manket_members_demographic_values

id increments
category string (45)
value string

manket_survey_question_choices

id increments
manket_survey_question_id ^FK integer
text string (45)
info string (45)
asset char
value string (45)

manket_company_types

id increments
name string (45)

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