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.2.tar.gz
(8.6 kB
view hashes)
Built Distribution
Close
Hashes for sqlmermaid-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 566775c95a992d47d1718b0be6a1376a3008039873ab88287089faded1f8ee8b |
|
MD5 | c2c104e1fe6bc64454fe5a5811867c62 |
|
BLAKE2b-256 | 7240df67311737b7ca1b907c06d1e210c8c041905f9a3140561388cc7d8cf7ff |