The data model

Content providers expose their data as a simple table on a database model, where each row is a record and each column is data of a particular type and meaning. For example, information about people and their phone numbers might be exposed as follows:

_ID

NUMBER

NUMBER_KEY

LABEL

NAME

TYPE

13

(425) 555 6677

425 555 6677

Kirkland office

Bully Pulpit

TYPE WORK

44

(212) 555-1234

212 555 1234

NY apartment

Alan Vain

TYPE HOME

45

(212) 555-6657

212 555 6657

Downtown office

Alan Vain

TYPE MOBILE

53

201.555.4433

201 555 4433

Love Nest

Rex Cars

TYPE HOME

Every record includes a numeric ID field that uniquely identifies the record within the table. IDs can be used to match records in related tables — for example, to find a person's phone number in one table and pictures of that person in another.

0 0

Post a comment