Advertisement
Guest User

Untitled

a guest
Apr 30th, 2021
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. MariaDB [openmrs]> describe reporting_report_design
  2. -> ;
  3. +----------------------+---------------+------+-----+---------+----------------+
  4. | Field | Type | Null | Key | Default | Extra |
  5. +----------------------+---------------+------+-----+---------+----------------+
  6. | id | int(11) | NO | PRI | NULL | auto_increment |
  7. | uuid | char(38) | NO | UNI | NULL | |
  8. | name | varchar(255) | NO | | NULL | |
  9. | description | varchar(1000) | YES | | NULL | |
  10. | report_definition_id | int(11) | NO | MUL | 0 | |
  11. | renderer_type | varchar(255) | NO | | NULL | |
  12. | properties | text | YES | | NULL | |
  13. | creator | int(11) | NO | MUL | 0 | |
  14. | date_created | datetime | NO | | NULL | |
  15. | changed_by | int(11) | YES | MUL | NULL | |
  16. | date_changed | datetime | YES | | NULL | |
  17. | retired | tinyint(1) | NO | | 0 | |
  18. | retired_by | int(11) | YES | MUL | NULL | |
  19. | date_retired | datetime | YES | | NULL | |
  20. | retire_reason | varchar(255) | YES | | NULL | |
  21. +----------------------+---------------+------+-----+---------+----------------+
  22. 15 rows in set (0.001 sec)
  23.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement