Schema-Design

ENUM in MySQL: when it makes your day, and when it ruins your week

MySQL ENUM vs CHECK constraint vs lookup table: three ways to model an enumeration. Pros, cons and real case of a shipment tracking system.