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

Untitled4

    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