87.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 87-1:
|
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... |
