ㅇ
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