Let's talk about albums and their objects

I see three or four tables in the database that deals with albums and their objects.  I tried to gain an understanding of how Dolphin handles albums and their objects but did not get anywhere.  I went into the database to do a simple move of an object from one album to another and could not see the relationship between the various tables that handles this.

I am hoping that the developers that work with albums will come in and help explain albums and their objects; the tables and fields and the relationship between the tables and fields.

in sys_albums the ID, Type, ObjCount, and LastObjId I believe are the important ones. Will try my best to give my understanding of them.

ID - ID number (autonumbered and created when album is created)

Type - type of album it is (ie video, photo, etc)

ObjCount - number of items in the album (ex. Type = bx_videos; and ObjCount = 10; then that would mean there are 10 videos in that album)

LastObjId - the ID number of the last item in that album (ex LastObjId = 210; then that means the last item in that album will have a file number of 210)

Next Table would be sys_albums_objects.

id_album - this corresponds to the ID number in the sys_albums table

id_object - id number of the items in this album.This number also corresponds with the file number of the item.

obj_order - the order of this item in the album

So - to tie these two tables together, I will give an example of a video in the admin album

in sys_albums, the ID number (in my case) = 1, the Type = bx_videos, the ObjCount = 1, and the LastObjId = 1

in my sys_albums_objects table, my id_album is 1 (equal to the ID of the album in sys_albums), the id_object = 1 (the video file saved in flash/modules/video/files is 1.m4v and 1.webm)

groups and events are slightly different.

if you add a video to the groups or events these will be in the bx_groups_videos or bx_events_videos tables. The entry_id is equal to the id of the event or group - which is in the bx_groups_main or bx_events_main tables. The media_id is equal to the file number of the video in flash/modules/video/files.

So an example of a video in groups would be: bx_groups_main table - id = 10. In the bx_groups_videos table, the entry_id = 10, media_id = 91. In flash/modules/video/files there would be a file called 91.m4v and 91.webm.

Hope this makes sense