joongoMarket

테이블 (3)

Untitled (LikedPost)

  • Key (likedPostId) — Int — 기본 키 — NOT NULL
  • Key (postId) — string — 외래 키 → Untitled2.Key — NOT NULL
  • Key (userId) — string — 외래 키 → 회원가입.Key — NOT NULL
  • Field (createdAt) — DateTime

Untitled2 (Post)

  • Key (postId) — string — 기본 키 — NOT NULL
  • Key (author) — string — 외래 키 → 회원가입.Key — NOT NULL
  • Field (title) — string
  • Field (content) — string
  • Field (imgUrl) — string
  • Field (price) — int
  • Field (views) — int
  • Field (region) — string
  • Field (createdAt) — DateTime
  • Field (updatedAt) — DateTime

회원가입 (User)

  • Key (userId) — string — 기본 키 — NOT NULL
  • Field (email) — string
  • Field2 (encryptedPassword) — string
  • Field (writtenPosts) — Post[]
  • Field (likedPosts) — likedPost[]
  • Field (createdAt) — DateTime