73 lines
3.8 KiB
Markdown
73 lines
3.8 KiB
Markdown
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
|
|
|
|
|