social-chatting

Tables (6)

Direct (direct)

  • id — PK — Primary key — NOT NULL
  • createdAt — Date
  • updatedAt — Date
  • deletedAt — Date

DirectChat (direct_chat)

  • id — PK — Primary key — NOT NULL
  • message
  • userId — FK — Foreign key → User.id — NOT NULL
  • directId — FK — Foreign key → Direct.id — NOT NULL
  • createdAt — Date
  • updatedAt — Date
  • deletedAt — Date

DirectUser (direct_user)

  • id — PK — Primary key — NOT NULL
  • lastNoticedAt
  • userId — FK — Foreign key → Direct.id — NOT NULL
  • directId — FK — Foreign key → User.id — NOT NULL

Follow (follow)

  • id — PK — Primary key — NOT NULL
  • followerId — FK — Foreign key → User.id — NOT NULL
  • followeeId — FK — Foreign key → User.id — NOT NULL
  • followStatus
  • createdAt — Date
  • updatedAt — Date
  • deletedAt — Date

Friend (friend)

  • id — PK — Primary key — NOT NULL
  • userId — FK — Foreign key → User.id — NOT NULL
  • friendId — FK — Foreign key → User.id — NOT NULL
  • friendStatus
  • createdAt — Date
  • updatedAt — Date
  • deletedAt — Date

User (user)

  • id — PK — Primary key — NOT NULL
  • name
  • nickname
  • password
  • createdAt — Date
  • updatedAt — Date
  • deteledAt (deletedAt) — Date