Cook Log.ver1.2
Tables (9)
BlackList (blacklist)
- 블랙리스트 id (id) — BIGINT — Primary key — NOT NULL
- 회원 idx (idx) — BIGINT — Foreign key → User.회원 idx
- 생성 시간 (created_at) — timestamp
Board (board)
- Board Id (id) — BIGINT — Primary key
- 회원 idx (user_idx) — BIGINT — Foreign key → User.회원 idx
- 내용 (content) — string
- 생성시간 (created_at) — timestamp
- 수정시간 (updated_at) — timestamp
- 조회수 (readcnt) — int
Bookmark (bookmard)
- Bookmard Id (id) — BIGINT — Primary key — NOT NULL
- 회원 idx (idx) — BIGINT — Foreign key → User.회원 idx
- Board Id (id2) — BIGINT — Foreign key → Board.Board Id
- 생성시간 (created_at) — timestamp
Comment (comment)
- Comment ID (id) — BIGINT — Primary key
- Board Id (board_id) — BIGINT — Foreign key → Board.Board Id
- 회원 idx (user_idx) — BIGINT — Foreign key → User.회원 idx
- 내용 (content) — string
- 생성시간 (created_at) — timestamp
- 수정시간 (updated_at) — timestamp
- 부모 id (parent_comment_id) — BIGINT — NOT NULL
Follow (follow)
- Follow id (id) — BIGINT — Primary key
- 팔로워 id (follower_id) — BIGINT — Foreign key → User.회원 idx
- 팔로잉 id (following_id) — BIGINT — Foreign key → User.회원 idx
Image (image)
- Image Id (id) — BIGINT — Primary key
- Board Id (board_id) — BIGINT — Foreign key → Board.Board Id
- 이미지 이름 (name) — string
- 순서 (order) — int
Likes (likes)
- Likes Id (id) — BIGINT — Primary key
- 회원 idx (user_idx) — BIGINT — Foreign key → User.회원 idx
- Board Id (board_id) — BIGINT — Foreign key → Board.Board Id
Tag (tag)
- Tag Id (id) — BIGINT — Primary key
- Board Id (board_id) — BIGINT — Foreign key → Board.Board Id
- 태그명 (name) — string
User (user)
- 회원 idx (idx) — BIGINT — Primary key
- 닉네임 (nickname) — string
- 이메일 (email) — string
- 패스워드 (password) — string
- 소개 (introduction) — string — NOT NULL
- 등급 (role) — string
- 프로필이미지 (profile_image) — string — NOT NULL
- 신고당한횟수 (report_count) — INT
- 탈퇴유무 (is_deleted) — TINYINT