upazilla_digitalization - Laravel Schema Designer

area_divisions

id bigIncrements
name string (100)
slug string (100)
bn_name string (100)
sl integer
timestamps timestamps

area_districts

id bigIncrements
name string (100)
slug string (100)
bn_name string (100)
division_id ^FK bigInteger
sl integer
timestamps timestamps

area_upazila_thanas

id bigIncrements
name string (100)
slug string (100)
bn_name string (100)
type enum
division_id ^FK bigInteger
district_id ^FK bigInteger
sl integer
timestamps timestamps

area_post_offices

id increments
timestamps timestamps
name string (100)
slug string (100)
bn_name string (100)
division_id ^FK bigInteger
district_id ^FK bigInteger
upazila_thana_id ^FK bigInteger
code integer

area_unions

id increments
name string (100)
slug string (100)
bn_name string (100)
division_id ^FK bigInteger
district_id ^FK bigInteger
upazila_thana_id ^FK bigInteger
timestamps timestamps

users

id increments
name string (100)
email string (100)
phone string (20)
nid string (100)
dob date
username string (100)
pin string (100)
timestamps timestamps

user_addresses

id increments
type enum
holding string (150)
division_id ^FK bigInteger
district_id ^FK bigInteger
upazila_thana_id ^FK bigInteger
post_office_id ^FK bigInteger
union_id ^FK bigInteger
timestamps timestamps
user_type_details_id ^FK bigInteger

area_wards

id increments
name string (100)
slug string (100)
bn_name string (100)
division_id ^FK bigInteger
district_id ^FK bigInteger
upazila_thana_id ^FK bigInteger
union_id ^FK bigInteger
timestamps timestamps

user_details

id increments
user_id ^FK bigInteger
father_name string (100)
mother_name string (100)
spouse_name string (100)
religion enum
occupation string (100)
timestamps timestamps

user_type_details

id increments
user_id ^FK bigInteger
timestamps timestamps

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