Constraints impose validity rules on the database itself: NOT NULL forbids missing values, UNIQUE forbids duplicates, CHECK enforces a condition, DEFAULT provides a default value. They protect data quality whatever application writes to it.
Example
prix NUMERIC CHECK (prix >= 0) NOT NULL DEFAULT 0