The database schema is quite simple. It just has two tables, Albums and Photos related together by a one-to-many relationship called FK_Photos_Albums, each album consists of several photoes. The fields in each table are:
Albums
===========================================
AlbumID int IDENTITY (1, 1) NOT NULL : The primary key of the table
Caption nvarchar (50) COLLATE Arabic_CI_AS NOT NULL : The title of the album
IsPublic bit NOT NULL : If 1, the album will be shown to all visitors, if 0 it will only be shown to members
Photoes
===========================================
PhotoID int IDENTITY (1 1) NOT NULL : The primary key of the table
AlbumID int NOT NULL : Foreign key to Albums table
Caption nvarchar (100) COLLATE Arabic_CI_AS NOT NULL : Title of the picture
BytesOriginal image NOT NULL : Original size of the picture
BytesFull image NOT NULL : Size of the picture in large size (600 pixels)
BytesPoster image NOT NULL : Size of the picture in medium size (198 pixels)
BytesThumb image NOT NULL : Size of the picture in thumbnail mode (100 pixels, shown in the details.aspx page)
Reza Nassabeh
Don't forget to click Mark as Answer on the post that helped. That way future readers will know which post solved the issue.
Member
1 Points
2 Posts
personal starter kit database structure
Jan 16, 2008 02:04 AM|Ebraheem|LINK
dear friends,
I am nearly new to ASP.net, and I am now working on the personal starter kit project in order to build my personal website and
at the same time I consider it a good beggining to learn, so Please could someone explain to me the structer of the database included
in this project and its realtions and fields purposes.
thank you very much my dear friends,[:)]
Contributor
2174 Points
502 Posts
Re: personal starter kit database structure
Jan 23, 2008 07:31 AM|r_nassabeh|LINK
The database schema is quite simple. It just has two tables, Albums and Photos related together by a one-to-many relationship called FK_Photos_Albums, each album consists of several photoes. The fields in each table are:
Albums
===========================================
AlbumID int IDENTITY (1, 1) NOT NULL : The primary key of the table
Caption nvarchar (50) COLLATE Arabic_CI_AS NOT NULL : The title of the album
IsPublic bit NOT NULL : If 1, the album will be shown to all visitors, if 0 it will only be shown to members
Photoes
===========================================
PhotoID int IDENTITY (1 1) NOT NULL : The primary key of the table
AlbumID int NOT NULL : Foreign key to Albums table
Caption nvarchar (100) COLLATE Arabic_CI_AS NOT NULL : Title of the picture
BytesOriginal image NOT NULL : Original size of the picture
BytesFull image NOT NULL : Size of the picture in large size (600 pixels)
BytesPoster image NOT NULL : Size of the picture in medium size (198 pixels)
BytesThumb image NOT NULL : Size of the picture in thumbnail mode (100 pixels, shown in the details.aspx page)
Don't forget to click Mark as Answer on the post that helped. That way future readers will know which post solved the issue.