bb

Tables (4)

board_file_table

  • id — Long — Primary key — NOT NULL
  • boardId — Long — Foreign key → board_table.id — NOT NULL
  • originalFileName — varcher — NOT NULL
  • storedFileName — varcher — NOT NULL

board_table (Untitled2)

  • id — Long — Primary key — NOT NULL
  • memberId — Long — Foreign key → member_table.id — NOT NULL
  • boardWriter — varcher — NOT NULL
  • boardType — archer — NOT NULL
  • boardTitle — varchar — NOT NULL
  • boardContents — varcher — NOT NULL
  • boardCreatedTime — datetime — NOT NULL
  • boardView — Long — NOT NULL
  • fileAttached — int

cmt_table

  • id — Long — Primary key — NOT NULL
  • boardId — Long — Foreign key → board_table.id — NOT NULL
  • memberId — Long — Foreign key → board_table.memberId — NOT NULL
  • cmtWiter (cmtWriter) — varcher — NOT NULL
  • cmtContents — varcher — NOT NULL
  • cmtCreatedTime — datetime — NOT NULL

member_table (Untitled)

  • id — Long — Primary key — NOT NULL
  • memberEmail — varchar — NOT NULL — unique
  • memberPw — varcher — NOT NULL
  • memberName — varchar — NOT NULL