Re: GSoC 2012 - Mobile app on photo metadata

[Prabhath Suminda <pa...@gmail.com>]

Hi,
But he could change it using an photo editing application. So then he
might want to track the date of changes.

Regards,
Prabhath

On Fri, Jun 1, 2012 at 12:55 AM, Avdhesh Yadav <av...@avdheshyadav.com> wrote:
> On Thu, May 31, 2012 at 10:37 PM, Prabhath Suminda
> <pa...@gmail.com>wrote:
>
>> Hi,
>>
>> I developed following schema  to store metadata. Please give feed backs and
>> improvement on this.
>>
>>  This table is the main table which contains data about photoes.
>>
>> PhotoURI (Primary key)
>>
>> PhotoNickName
>>
>> Location
>>
>> Date
>>
>> Time
>>
>> LastModifiedDate
>>
>> I think LastModifiedDate is not required..I think user is not going to
> modify Image using our application ?
>
>>
>>
>>
>>
>>
>>
>>
>>  By using photoURI we can uniquely identify each photo stored in the
>> device.
>>
>> I am planing to add a autocomplete list to select the location of the photo
>> using Google maps API.
>>
>> Last modified date cannot be changed by the user.
>>
>> If the user is capturing the image through our application Location date
>> and time will be automatically generated.
>>
>>
>>  Below table is used to represent the one to many relationship between a
>> photo and people in it. Name column may refer to people in phone contacts
>> or custom names.
>>
>>
>>   PhotoURI
>>
>> Name
>>
>>
>>
>>
>>  By Implementing and populating this schema we will be able to query
>> photoes using different attribute combinations.
>>
>> On Mon, May 28, 2012 at 11:18 PM, Prabhath Suminda
>> <pa...@gmail.com>wrote:
>>
>> > Hi,
>> >
>> > A created this Google doc to show the current progress of the project.
>> > Please review it and give feedback.
>> >
>> >
>> >
>> https://docs.google.com/document/d/1fEGQZiuwr0GNUyYcngJru2-g4oUMN5zK0_zVdfwLwGY/edit
>> >
>> >
>> > The metadata I have planned to impalement is photo nick name (e.g
>> > my favorite photo),, date, time, people in it, location. Are there any
>> > missing ones? After I finalized this requirement I will design a database
>> > schema for storing these stuff and submit it for review.
>> >
>> > Regards,
>> > Prabhath
>> >
>> >
>>
>
>
>
> --
> Avdhesh Yadav
> http://www.avdheshyadav.com
> http://twitter.com/yadavavdhesh