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