Visualizing SQL databases
Project description
sqlmermaid
Creates pretty schema diagrams like this one, simply from a constring
erDiagram
complaints {
INTEGER about_dept FK
INTEGER by_user FK
DATETIME at_time
VARCHAR-500 text "in index: comp_ind"
}
departments {
INTEGER department_id PK
VARCHAR-60 department_name
}
user {
INTEGER user_id PK
VARCHAR-16 user_name
VARCHAR-60 email_address
VARCHAR-50 nickname
}
employees {
INTEGER employee_id PK
VARCHAR-60 employee_name
INTEGER employee_dept FK
}
complaints ||--|{ user : "by_user"
complaints ||--|{ departments : "about_dept"
employees ||--|{ departments : "employee_dept"
erDiagram
complaints {
INTEGER about_dept FK
INTEGER by_user FK
DATETIME at_time
VARCHAR-500 text "in index: comp_ind"
}
departments {
INTEGER department_id PK
VARCHAR-60 department_name
}
user {
INTEGER user_id PK
VARCHAR-16 user_name
VARCHAR-60 email_address
VARCHAR-50 nickname
}
employees {
INTEGER employee_id PK
VARCHAR-60 employee_name
INTEGER employee_dept FK
}
complaints ||--|{ user : "by_user"
complaints ||--|{ departments : "about_dept"
employees ||--|{ departments : "employee_dept"
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlmermaid-0.1.1.tar.gz
(8.6 kB
view hashes)
Built Distribution
Close
Hashes for sqlmermaid-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 56cb1c510aff37ede5e586e42d5cd987c385a5d227634943d3fa89c91f2e9239 |
|
MD5 | 129e0ceea985942d4c41c2b6745f9e9e |
|
BLAKE2b-256 | 4fd8272f30232f75db98171f85a9c2e341b09a5f36293c199118460c72b7cdec |