memochat
Tables (8)
Chat (Untitled2)
- 챗id (id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- 룸 id (id2) — PrimaryGeneratedColumn — Foreign key → Room.룸 id — NOT NULL
- 메시지 (message)
- 메시지타입 (type) — LINK | TEXT | PHOTO | PHOTOS
- 링크 (link)
- 타이틀 (title)
- 설명 (description)
- 썸네일 (thumbnail)
Photo (Untitled5)
- 포토id (id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- 챗id (id2) — PrimaryGeneratedColumn — Foreign key → Chat.챗id — NOT NULL
- photoUrl (url) — 스토리지 url
- 썸네일 (thumbnail) — 썸네일 url
- 생성일자 (createdAt) — CreateDateColumn
Room (Untitled)
- 룸 id (id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- 유저 id (userId) — Unique Key — Foreign key → User.id — NOT NULL
- id (룸타입id) — Foreign key → RoomType.id — NOT NULL
- 룸 이름 (name) — Max_Length = 20, MinLength = 2
- 방 고정 (pinned) — Default=False
- 생성일자 (createdAt) — CreateDateColumn
- 수정일자 (updatedAt) — UpdateDateColumn
RoomType (Untitled6)
- id (룸타입id) — Primary key — NOT NULL
- 룸 유형 (category) — Max_Length = 20
- 썸네일 (thumbnail) — S3 URL
User (Untitled3)
- id — PrimaryGeneratedColumn — Primary key — NOT NULL
- 이메일 (email) — Unique, MinLength , MaxLength
- 비밀번호 (password) — MinLength , MaxLength
- 닉네임 (nickname) — MaxLength = 20
- 썸네일 (thumbnail) — s3 Url
- 인증여부 (verified) — default =False
- 생성일자 (createdAt) — CreateDateColumn
- 수정일자 (updatedAt) — UpdateDateColumn
- 룸 (Rooms[])
- 챗 (Chats[])
Verfication (Untitled7)
- id — PrimaryGeneratedColumn — Primary key — NOT NULL
- 인증코드 (code)
- 이메일 (email)
- 인증여부 (verified) — default =False
Video (CopyOfUntitled5)
- 포토id (id) — PrimaryGeneratedColumn — Primary key — NOT NULL
- 챗id (id2) — PrimaryGeneratedColumn — Foreign key → Chat.챗id — NOT NULL
- photoUrl (url) — 스토리지 url
- 썸네일 (thumbnail) — 썸네일 url
- 생성일자 (createdAt) — CreateDateColumn