Hi-Teen

Tables (6)

boards (게시판)

  • 게시글 ID (id) — INT — Primary key — NOT NULL
  • 멤버 ID (member_id) — INT — Foreign key → members.멤버 ID — NOT NULL
  • 내용 (content) — text
  • 생성 날짜 (created_at) — TimeStamp
  • 수정 날짜 (updated_at) — TimeStamp
  • 삭제 날짜 (deleted_at) — TimeStamp

comments (댓글)

  • 댓글 ID (id) — INT — Primary key — NOT NULL
  • 멤버 ID (member_id) — INT — Foreign key → members.멤버 ID — NOT NULL
  • 게시글 ID (board_id) — INT — Foreign key → boards.게시글 ID — NOT NULL
  • 내용 (content) — text
  • 생성 날짜 (created_at) — TimeStamp
  • 수정 날짜 (updated_at) — TimeStamp
  • 삭제 날짜 (deleted_at) — TimeStamp

loves (좋아요)

  • 좋아요 ID (id) — INT — Primary key — NOT NULL
  • 멤버 ID (member_id) — INT — Foreign key → members.멤버 ID — NOT NULL
  • 게시글 ID (board_id) — INT — Foreign key → boards.게시글 ID — NOT NULL
  • 좋아요 수 (count) — INT
  • 생성 날짜 (created_at) — TimeStamp
  • 수정 날짜 (updated_at) — TimeStamp
  • 삭제 날짜 (deleted_at) — TimeStamp
  • Field

members (사용자)

  • 멤버 ID (id) — INT — Primary key — NOT NULL
  • 아이디 (email) — VARCHAR(100)
  • 비밀번호 (password) — VARCHAR(100)
  • 이름 (name) — VARCHAR(50)
  • 닉네임 (nickname) — VARCHAR(50)
  • 학교 (school) — VARCHAR(100)
  • 나이 (age) — INT
  • 반 (class) — INT
  • 생성 날짜 (created_at) — TimeStamp
  • 수정 날짜 (updated_at) — TimeStamp
  • 삭제 날짜 (deleted_at) — TimeStamp

rooms (쪽지방)

  • 쪽지방 ID (id) — INT — Primary key — NOT NULL
  • 멤버 ID (member_id) — INT — Foreign key → members.멤버 ID — NOT NULL
  • 게시글 ID (board_id) — INT — Foreign key → boards.게시글 ID — NOT NULL
  • 내용 (text) — text
  • 생성 날짜 (created_at) — TimeStamp
  • 수정 날짜 (updated_at) — TimeStamp
  • 삭제 날짜 (deleted_at) — TimeStamp
  • Field

scrap (스크랩)

  • 스크랩 ID (id) — INT — Primary key — NOT NULL
  • 게시글 ID (board_id) — INT — Foreign key → boards.게시글 ID — NOT NULL
  • 멤버 ID (id2) — INT — Foreign key → members.멤버 ID — NOT NULL
  • 스크랩 수 (count) — INT
  • 생성 날짜 (created_at) — TimeStamp
  • 수정 날짜 (updated_at) — TimeStamp
  • 삭제 날짜 (deleted_at) — TimeStamp