Post edited 11:51 am – February 16, 2010 by admin
what exactly you want to modify in tag table?
- I think that I will use more identifiers for the image (such as the section where the image belongs).
you can add as you wish to tag table
right now it looks like that
[ID] [int] IDENTITY(1,1) NOT NULL,
[ImageId] [int] NOT NULL,
[x0] [int] NOT NULL,
[y0] [int] NOT NULL,
[x1] [int] NOT NULL,
[y1] [int] NOT NULL,
[Name] [nvarchar](255) NOT NULL,
[Description] [nvarchar](max) NULL,
[color] [varchar](20) NULL,
[id_account] [int] NULL,
[email] [varchar](255) NULL,
CONSTRAINT [PK_tag] PRIMARY KEY CLUSTERED
- Another thing about the tag table: the Name and email fields are taken from the person tagged and the id_Account is from the user who did the tag, or am I wrong?
well there are two possibility
- Name and Email is taken from your user database
- Name and email can enter manually user who is tagging photos (in case if there is no user in DB exists)