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