Back to: TIMERS
Let’s focus on what relational databases are and how they are organised.
A relational database is a database that organises information into one or more tables.
A table is a collection of data organised into rows and columns. Tables are sometimes referred to as relations.
A column is a set of data values of a particular type.
A row is a single record in a table.
All data stored in a relational database is of a certain data type. Some of the most common data types are:
INTEGER
, a positive or negative whole numberTEXT
, a text stringDATE
, the date formatted as YYYY-MM-DD for the year, month, and dayREAL
, a decimal value