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