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