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