2.4.1.2 Schema Design & ERD

Below is an example set of core tables relevant to SUM+1:

1. Users

• Stores login credentials, roles, wallet addresses.

• Example columns: id, username, email, passwordHash, walletAddress, role.

2. Posts

• Represents social feed posts.

• Example columns: id, userId (FK to Users), content, createdAt.

3. Comments

• Linked to posts for discussions.

• Example columns: id, postId, userId, content, createdAt.

4. Trades

• Records user trades (either direct or copy trades).

• Example columns: id, userId, coinSymbol, tradeType (BUY/SELL), quantity, price, createdAt.

5. Syndicates

• Groups of users pooling resources or collaborating.

• Example columns: id, name, ownerId, createdAt.

6. SyndicateMembers

• Many-to-many link table for users in a syndicate.

• Example columns: syndicateId, userId, role (OWNER, MEMBER), sharePercentage.

7. ChatMessages (optional)

• If storing chat history for compliance or user reference.

• Example columns: id, channelId, userId, content, createdAt.

 ┌───────────┐         ┌─────────────┐
 │   Users   │1       *│   Posts     │
 └───────────┘         └─────────────┘
       │                     │
       │1                  * │ (one user can have many posts)
       ▼                     ▼
 ┌───────────┐         ┌─────────────┐
 │ Comments  │*       1│   Trades    │
 └───────────┘         └─────────────┘
       ...                ...