# Tables

#### SchemaSpy Analysis of tasknote.tasknote

Generated on Thu Mar 27 20:55 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 8
VIEWS 0
COLUMNS 36
Constraints 7
Anomalies 0
Routines 0

### Database Properties

Database Type: PostgreSQL - 15.8 (Debian 15.8-1.pgdg120+1)

### Tables

Table / View | Children | Parents | Columns | Rows | Type | Comments
--- | --- | --- | --- | --- | --- | ---
tasks | 1 | 1 | 11 | -1 | Table |
notes | 1 | 1 | 5 | -1 | Table |
note_urls | 0 | 1 | 3 | -1 | Table |
task_url | 0 | 1 | 2 | -1 | Table |
user_tasks_done | 0 | 1 | 3 | -1 | Table |
notes_created | 0 | 1 | 2 | -1 | Table |
user_pwd_limits | 0 | 1 | 3 | -1 | Table |
users | 5 | 0 | 7 | -1 | Table |