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