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