smart_village - Laravel Schema Designer

questions

id increments
timestamps timestamps
softDeletes softDeletes
q_sinhala text
q_english text
q_tamil text
question_type integer
total_marks decimal
category_id integer
field_code string
major_field_code string
sub_major_field_code string
unit_field_code string
specific_field_code string
proffession_id integer
organization_id integer
location_id integer
status string
added_by string
approved_by string

answers

id increments
timestamps timestamps
softDeletes softDeletes
question_id ^FK integer
sequence_id integer
marks decimal
answer_type_id integer
answer_list_id integer

grama_niladhari_division

id increments
timestamps timestamps
softDeletes softDeletes
province_code string
district_code string
divisional_secretariat_code string
gn_code string
sin_gn_division string
eng_gn_division string
tam_gn_division string

fields

id increments
timestamps timestamps
softDeletes softDeletes
field_code string
eng_description string
sin_description string
tam_description string

jobs

id increments
timestamps timestamps
softDeletes softDeletes
field_code string
major_field_code string
sub_major_field_code string
unit_field_code string
specific_field_code string
major_group_id string
sub_major_group_id string
minor_group_id string
unit_group_id string
job_id float (10,5)
sin_job_name string
eng_job_name string
tam_job_name string
scale ^FK integer
organisation string
location string
sin_description text
eng_description text
tam_description text
sin_traditional_description text
eng_traditional_description text
tam_traditional_description text
profession_image string

answer_types

id increments
timestamps timestamps
softDeletes softDeletes
no_of_answers integer
name string

answer_list

id increments
timestamps timestamps
softDeletes softDeletes
answer_type_id ^FK integer
answer_list_id integer
sequence_id integer
sin_answer string
eng_answer string
tam_answer string

organizations

id increments
timestamps timestamps
softDeletes softDeletes
field_code string
major_field_code string
sub_major_field_code string
unit_field_code string
specific_field_code string
sin_organization_name string
tam_organization_name string
eng_organization_name string
sin_organization_address string
eng_organization_address string
tam_organization_address string
scale integer
province string
district string
ds string
gn string
village string
telephone string
fax string
email string
organization_type integer
organization_image string
sin_description text
eng_description text
tam_description text

locations

id increments
timestamps timestamps
softDeletes softDeletes
field_code string
major_field_code string
sub_major_field_code string
unit_field_code string
specific_field_code string
sin_location_name string
eng_location_name string
tam_location_name string
sin_location_address string
eng_location_address string
tam_location_address string
scale integer
province string
district string
ds string
gn string
village string
telephone string
fax string
email string
location_type integer
location_image string
sin_description text
eng_description text
tam_description text

major_group

id increments
timestamps timestamps
softDeletes softDeletes
major_group_id string
sin_major_group text
eng_major_group text
tam_major_group text

sub_major_group

id increments
timestamps timestamps
softDeletes softDeletes
major_group_id string
sub_major_group_id string
sin_sub_major_group text
eng_sub_major_group text
tam_sub_major_group text

minor_group

id increments
timestamps timestamps
softDeletes softDeletes
major_group_id string
sub_major_group_id string
minor_group_id string
sin_minor_group text
eng_minor_group text
tam_minor_group text

unit_group

id increments
timestamps timestamps
softDeletes softDeletes
major_group_id string
sub_major_group_id string
minor_group_id string
unit_group_id string
sin_unit_group text
eng_unit_group text
tam_unit_group text

scale

id increments
timestamps timestamps
softDeletes softDeletes
sin_scale string
eng_scale string
tam_scale string

location_type

id increments
timestamps timestamps
softDeletes softDeletes
sin_type_name string
eng_type_name string
tam_type_name string

organization_type

id increments
timestamps timestamps
softDeletes softDeletes
sin_type_name string
eng_type_name string
tam_type_name string

province

id increments
timestamps timestamps
softDeletes softDeletes
province_code string
sin_province string
eng_province string
tam_province string

district

id increments
timestamps timestamps
softDeletes softDeletes
province_code string
district_code string
sin_district string
eng_district string
tam_district string

divisional_secretariat

id increments
timestamps timestamps
softDeletes softDeletes
province_code string
district_code string
divisional_secretariat_code string
sin_divisional_secretariat string
eng_divisional_secretariat string
tam_divisional_secretariat string

field_major_group

id increments
timestamps timestamps
softDeletes softDeletes
field_code string
major_field_code string
eng_major_field text
sin_major_field text
tam_major_field text

field_sub_major_group

id increments
timestamps timestamps
softDeletes softDeletes
field_code string
major_field_code string
sub_major_field_code string
eng_sub_major_field text
sin_sub_major_field text
tam_sub_major_field text

field_unit_group

id increments
timestamps timestamps
softDeletes softDeletes
field_code string
major_field_code string
sub_major_field_code string
unit_field_code string
eng_unit_field text
sin_unit_field text
tam_unit_field text

field_specific_group

id increments
timestamps timestamps
softDeletes softDeletes
field_code string
major_field_code string
sub_major_field_code string
unit_field_code string
specific_field_code string
eng_specific_field text
sin_specific_field text
tam_specific_field text

testtable

id increments
timestamps timestamps

postal_code

id increments
timestamps timestamps
softDeletes softDeletes
province_code string
district_code string
ds_code string
gn_code string
postal_code string
eng_post_office string
sin_post_office string
tam_post_office string
telephone string
latitude string
longitude string