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)