Cabin access to cargo holds

[richterscale10]

Just for reference I would like a better understanding of what types of doors are allowed for the cargo hold access from the cabin?

Do you have to have one? Is it necessary to be airtight? Is it no -go if you dont have one?

Thanks