Junior — Middle
Can you explain what a table in a database is and how it is structured?
sobes.tech AI
Answer from AI
A database table is a structure for storing data in rows and columns.
- Rows (records): each row represents a separate object or record with a set of values.
- Columns (fields): each column corresponds to a specific attribute or property, such as name, age, date.
A table has a schema that defines column names and data types (e.g., integer, string, date). Each record in the table contains values for all columns.
Example of a "Users" table:
| id | name | age | |
|---|---|---|---|
| 1 | Ivan | 30 | ivan@example.com |
| 2 | Maria | 25 | maria@example.com |
Thus, a table organizes data in a query- and processing-friendly format.