community-hub
Tables (4)
Comments
- commentsId — Int — Primary key — NOT NULL
- UserId — Int — Foreign key → Users.userId — NOT NULL
- PostId — Int — Foreign key → Posts.postId — NOT NULL
- content — String
- createdAt — DateTime
- updatedAt — DateTime
- deletedAt — DateTime
Posts
- postId — Int — Primary key — NOT NULL
- UserId — Int — Foreign key → Users.userId — NOT NULL
- title (email) — String — NOT NULL
- content — String — NOT NULL
- createdAt — DateTime — NOT NULL
- updatedAt — DateTime — NOT NULL
- deletedAt — DateTime
Users
- userId — Int — Primary key — NOT NULL
- email — String — NOT NULL
- password — String — NOT NULL
- createdAt — DateTime — NOT NULL
- updatedAt — DateTime — NOT NULL
- deletedAt — DateTime
UsersInfos
- userInfoId — Int — Primary key — NOT NULL
- UserId — Int — Foreign key → Users.userId — NOT NULL
- name — String — NOT NULL
- age — Int
- gender — String — NOT NULL
- profileImage — String
- createdAt — DateTime — NOT NULL
- updatedAt — DateTime — NOT NULL
- deletedAt — DataTime