Cldong

Tables (5)

board_tb (게시글)

  • bId — VARCHAR — Primary key — NOT NULL
  • uId — VARCHAR — Foreign key → user_tb.uId — NOT NULL
  • vId — VARCHAR — Foreign key → video_tb.vId — NOT NULL
  • modDate — DATETIME
  • regDate — DATETIME
  • bTitle — VARCHAR
  • bContent — VARCHAR

log_tb (로그)

  • lId — VARCHAR — Primary key — NOT NULL
  • bId — VARCHAR — Foreign key → board_tb.bId — NOT NULL
  • uId — VARCHAR — Foreign key → board_tb.uId — NOT NULL

reply_tb (댓글)

  • rId — VARCHAR — Primary key — NOT NULL
  • bId — VARCHAR — Foreign key → board_tb.bId — NOT NULL
  • uId — VARCHAR — Foreign key → user_tb.uId — NOT NULL
  • content — VARCHAR
  • regDate — DATETIME
  • modDate — DATETIME

user_tb (회원)

  • uId — VARCHAR — Primary key — NOT NULL
  • password — VARCHAR
  • nickname — VARCHAR
  • email — VARCHAR
  • regDate — DATETIME
  • modDate — DATETIME
  • rol — VARCHAR

video_tb (비디오)

  • vId — VARCHAR — Primary key — NOT NULL
  • orgn — VARCHAR
  • name — VARCHAR
  • vol — VARCHAR
  • tag — VARCHAR
  • regDate — DATETIME
  • size — VARCHAR