NTS
Tables (6)
Comment (Untitled2)
- pk (댓글PK) — bigint — Primary key — NOT NULL
- pk (회원PK) — bigint — Foreign key → Member.pk — NOT NULL
- pk (게시글PK) — bigint — Foreign key → Post.pk — NOT NULL
- content (내용) — String
- parent (부모PK) — bigint
- isDeleted (삭제여부) — boolean
HashTag (Untitled5)
- pk (태그PK) — bigint — Primary key — NOT NULL
- name (이름) — String
Likes (Untitled4)
- pk (좋아요PK) — bigint — Primary key — NOT NULL
- pk (회원PK) — bigint — Foreign key → Member.pk — NOT NULL
- pk (게시글PK) — bigint — Foreign key → Post.pk — NOT NULL
Member (Untitled3)
- pk (회원PK) — bigint — Primary key — NOT NULL
- email (이메일) — String
- password (비밀번호) — String
- nickname (닉네임) — String
Post (Untitled)
- pk (게시글PK) — bigint — Primary key — NOT NULL
- pk (회원PK) — bigint — Foreign key → Member.pk — NOT NULL
- title (제목) — String
- content (본문) — String
- createdAt (등록시간) — LocalDateTime
- views (조회수) — bigint
- likes (좋아요수) — bigint
PostTag (Untitled6)
- pk (Key) — bigint — Primary key — NOT NULL
- pk (게시글PK) — bigint — Foreign key → Post.pk — NOT NULL
- pk (태그PK) — bigint — Foreign key → HashTag.pk — NOT NULL