gblog
Tables (9)
blog_board
- brdNo — PK — Primary key — NOT NULL
- bNo — FK — Foreign key → blog_info.bNo — NOT NULL
- cName — NN — Foreign key → blog_category.cName
- brdHeader — N
- oriBrdHeader — N
- subject — NN
- content — NN
- brdDate — NN
- hit — NN
- basicSet — NN
blog_brdLike
- likeNo — PK — Primary key — NOT NULL
- brdNo — FK — Foreign key → blog_board.brdNo — NOT NULL
- likeMid — FK — Foreign key → member.mId — NOT NULL
blog_category
- bNo — FK — Foreign key → blog_info.bNo — NOT NULL
- cName — PK
- cIndex — NN
blog_comment
- cmtNo — PK — Primary key — NOT NULL
- brdNo — FK — Foreign key → blog_board.brdNo — NOT NULL
- cmtBasicSet — NN
- cmtMid — NN
- cmtBlame — NN
- cmtDate — NN
- cmtContent — NN
- cmtRepl — N
blog_info
- bNo — PK — Primary key — NOT NULL
- mId — FK — Foreign key → member.mId — NOT NULL
- opened — NN
- bTitle — NN
- nName — NN
- bSkin — NN
- mPhoto — N
- oriMphoto — N
- hFile — N
- oriHfile — N
files
- fileNo — PK — Primary key — NOT NULL
- brdNo — FK — Foreign key → blog_board.brdNo — NOT NULL
- cName — NN — Foreign key → blog_board.cName
- fName — NN
- oriFname — NN
member
- mId — PK — Primary key — NOT NULL
- email — NN
- pwd — NN
- mName — NN
- phone — UK
- birth — NN
statistics
- scoNo — PK — Primary key — NOT NULL
- scoId — NN
- scoDate — NN
tag
- tNo — PK — Primary key — NOT NULL
- brdNo — FK — Foreign key → blog_board.brdNo — NOT NULL
- tContent — NN