🛡 Insurance Products

Preview ↗
🛡
5
Insurance Types
employee to cargo
⚠️
2
Mandatory
SSF + Workers Comp
🌿
3
Climate-Tagged
agri and CAT cover
♀️
3
Gender-Tagged
women SME schemes
insurance_items table
🔍
IDProduct NameTypeMandatoryApprox CostProviderStatusActions
📐 DB Schema — insurance_items table
ColumnTypeNullableDescription
idVARCHAR(10)NOT NULLUnique identifier
product_nameVARCHAR(200)NOT NULLInsurance product name
ins_typeVARCHAR(50)NOT NULLEmployee/Property/Cargo/Liability/Agricultural
mandatoryVARCHAR(20)NOT NULL DEFAULT NoYes/No/Conditional
cost_descriptionVARCHAR(200)NULLCost range
gender_responsiveBOOLEANNOT NULL DEFAULT falseWomen SME flag
climate_relevantBOOLEANNOT NULL DEFAULT falseAgri/climate risk flag
statusVARCHAR(20)NOT NULL DEFAULT draftpublished/draft/archived