SQL Table Definition (DDL)
CREATE TABLE `fisherfolk_records` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`fisher_code` VARCHAR(30) UNIQUE NOT NULL,
`full_name` VARCHAR(100) NOT NULL,
`municipality` VARCHAR(50) NOT NULL,
`barangay` VARCHAR(50) NOT NULL,
`age_group` VARCHAR(30),
`sex` VARCHAR(10),
`civil_status` VARCHAR(20),
`education` VARCHAR(50),
`experience` VARCHAR(30),
`trainings` VARCHAR(30),
`household_size` VARCHAR(30),
`family_involved` VARCHAR(30),
`age_family_members` TEXT,
`income_percent` VARCHAR(50),
`boat_ownership` VARCHAR(50),
`num_boats` VARCHAR(30),
`age_main_boat` VARCHAR(30),
`age_primary_gear` VARCHAR(30),
`boat_size` VARCHAR(30),
`engine_power` VARCHAR(30),
`primary_gear` TEXT,
`monthly_income` VARCHAR(30),
`catch_per_trip` VARCHAR(30),
-- 18 AC Likert 1-4 Indicators
`ac_1_1` TINYINT, `ac_1_2` TINYINT, `ac_1_3` TINYINT,
`ac_2_1` TINYINT, `ac_2_2` TINYINT, `ac_2_3` TINYINT,
`ac_3_1` TINYINT, `ac_3_2` TINYINT, `ac_3_3` TINYINT,
`ac_4_1` TINYINT, `ac_4_2` TINYINT, `ac_4_3` TINYINT,
`ac_5_1` TINYINT, `ac_5_2` TINYINT, `ac_5_3` TINYINT,
`ac_6_1` TINYINT, `ac_6_2` TINYINT, `ac_6_3` TINYINT,
-- 15 EV Likert 1-4 Indicators
`ev_1_1` TINYINT, `ev_1_2` TINYINT, `ev_1_3` TINYINT,
`ev_2_1` TINYINT, `ev_2_2` TINYINT, `ev_2_3` TINYINT,
`ev_3_1` TINYINT, `ev_3_2` TINYINT, `ev_3_3` TINYINT,
`ev_4_1` TINYINT, `ev_4_2` TINYINT, `ev_4_3` TINYINT,
`ev_5_1` TINYINT, `ev_5_2` TINYINT, `ev_5_3` TINYINT,
-- Calculated Scores
`score_assets` DECIMAL(3,2), `score_flexibility` DECIMAL(3,2),
`score_social_org` DECIMAL(3,2), `score_learning` DECIMAL(3,2),
`score_agency` DECIMAL(3,2), `score_socio_cog` DECIMAL(3,2),
`score_financial` DECIMAL(3,2), `score_physical` DECIMAL(3,2),
`score_human` DECIMAL(3,2), `score_natural` DECIMAL(3,2),
`score_social_cap` DECIMAL(3,2),
`adaptive_capacity` DECIMAL(3,2),
`economic_viability` DECIMAL(3,2),
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;