animallove

Tables (6)

BOOKMARKS (Untitled2)

  • bookmarkId (북마크아이디) — Long — Primary key — NOT NULL
  • postId (포스트아이디) — Long — Foreign key → POSTS.postId — NOT NULL
  • userId (유저아이디) — Long — Foreign key → USERS.userId — NOT NULL

COMMENTS (Untitled5)

  • commentId (댓글아이디) — Long — Primary key — NOT NULL
  • userId (유저아이디) — Long — Foreign key → USERS.userId — NOT NULL
  • postId (포스트아이디) — Long — Foreign key → POSTS.postId — NOT NULL
  • userId (유저아이디2) — Long — Foreign key → POSTS.userId — NOT NULL
  • content (내용) — varchar
  • parentId (부모댓글아이디) — varchar

FOLLOWS (Untitled4)

  • followId (팔로우아이디) — Long — Primary key — NOT NULL
  • userId (유저아이디) — Long — Foreign key → USERS.userId — NOT NULL

Image (Untitled6)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

POSTS (Untitled3)

  • postId (포스트아이디) — Long — Primary key — NOT NULL
  • userId (유저아이디) — Long — Foreign key → USERS.userId — NOT NULL
  • content (내용) — varchar
  • image (이미지) — blob

USERS (Untitled)

  • userId (유저아이디) — Long — Primary key — NOT NULL
  • username (유저이름) — varchar
  • email (이메일) — varchar
  • role (역할) — varchar
  • profileImage (프로필이미지) — blob