my_instgram
Tables (7)
Comment
- Key (commentIdx) — INT — Primary key — NOT NULL
- Field (content) — VARCHAR(100) — NOT NULL
- Field (parentCommentIdx) — INT — NOT NULL
- Field (status) — VARCHAR(10) — NOT NULL
- Field (createdAt) — TIMESTAMP — NOT NULL
- Field (updatedAt) — TIMESTAMP — NOT NULL
- Key (postIdx) — INT — Foreign key → Post.Key — NOT NULL
- Key (userIdx) — INT — Foreign key → User.Key — NOT NULL
CommentLike
- Key (commentLikeIdx) — INT — Primary key — NOT NULL
- Field (userIdx) — INT — NOT NULL
- Field (status) — VARCHAR(10) — NOT NULL
- Field (createdAt) — TIMESTAMP — NOT NULL
- Field (updatedAt) — TIMESTAMP — NOT NULL
- Key (commentIdx) — INT — Foreign key → Comment.Key — NOT NULL
Follow
- Key (followIdx) — INT — Primary key — NOT NULL
- Field (status) — VARCHAR(10) — NOT NULL
- Field (createdAt) — TIMESTAMP — NOT NULL
- Field (updatedAt) — TIMESTAMP — NOT NULL
- Key (followerIdx) — INT — Foreign key → User.Key — NOT NULL
- Key (followeeIdx) — INT — Foreign key → User.Key — NOT NULL
Post
- Key (postIdx) — INT — Primary key — NOT NULL
- Field (content) — VARCHAR(300) — NOT NULL
- Field (status) — VARCHAR(10) — NOT NULL
- Field (createdAt) — TIMESTAMP — NOT NULL
- Field (updatedAt) — TIMESTAMP — NOT NULL
- Key (userIdx) — INT — Foreign key → User.Key — NOT NULL
PostImgUrl
- Key (postImgUrlIdx) — INT — Primary key — NOT NULL
- Field (imgUrl) — TEXT — NOT NULL
- Field (status) — VARCHAR(10) — NOT NULL
- Field (createdAt) — TIMESTAMP — NOT NULL
- Field (updatedAt) — TIMESTAMP — NOT NULL
- Key (postIdx) — INT — Foreign key → Post.Key — NOT NULL
Postlike (PostLike)
- Key (postLikeIdx) — INT — Primary key — NOT NULL
- Field (status) — VARCHAR(45) — NOT NULL
- Field (createdAt) — TIMESTAMP — NOT NULL
- Field (updatedAt) — TIMESTAMP — NOT NULL
- Key (userIdx) — INT — Foreign key → User.Key — NOT NULL
- Key (postIdx) — INT — Foreign key → Post.Key — NOT NULL
User
- Key (userIdx) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR(10) — NOT NULL
- Field (nickName) — VARCHAR(30) — NOT NULL
- Field (email) — VARCHAR(255) — NOT NULL
- Field (pwd) — VARCHAR(20) — NOT NULL
- Field (profileImgUrl) — TEXT — NOT NULL
- Field (gender) — VARCHAR(10)
- Field (birth) — DATE
- Field (website) — VARCHAR(45)
- Field (introduction) — VARCHAR(450)
- Field (status) — VARCHAR(10) — NOT NULL
- Field (createdAt) — TIMESTAMP — NOT NULL
- Field (updatedAt) — TIMESTAMP — NOT NULL