intern_board

Tables (8)

TB_BOARD (tb_board)

  • BOARD_ID (bid) — INT(6) — Primary key — NOT NULL
  • MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_MEMBER.MEMBER_EMAIL
  • BOARD_TITLE (title) — varchar(70) — NOT NULL
  • BOARD_CONTENT (content) — varchar(350) — NOT NULL
  • BOARD_LIKE (like) — int(6) — NOT NULL
  • BOARD_HATE (hate) — int(6) — NOT NULL
  • BOARD_VIEW (view) — int(6) — NOT NULL
  • BOARD_REGDATE (regdate) — date — NOT NULL
  • BOARD_UPDATE (update) — date

TB_BOARD_HATE (tb_boardhate)

  • BOARD_ID (bid) — INT(6) — Foreign key → TB_BOARD.BOARD_ID — NOT NULL
  • MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_MEMBER.MEMBER_EMAIL — NOT NULL

TB_BOARD_LIKE (tb_boardlike)

  • BOARD_ID (bid) — INT(6) — Foreign key → TB_BOARD.BOARD_ID — NOT NULL
  • MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_MEMBER.MEMBER_EMAIL — NOT NULL

TB_COMMENT (tb_comment)

  • COMMENT_ID (cid) — INT(6) — Primary key — NOT NULL
  • BOARD_ID (bid) — INT(6) — Foreign key → TB_BOARD.BOARD_ID — NOT NULL
  • MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_MEMBER.MEMBER_EMAIL
  • COMMENT_CONTENT (content) — varchar(150) — NOT NULL
  • COMMENT_LIKE (like) — int(6) — NOT NULL
  • COMMENT_HATE (hate) — int(6) — NOT NULL
  • COMMENT_REGDATE (regdate) — datetime — NOT NULL
  • COMMENT_UPDATE (update) — datetime
  • COMMENT_GRP (grp) — int(6)
  • COMMENT_FLOW (flow) — int(6)

TB_COMMENT_HATE (tb_commenthate)

  • COMMENT_ID (cid) — INT(6) — Foreign key → TB_COMMENT.COMMENT_ID — NOT NULL
  • MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_COMMENT.MEMBER_EMAIL

TB_COMMENT_LIKE (tb_commentlike)

  • COMMENT_ID (cid) — INT(6) — Foreign key → TB_COMMENT.COMMENT_ID — NOT NULL
  • MEMBER_EMAIL (email) — varchar(50) — Foreign key → TB_COMMENT.MEMBER_EMAIL

TB_FILE (tb_file)

  • FILE_ID (fid) — varchar(32) — Primary key — NOT NULL
  • BOARD_ID (bid) — INT(6) — Foreign key → TB_BOARD.BOARD_ID — NOT NULL
  • FILE_NAME (name) — varchar(70) — NOT NULL
  • FILE_PATH (path) — varchar(100) — NOT NULL
  • FILE_EXTENSION (extension) — varchar(10) — NOT NULL
  • FILE_DOWN (down) — int(10) — NOT NULL

TB_MEMBER (tb_member)

  • MEMBER_EMAIL (email) — varchar(50) — Primary key — NOT NULL
  • MEMBER_PASSWORD (password) — varchar(50) — NOT NULL
  • MEMBER_NICKNAME (nickname) — varchar(30) — NOT NULL