Boolean
# True or False
Character
# char, varchar, and text
Numeric
# integer and floating-point number
Temporal
# date, time, timestamp and interval
UUID
# universally unique identifiers
Array
# stores an array of strings, numbers, etc
JSON
Hstore key-value pair
Special types such as network address and geometric data
Primary Keys and Foreign Keys
Primary Keys » Integer based and Unique Identifier
Foreign keys » Referring table or child table, the column title also appear in other tables.
Constraints
Database > Schemas > Tables > Constraints
NOT NULL constraint
# ensure that a column cannot have NULL value
UNIQUE constraint
# ensure that all values in a column are different
CHECK constraint
# ensure that all values in a column satisfy certain conditions
EXCLUSION constraint
# ensure that if any 2 rows are compared on the specified column or expression using the specified operator, not all of these comparisons will return TRUE