Data types and constraints in Supabase - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a data type in Supabase?

A data type defines the kind of data a column can hold, like numbers, text, or dates. It helps keep data organized and valid.

beginner

Name three common data types used in Supabase tables.

Common data types include integer (whole numbers), text (words or sentences), and timestamp (date and time).

beginner

What is a constraint in Supabase?

A constraint is a rule that limits the kind of data that can be stored in a table to keep data accurate and consistent.

beginner

Explain the purpose of the NOT NULL constraint.

NOT NULL means a column must always have a value; it cannot be left empty. This ensures important data is always present.

beginner

What does a UNIQUE constraint do in a Supabase table?

A UNIQUE constraint makes sure all values in a column are different, so no two rows have the same value in that column.

Which data type would you use to store a user's age in Supabase?

A boolean

B text

C integer

D timestamp

Age is a whole number, so integer is the correct data type.

What does the NOT NULL constraint enforce?

A Column values must be unique

B Column cannot have empty values

C Column values must be numbers

D Column values must be text

NOT NULL means the column must always have a value; it cannot be empty.

Which constraint ensures no duplicate emails in a user table?

A UNIQUE

B CHECK

C NOT NULL

D FOREIGN KEY

UNIQUE constraint prevents duplicate values in a column.

Which data type is best for storing a user's full name?

A timestamp

B integer

C boolean

D text

Text data type is used for words or sentences like names.

What is the main purpose of constraints in a database?

A To enforce rules on data for accuracy

B To speed up queries

C To limit data types

D To store large files

Constraints enforce rules to keep data accurate and consistent.

Describe what data types and constraints are in Supabase and why they matter.

Think about how data is organized and kept correct in tables.

Explain how you would use constraints to ensure a user's email is always provided and unique in a Supabase table.

Consider rules that prevent missing or repeated emails.