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 <[email protected]> wrote: > 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
