게시판
테이블 (7)
Comment
- commentIdx — int — 기본 키
- userIdx — int — NOT NULL
- postIdx — int — NOT NULL
- content — varchar(100) — NOT NULL
- parentCommentIdx — int — NOT NULL
- status — varchar(10) — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
CommentLike
- commentLikeIdx — int — 기본 키
- commentIdx — int — NOT NULL — 댓글 식별자
- userIdx — int — NOT NULL — 유저 식별자
- status — varchar(10) — NOT NULL
- createdAt — timestamp
- updatedAt — timestamp
Follow
- followIdx — int — 기본 키
- followerIdx — int — NOT NULL
- followeeIdx — int — NOT NULL
- status — varchar(10) — NOT NULL
- createdAt — timestamp
- updatedAt — timestamp
Post
- postIdx — int — 기본 키
- userIdx — int — NOT NULL
- content — varchar(300) — NOT NULL
- status — varchar(10) — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
PostImgUrl
- postImgUrlIdx — int — 기본 키
- postIdx — int — NOT NULL
- imgUrl — text — NOT NULL
- status — varchar(10) — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL
PostLike
- postLikeIdx — int — 기본 키
- postIdx — int — NOT NULL — 댓글 식별자
- userIdx — int — NOT NULL — 유저 식별자
- status — varchar(10) — NOT NULL
- createdAt — timestamp
- updatedAt — timestamp
User
- userIdx — int — 기본 키
- name — varchar(45) — NOT NULL
- nickname — varchar(45) — NOT NULL
- email — varchar(255) — NOT NULL
- pwd — varchar(255) — NOT NULL
- profileImgUrl — text — NOT NULL
- website — varchar(45)
- introduce — varchar(45)
- status — varchar(10) — NOT NULL
- createdAt — timestamp — NOT NULL
- updatedAt — timestamp — NOT NULL