hj

Tables (3)

board (공지사항)

  • boardno (글번호) — number — Primary key — NOT NULL
  • title (제목) — varchar(100)
  • content (내용) — varchar(3000)
  • writer (작성자) — varchar(50)
  • view (조회수) — number
  • like (좋아요 수) — number
  • date (작성일) — date

boardfile (공지사항이미지)

  • fileno (이미지번호) — number — Primary key — NOT NULL
  • boardno (공지사항번호) — number — Foreign key → board.boardno — NOT NULL
  • storedname (저장된이름) — varchar(500)
  • originname (원래이름) — varchar(500)

boardlike (공지사항좋아요)

  • likeno (좋아요pk) — number — Primary key — NOT NULL
  • boardno (글번호) — number — Foreign key → board.boardno — NOT NULL
  • userid (좋아요한사람) — varchar(50)