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.3.tar.gz
(8.9 kB
view hashes)
Built Distribution
Close
Hashes for sqlmermaid-0.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 07198c81e932035d6a2bf1596085c49ab8816319911c23287e7796b1ce24c421 |
|
MD5 | fd98aa6fefec7aaf99fb3e5a3d8f91a4 |
|
BLAKE2b-256 | 0c502b9511f695deace8ad4785ee73dfc718b64fe3b5903dd8ec016ae726219a |