entry
cid  name                   type     notnull  dflt_value            pk
---  ---------------------  -------  -------  --------------------  --
0    id                     INTEGER  0                              1
1    contentId              INTEGER  0                              0
2    uri                    TEXT     0                              0
3    path                   TEXT     0                              0
4    sourceMimeType         TEXT     0                              0
5    width                  INTEGER  0                              0
6    height                 INTEGER  0                              0
7    sourceRotationDegrees  INTEGER  0                              0
8    sizeBytes              INTEGER  0                              0
9    title                  TEXT     0                              0
10   dateAddedSecs          INTEGER  0        strftime('%s','now')  0
11   dateModifiedMillis     INTEGER  0                              0
12   sourceDateTakenMillis  INTEGER  0                              0
13   durationMillis         INTEGER  0                              0
14   trashed                INTEGER  0        0                     0
15   origin                 INTEGER  0        0                     0
16   provider               TEXT     0                              0
17   remoteId               TEXT     0                              0
18   remotePath             TEXT     0                              0
19   remoteThumb1           TEXT     0                              0
20   remoteThumb2           TEXT     0                              0
21   remoteWidth            INTEGER  0                              0
22   remoteHeight           INTEGER  0                              0
23   remoteRotation         INTEGER  0                              0
24   latitude               REAL     0                              0
25   longitude              REAL     0                              0
26   altitude               REAL     0                              0

folders
cid  name            type     notnull  dflt_value  pk
---  --------------  -------  -------  ----------  --
0    path            TEXT     0                    1
1    display_name    TEXT     0                    0
2    file_count      INTEGER  0                    0
3    total_size      INTEGER  0                    0
4    thumb_entry_id  INTEGER  0                    0
5    thumb_date      INTEGER  0                    0
6    album_type      INTEGER  0                    0
7    priority        INTEGER  0                    0
8    is_remote       INTEGER  0                    0
9    user            TEXT     0                    0
10   device_id       TEXT     0                    0
11   hidden          INTEGER  0                    0
12   hybrid_type     TEXT     0                    0

metadata
cid  name             type     notnull  dflt_value  pk
---  ---------------  -------  -------  ----------  --
0    id               INTEGER  0                    1
1    mimeType         TEXT     0                    0
2    dateMillis       INTEGER  0                    0
3    flags            INTEGER  0                    0
4    rotationDegrees  INTEGER  0                    0
5    xmpSubjects      TEXT     0                    0
6    xmpTitle         TEXT     0                    0
7    latitude         REAL     0                    0
8    longitude        REAL     0                    0
9    rating           INTEGER  0                    0

address
cid  name         type     notnull  dflt_value  pk
---  -----------  -------  -------  ----------  --
0    id           INTEGER  0                    1
1    addressLine  TEXT     0                    0
2    countryCode  TEXT     0                    0
3    countryName  TEXT     0                    0
4    adminArea    TEXT     0                    0
5    locality     TEXT     0                    0