react_project
Tables (12)
commentLikes
- likeId — INT
- commentId — INT
- userId — VARCHAR(50)
comments
- commentId — INT
- postId — INT
- userId — VARCHAR(50)
- content — TEXT
- createdAt — DATETIME
convoUsers
- id — INT
- convoId — INT
- userId — VARCHAR(50)
- joinedAt — DATETIME
convos
- convoId — INT
- createdAt — DATETIME
files
- fileId — INT
- path — VARCHAR(255)
- mime — VARCHAR(50)
- createdAt — DATETIME
follows
- followId — INT
- fromUser — VARCHAR(50)
- toUser — VARCHAR(50)
- createdAt — DATETIME
messages
- msgId — INT
- convoId — INT
- senderId — VARCHAR(50)
- content — TEXT
- createdAt — DATETIME
- isRead — BOOLEAN
notis
- notiId — INT
- userId — VARCHAR(50)
- type — VARCHAR(30)
- msg — VARCHAR(255)
- isRead — BOOLEAN
- createdAt — DATETIME
postImgs
- postId — INT — Primary key
- imgId — INT
- url — VARCHAR(255)
- sort — INT
postLikes
- likeId — INT
- postId — INT
- userId — VARCHAR(50)
- likedAt — DATETIME
stories
- storyId — INT
- userId — VARCHAR(50)
- imgUrl — VARCHAR(255)
- text — VARCHAR(255)
- createdAt — DATETIME
- expiredAt — DATETIME
- archived — BOOLEAN
users
- userId — VARCHAR(50)
- email — VARCHAR(100)
- pw — VARCHAR(255)
- nick — VARCHAR(30)
- bio — TEXT
- profileImg — VARCHAR(255)
- phone — VARCHAR(20)
- createdAt — DATETIME
- updatedAt — DATETIME
- isDeleted — BOOLEAN