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