How to understand the concepts of table, field, record and data item in property management information system

Table: A term in a relational database that stores all data in a two-dimensional table, just like an excel table.

Field: It is the name of the column in the table. Like excel tables, there are various types of fields (characters, numbers and dates). . . ), excel is similar.

Record: the row data in the table, and a record refers to a whole row of data in the table.

Data item: every data in a table, such as the data in the third row and the second column.