QueryGraph is an interactive database visualization tool that helps you understand your data structure and relationships. Map your database schema, explore connections between tables, and generate visual reports.
No tables available
| Column | Type | Constraints |
|---|---|---|
| id | uuid | PRIMARY KEY |
| username | varchar | |
| varchar | ||
| password_hash | varchar | |
| created_at | timestamp | |
| updated_at | timestamp |
| Table | Total Columns | Primary Keys | Foreign Keys | Data Types |
|---|---|---|---|---|
| Users | 6 | 1 | 0 | uuid: 1varchar: 3timestamp: 2 |
| Posts | 6 | 1 | 1 | uuid: 2varchar: 1text: 1timestamp: 2 |
| Comments | 5 | 1 | 2 | uuid: 3text: 1timestamp: 1 |
| Categories | 3 | 1 | 0 | uuid: 1varchar: 1text: 1 |
| PostCategories | 2 | 2 | 2 | uuid: 2 |
| Table | Users | Posts | Comments | Categories | PostCategories |
|---|---|---|---|---|---|
| Users | - | 1 | 1 | - | - |
| Posts | 1 | - | 1 | - | 1 |
| Comments | 1 | 1 | - | - | - |
| Categories | - | - | - | - | 1 |
| PostCategories | - | 1 | - | 1 | - |
| Source Table | Source Column | Target Table | Target Column |
|---|---|---|---|
| Posts | user_id | Users | id |
| Comments | user_id | Users | id |
| Comments | post_id | Posts | id |
| PostCategories | post_id | Posts | id |
| PostCategories | category_id | Categories | id |
| Table | Row Count | Column Count | Est. Size | % of Total |
|---|---|---|---|---|
| Comments | 87,500 | 5 | 4272.46 KB | 47.7% |
| PostCategories | 67,500 | 2 | 1318.36 KB | 14.7% |
| Posts | 45,000 | 6 | 2636.72 KB | 29.4% |
| Users | 12,500 | 6 | 732.42 KB | 8.2% |
| Categories | 120 | 3 | 3.52 KB | 0.0% |