Detailed schema, tables, and migration status
connection to server at "postgresql.postgresql.svc.cluster.local" (172.16.248.88), port 5432 failed: fe_sendauth: no password supplied
| Column | Type | Nullable | Default |
|---|---|---|---|
| id | int | ✗ | - |
| cache_key | nvarchar | ✗ | - |
| hit_count | int | ✗ | ((0)) |
| miss_count | int | ✗ | ((0)) |
| last_accessed | datetime2 | ✗ | (getdate()) |
| id | cache_key | hit_count | miss_count | last_accessed |
|---|---|---|---|---|
| 1 | posts:all | 0 | 0 | 2025-12-05 07:12:37.897000 |
| 2 | users:all | 0 | 0 | 2025-12-05 07:12:37.897000 |
| 3 | tags:all | 0 | 0 | 2025-12-05 07:12:37.897000 |
| Column | Type | Nullable | Default |
|---|---|---|---|
| id | int | ✗ | - |
| post_id | int | ✗ | - |
| user_id | int | ✗ | - |
| comment_text | nvarchar | ✗ | - |
| created_at | datetime2 | ✗ | (getdate()) |
| Column | Type | Nullable | Default |
|---|---|---|---|
| post_id | int | ✗ | - |
| tag_id | int | ✗ | - |
| created_at | datetime2 | ✗ | (getdate()) |
| Column | Type | Nullable | Default |
|---|---|---|---|
| id | int | ✗ | - |
| user_id | int | ✗ | - |
| title | nvarchar | ✗ | - |
| content | nvarchar | ✓ | - |
| status | nvarchar | ✗ | ('draft') |
| view_count | int | ✗ | ((0)) |
| created_at | datetime2 | ✗ | (getdate()) |
| updated_at | datetime2 | ✗ | (getdate()) |
| Column | Type | Nullable | Default |
|---|---|---|---|
| id | int | ✗ | - |
| name | nvarchar | ✗ | - |
| slug | nvarchar | ✗ | - |
| description | nvarchar | ✓ | - |
| created_at | datetime2 | ✗ | (getdate()) |
| Column | Type | Nullable | Default |
|---|---|---|---|
| id | int | ✗ | - |
| username | nvarchar | ✗ | - |
| nvarchar | ✗ | - |
|
| full_name | nvarchar | ✓ | - |
| created_at | datetime2 | ✗ | (getdate()) |
| updated_at | datetime2 | ✗ | (getdate()) |
| id | username | full_name | created_at | updated_at | |
|---|---|---|---|---|---|
| 1 | john_doe | [email protected] | John Doe | 2025-12-05 07:12:37.620000 | 2025-12-05 07:12:37.620000 |
| 2 | jane_smith | [email protected] | Jane Smith | 2025-12-05 07:12:37.620000 | 2025-12-05 07:12:37.620000 |
| 3 | bob_wilson | [email protected] | Bob Wilson | 2025-12-05 07:12:37.620000 | 2025-12-05 07:12:37.620000 |
Auto-refresh: Reload this page to see updated database information
Generated at 2025-12-06T03:35:37.369338