On Thu, May 31, 2012 at 10:37 PM, Prabhath Suminda <[email protected]>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 > <[email protected]>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
