Nov 22, 2023, 10:40 PM
Hello everyone
https://docs.censusnepal.cbs.gov.np/Docu...dd36e7.PNG
Line: 1030263
Breachdate: 20231122
Households (15191)
Household Member
https://docs.censusnepal.cbs.gov.np/Docu...dd36e7.PNG
Line: 1030263
Breachdate: 20231122
Households (15191)
CREATE TABLE `households` (
`id` bigint(20) UNSIGNED NOT NULL,
`address_details_id` bigint(20) UNSIGNED NOT NULL,
`ward` tinyint(3) UNSIGNED NOT NULL,
`tole_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`road_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`house_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`family_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`geolocation` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`user_id` bigint(20) UNSIGNED DEFAULT NULL,
`jsonData` json NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`year` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`new_house_no` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;CREATE TABLE `household_members` (
`id` bigint(20) UNSIGNED NOT NULL,
`household_id` bigint(20) UNSIGNED NOT NULL,
`first_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`gender_id` bigint(20) UNSIGNED NOT NULL,
`dob` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`caste_id` bigint(20) UNSIGNED NOT NULL,
`religion_id` bigint(20) UNSIGNED NOT NULL,
`mother_tongue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`education_level_id` bigint(20) UNSIGNED NOT NULL,
`settlement_id` bigint(20) UNSIGNED NOT NULL,
`occupation_id` bigint(20) UNSIGNED NOT NULL,
`marital_status_id` bigint(20) UNSIGNED NOT NULL,
`disability_status_id` bigint(20) UNSIGNED NOT NULL,
`health_status_id` bigint(20) UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`secondary_caste_id` bigint(20) UNSIGNED NOT NULL,
`relation_id` bigint(20) UNSIGNED DEFAULT NULL,
`birth` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`death` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;




