sampleERD

Tables (6)

Comment (댓글)

  • id (아이디) — UUID — Primary key — NOT NULL
  • parentPost (게시글ID) — Post — Foreign key → Post.id — NOT NULL
  • subComments (답글ID) — Comment[] — Foreign key → Comment.id — NOT NULL
  • creator (글쓴이ID) — User — Foreign key → User.id — NOT NULL

Post (게시글)

  • id (아이디) — UUID — Primary key — NOT NULL
  • title (제목) — String
  • description (내용) — String
  • createdAt (생성일) — Date
  • deletedAt (삭제일) — Date
  • creator (글쓴이ID) — User — Foreign key → User.id — NOT NULL
  • parentSpace (공간ID) — Space — Foreign key → Space.id — NOT NULL
  • images (첨부파일) — Image[]

Space (공간)

  • id (아이디) — UUID — Primary key — NOT NULL
  • name (이름) — String
  • imageSrc (로고) — Image
  • participants (참여자) — User[] — Foreign key → User.id — NOT NULL
  • admins (관리자) — User[] — Foreign key → User.id — NOT NULL
  • creators (소유자) — User[] — Foreign key → User.id — NOT NULL

Space-SpaceRole (BridgeTable)

  • id (spaceId) — UUID — Foreign key → Space.id — NOT NULL
  • id (roleId) — UUID — Foreign key → SpaceRole.id — NOT NULL

SpaceRole (역할)

  • id (아이디) — UUID — Primary key — NOT NULL

User (유저)

  • id (아이디) — UUID — Primary key — NOT NULL
  • email (이메일) — String
  • surname (성) — String
  • name (이름) — String
  • image (사진) — Image
  • createdAt (생성일) — Date
  • deletedAt (삭제일) — Date
  • pwd (비번) — String