sculpture House
Tables (3)
comment (Untitled3)
- 기본키 (comment_id) — int — Primary key — NOT NULL
- 기본키 (post_id) — int — Foreign key → post.기본키 — NOT NULL
- 기본키 (group_id) — int — Foreign key → post.기본키 — NOT NULL
- nickname — string
- content (commentContent) — string
- createdAT — TIMESTAMPTZ
group (Untitled)
- 기본키 (group_id) — int — Primary key — NOT NULL
- 이름 (name) — string
- password — string
- 이미지 (groupImageUrl) — string
- 공개여부 (groupIsPublic) — boolean
- 소개글 (introduction) — string
- 좋아요수 (gorupLikeCount) — int
- 게시글수 (groupPostCount) — int
- createdAt — TIMESTAMPTZ
post (Untitled2)
- 기본키 (post_id) — int — Primary key — NOT NULL
- 기본키 (group_id) — int — Foreign key → group.기본키 — NOT NULL
- nickname — string
- title — string
- content — string
- postPassword — string
- groupPasswor (groupPassworod) — string
- imageUrl (postImageUrl) — string
- tags — text[]
- location — string
- moment — DATE
- ispublic (postIsPublic) — boolean
- likeCount (postLikeCount) — int
- commentCount — int
- createdAtc (createdAt) — TIMESTAMPTZ