Blog

Home
Blog System Design

blog

forum

topic

subject

post

Table

Description

Fields

blog
Name of blog, Image for blog etc
blogNum SMALLINT(5)
blogName VARCHAR(60)
imageId VARCHAR(50)
urlName VARCHAR(50)
url VARCHAR(50)
msg TEXT

- forum
Forums allowed on blog forumNum INT(4)
forumName VARCHAR(50)
forumDescr TEXT

-- topic
Topics allowed for each forum topicNum INT(5)
forumNum INT(5)
topicName VARCHAR(50)
topicDescr TEXT

--- subject
Subjects users post against topics subjectNum INT(5)
topicNum INT(5)
subjectName VARCHAR(50)
subjectDescr TEXT
subjectDate DATE
viewCount INT(5)

---- post
Post about topics supplied by users postNum INT(5)
subjectNum INT(5)
postDate DATETIME
userNum INT(5)

user
Users allowed to sign up userNum INT(5)
userName VARCHAR(20)
passWord VARCHAR(20)
dispName VARCHAR(20)
eMail VARCHAR(100)
shoEmail CHAR(3)
birthYear SMALLINT(4)
birthMonth TINYINT(2)
birthDay TINYINT(2)
shoBirth CHAR(3)
gender CHAR(1)
shoGender CHAR(3)
canMaint CHAR(3);

Table	Description	Fields
blog	Name of blog, Image for blog etc	blogNum SMALLINT(5) blogName VARCHAR(60) imageId VARCHAR(50) urlName VARCHAR(50) url VARCHAR(50) msg TEXT
- forum	Forums allowed on blog	forumNum INT(4) forumName VARCHAR(50) forumDescr TEXT
-- topic	Topics allowed for each forum	topicNum INT(5) forumNum INT(5) topicName VARCHAR(50) topicDescr TEXT
--- subject	Subjects users post against topics	subjectNum INT(5) topicNum INT(5) subjectName VARCHAR(50) subjectDescr TEXT subjectDate DATE viewCount INT(5)
---- post	Post about topics supplied by users	postNum INT(5) subjectNum INT(5) postDate DATETIME userNum INT(5)
user	Users allowed to sign up	userNum INT(5) userName VARCHAR(20) passWord VARCHAR(20) dispName VARCHAR(20) eMail VARCHAR(100) shoEmail CHAR(3) birthYear SMALLINT(4) birthMonth TINYINT(2) birthDay TINYINT(2) shoBirth CHAR(3) gender CHAR(1) shoGender CHAR(3) canMaint CHAR(3);