Constraints
Data Type
Type Modifier
NOT NULL
Default
Unique
Unique NULLS NOT DISTINCT
Check
Exclusion
Exclusion as Partial Unique
Use constraints liberally for now. You all have tiny tables, but know that there's a downside.