classum

Tables (8)

Chat

  • Id (id) — INT(11) — Primary key — NOT NULL
  • Content (content) — TEXT
  • Anonymous (anonymous) — BOOLEAN
  • Id (postId) — INT(11) — Foreign key → Post.Id — NOT NULL
  • Id (userId) — INT(11) — Foreign key → User.Id — NOT NULL
  • Id (parentId) — INT(11) — Foreign key → Chat.Id — NOT NULL

Interaction

  • Id (id) — INT(11) — Primary key — NOT NULL
  • Id (postId) — INT(11) — Foreign key → Post.Id — NOT NULL
  • Id (chatId) — INT(11) — Foreign key → Chat.Id — NOT NULL
  • Id (userId) — INT(11) — Foreign key → User.Id — NOT NULL
  • Id (spaceId) — INT(11) — Foreign key → Space.Id — NOT NULL

Post

  • Id (id) — INT(11) — Primary key — NOT NULL
  • Title (title) — INT(20)
  • Content (content) — TEXT
  • Type (type) — VARCHAR(30)
  • Anonymous (anonymous) — BOOLEAN
  • AttachmentUrl (attachmentUrl) — VARCHAR(255)
  • Id (spaceId) — INT(11) — Foreign key → Space.Id — NOT NULL
  • Id (userId) — INT(11) — Foreign key → User.Id — NOT NULL
  • Field

Space

  • Id (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(10)
  • Logo (logo) — VARCHAR(255)
  • OwnerId (ownerId) — INT(11)
  • AdminCode (adminCode) — INT(11)
  • ParticipantCode (participantCode) — INT(11)

SpaceRole

  • Id (id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(30)
  • Type (type) — VARCHAR(30)
  • Id (spaceId) — INT(11) — Foreign key → Space.Id — NOT NULL

User

  • Id (id) — INT(11) — Primary key — NOT NULL
  • Email (email) — VARCHAR(30)
  • Password (password) — VARCHAR(30)
  • Name (name) — VARCHAR(10)
  • Gender (gender) — VARCHAR(10)
  • ProfileImage (profileImage) — VARCHAR(255)

UserPostStatus

  • Id (id) — INT(11) — Primary key — NOT NULL
  • LastChecked (lastChecked) — DATE
  • Field
  • Id (userId) — INT(11) — Foreign key → User.Id — NOT NULL
  • Id (postId) — INT(11) — Foreign key → Post.Id — NOT NULL

UserSpace

  • Id (id) — INT(11) — Primary key — NOT NULL
  • RoleName (roleName) — VARCHAR(10)
  • Id (userId) — INT(11) — Foreign key → User.Id — NOT NULL
  • Id (spaceId) — INT(11) — Foreign key → Space.Id — NOT NULL