NoticeBoard

Tables (4)

Board (게시판)

  • board_id (게시판ID) — INT — Primary key — NOT NULL
  • writer (작성자) — VARCHAR(50)
  • title (제목) — VARCHAR(50)
  • content (내용) — VARCHAR(1000)
  • registration_date (등록날짜) — DATETIME
  • update_date (수정일자) — DATETIME
  • member_id (멤버ID) — INT — Foreign key → Member.member_id

Member (유저)

  • member_id (멤버ID) — INT — Primary key — NOT NULL
  • id (아이디) — VARCHAR(50)
  • password (비밀번호) — VARCHAR(50)

Photo (사진)

  • photo_id (사진ID) — INT — Primary key — NOT NULL
  • URL (사진URL) — VARCHAR(255)
  • board_id (게시판ID) — INT — Foreign key → Board.board_id — NOT NULL

Reply (댓글)

  • reply_id (댓글ID) — INT — Primary key — NOT NULL
  • writer (작성자) — VARCHAR(50)
  • content (내용) — VARCHAR(300)
  • registration_date (등록일자) — DATETIME
  • update_date (수정일자) — DATETIME
  • board_id (게시판ID) — INT — Foreign key → Board.board_id — NOT NULL