- Primary key (PK)
- The field, or combination of fields, that uniquely identifies each row in a table. Click the key icon next to a column to mark it part of the primary key — click it again to remove it. A composite key has more than one column marked.
- Foreign key (FK)
- A field that holds the primary key value of a row in another table, linking the two. Click the link icon next to the foreign-key column, then click the link icon next to the primary-key column it refers to.
| Data type | Stores |
|---|
| INTEGER | Whole numbers |
| REAL | Numbers with a decimal point |
| CURRENCY | Monetary amounts (e.g. a cost or price) |
| CHAR(n) | Fixed-length text of exactly n characters |
| VARCHAR(n) | Variable-length text of up to n characters |
| DATE | A calendar date |
| TIME | A time of day |
| BOOLEAN | TRUE or FALSE |
