초안

테이블 (7)

Friend List (Untitled)

  • Key (id) — uuid — 기본 키 — NOT NULL
  • Field (requesrUserId) — uuid
  • Field2 (receiptUserId) — uuid
  • Field (state) — FriendState

Friend Notification (Untitled5)

  • Key (id) — uuid — 기본 키 — NOT NULL
  • Field (notificationId) — uuid
  • Field (FriendListId) — uuid

Notification (Untitled4)

  • Key (id) — uuid — 기본 키 — NOT NULL
  • Field (type) — varchar
  • Field (title) — varchar
  • Field (message) — varchar
  • Field (href) — varchar
  • Field (view) — boolean

User (user)

  • 유저ID (id) — uuid — 기본 키 — NOT NULL
  • 이름 (nickname) — varchar
  • 프로필사진 (thumbnail) — varchar
  • 이메일 (email) — varchar
  • 농인/청인 (userType) — UserType

User Social (Untitled3)

  • Key (id) — uuid — 기본 키 — NOT NULL
  • Field (userId) — uuid
  • Field2 (socialId) — uuid
  • Field3 (socialType) — SocialType

Video Telegraphy (Untitled2)

  • Key (id) — uuid — 기본 키 — NOT NULL
  • Field (code) — varchar
  • Field (requestUserId) — uuid
  • Field (receiptUserId) — uuid
  • Field (mic1) — boolean
  • Field (camera) — boolean
  • Field (mic2) — boolean
  • Field (camera2) — boolean

Video Telegraphy Notification (Untitled6)

  • Key (id) — uuid — 기본 키 — NOT NULL
  • Field (notificationId) — uuid
  • Field (videoTelegraphyId) — uuid