Structure of mime_types

A table of MIME types and associated file suffixes

suffix

character varying(20) NOT NULL

The file suffix, without the starting dot

mime_type

character varying(100) NOT NULL

The MIME TYPE, for example text/html