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.0.tar.gz
(8.0 kB
view hashes)
Built Distribution
Close
Hashes for sqlmermaid-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a078a3023d4b04edacc9d52f0874dd685b55dc93e0de06cda900f0dab12c6f13 |
|
MD5 | 4b4fbb31d2a913ce2a2edc756b72be3a |
|
BLAKE2b-256 | 1e9b2537c61ca3ae14de5e3e7af23316515d119efecb359d3bc08698e7cab3f8 |