ㅇ

Tables (7)

Comment

  • commentIdx — INT — Primary key — NOT NULL
  • postIdx — INT — Foreign key → Post.postIdx — NOT NULL
  • userIdx — INT — Foreign key → User.userIdx — NOT NULL
  • comment — VARCH(100)
  • commentAnonymous — BOOLEAN — NOT NULL
  • commentLike — INT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

CommentLike

  • commentLikeIdx — INT — Primary key — NOT NULL
  • userIdx — INT — Foreign key → User.userIdx — NOT NULL
  • commentIdx — INT — Foreign key → Comment.commentIdx — NOT NULL

CommentReply

  • commentRelyIdx — INT — Primary key — NOT NULL
  • commentIdx — INT — Foreign key → Comment.commentIdx — NOT NULL
  • userIdx — INT — Foreign key → User.userIdx — NOT NULL
  • commentReply — INT
  • commentReplyAnonymous — BOOLEAN — NOT NULL
  • commentReplyLike — INT
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

CommentReplyLike

  • commentReplyLikeIdx — INT — Primary key — NOT NULL
  • userIdx — INT — Foreign key → User.userIdx — NOT NULL
  • commentRelyIdx — INT — Foreign key → CommentReply.commentRelyIdx — NOT NULL

Post

  • postIdx — INT — Primary key — NOT NULL
  • userIdx — INT — Foreign key → User.userIdx — NOT NULL
  • postTitle — VARCH(30) — NOT NULL
  • postContent — VARCH(300) — NOT NULL
  • postAnonymous — BOOLEAN — NOT NULL
  • postImage — TEXT
  • postLike — INT — NOT NULL
  • buildingName — VARCHAR(20) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • chatRoomTitle — VARCHAR(20) — NOT NULL

PostLike

  • postLikeIdx — INT — Primary key — NOT NULL
  • userIdx — INT — Foreign key → User.userIdx — NOT NULL
  • postIdx — INT — Foreign key → Post.postIdx — NOT NULL

User

  • userIdx — INT — Primary key — NOT NULL
  • email — VARCH(30) — NOT NULL
  • password — VARCH(30) — NOT NULL
  • nickName — VARCH(30) — NOT NULL
  • university — VARCH(30) — NOT NULL
  • phone — VARCH(11) — NOT NULL
  • longitude — DECIMAL(10, 7)
  • latitude — DECIMAL(10, 7)
  • profileImage — TEXT
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL