Figma
Comprehensive database schema for a Figma-like collaborative design platform with organization and team management, design files, page and frame hierarchy, component libraries, version history, comment threads with reactions, file sharing and permissions, and plugin ecosystem.
designcollaborationprototypingdeveloper-tools
MySQL7 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique user identifier
User login email
Hashed authentication password
User display name
Profile avatar image URL
Account creation timestamp
Last profile update timestamp
IXUQCK|💬
MySQL7 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique organization identifier
Organization display name
URL-friendly organization identifier
Organization logo image URL
Billing plan: professional, organization, enterprise
Organization creation timestamp
Last update timestamp
IXUQCK|💬
MySQL6 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique membership record identifier
Organization joined
Member user
Role: admin, editor, viewer
Membership start timestamp
Last update timestamp
IXUQCK|💬
MySQL7 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique team identifier
Organization this team belongs to
Team display name
Team description and purpose
User who created the team
Team creation timestamp
Last update timestamp
IXUQCK|💬
MySQL6 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique team membership record
Team joined
Member user
Role: admin, editor, viewer
When user joined the team
Last update timestamp
IXUQCK|💬
MySQL6 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique project identifier
Team this project belongs to
Project display name
User who created the project
Project creation timestamp
Last update timestamp
IXUQCK|💬
MySQL9 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique file identifier
Project this file belongs to, null if personal
File display name
User who created the file
User who last edited the file
File preview thumbnail URL
Soft-delete flag
File creation timestamp
Last edit timestamp
IXUQCK|💬
MySQL6 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique version identifier
File this version belongs to
Named version label e.g. v2.0 Launch
Version description and changelog notes
User who created this version
Version creation timestamp
IXUQCK|💬
MySQL6 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique page identifier
File this page belongs to
Page display name
Page ordering position
Page creation timestamp
Last update timestamp
IXUQCK|💬
MySQL11 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique frame or layer identifier
Page this frame belongs to
Parent frame for nested components
Frame display name
Node type: frame, component, text, rectangle, etc.
X position on canvas
Y position on canvas
Frame width in pixels
Frame height in pixels
Frame creation timestamp
Last update timestamp
IXUQCK|💬
MySQL7 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique component identifier
File this component belongs to
Frame node that is the component
Component display name
Component usage description
Component creation timestamp
Last update timestamp
IXUQCK|💬
MySQL10 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique comment identifier
File this comment is on
User who posted the comment
Parent comment id for thread replies
Comment text content
Timestamp when comment thread was resolved
Canvas X coordinate of comment pin
Canvas Y coordinate of comment pin
Comment creation timestamp
Last update timestamp
IXUQCK|💬
MySQL5 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique reaction record identifier
Comment that was reacted to
User who reacted
Emoji character or code
Reaction timestamp
IXUQCK|💬
MySQL7 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique share record identifier
Shared file
User who created the share link
Access level: view, comment, edit
Unique token for share URL
Share link expiration timestamp
Share creation timestamp
IXUQCK|💬
MySQL9 cols
Num
PK
AI
FK
Null
Physical Name
Type
Default
Comment
Unique plugin identifier
Plugin display name
Plugin description and functionality
User or org that published the plugin
Plugin icon URL
Total number of installs
Whether plugin is publicly available
Plugin creation timestamp
Last update timestamp
IXUQCK|💬
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
Created with ERD Studio
Tables in this template
usersUsers
7 colsorganizationsOrganizations
7 colsorg_membersOrg Members
6 colsteamsTeams
7 colsteam_membersTeam Members
6 colsprojectsProjects
6 colsfilesFiles
9 colsfile_versionsFile Versions
6 colspagesPages
6 colsframesFrames
11 colscomponentsComponents
7 colscommentsComments
10 colscomment_reactionsComment Reactions
5 colssharesShares
7 colspluginsPlugins
9 colsRelated Templates
View all templates →GitHub
CloneCode hosting platform with repositories, issues, pull requests, and CI/CD
PostgreSQL16 tables
developer-toolsgitcollaboration+2
Web App
Netflix
CloneVideo streaming platform with content catalog, profiles, subscriptions, and recommendations
PostgreSQL15 tables
streamingvideosubscription+2
Web App
Spotify
CloneMusic streaming platform with tracks, artists, albums, playlists, and social features
PostgreSQL18 tables
musicstreamingplaylist+2
Web App
Discord
CloneCommunity platform with servers, channels, roles, voice, and bots
PostgreSQL15 tables
gamingcommunityvoice+2
Web App