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.4.tar.gz
(8.9 kB
view hashes)
Built Distribution
Close
Hashes for sqlmermaid-0.1.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f2c0380abd37f5a7fc1a9e2a3eb1f710f046faaa2905dd00ff58960d71d23d15 |
|
MD5 | f8dd4b4902c0d3686bbb397b81c75a41 |
|
BLAKE2b-256 | 1196a4d47b79252fb5d9661eb27ba5a06832128adf038743cd4ab2eb93b5ba4e |