88.2 The Database Schema
The data for the example app is contained within a file named landmarks.db located in the app -> assets –> databases folder of the project hierarchy. The database contains a single table named locations, the structure of which is outlined in Table 88-8:
Column |
Type |
Description |
_id |
String |
The primary index, this column contains string values that uniquely identify the landmarks in the database. |
Title |
String |
The name of the landmark (e.g. London Bridge). |
description |
String |
A description of the landmark. |
personal |
Boolean |
Indicates whether the record is personal... |