Skip to content

Instantly share code, notes, and snippets.

@ssmusoke
Created March 15, 2018 20:45
Show Gist options
  • Save ssmusoke/ddebd65670dd258f2640e3df3736c43f to your computer and use it in GitHub Desktop.
Save ssmusoke/ddebd65670dd258f2640e3df3736c43f to your computer and use it in GitHub Desktop.
+------------------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+---------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| uuid | char(38) | NO | UNI | NULL | |
| name | varchar(255) | NO | | NULL | |
| description | varchar(1000) | YES | | NULL | |
| renderer_type | varchar(255) | NO | | NULL | |
| properties | text | YES | | NULL | |
| creator | int(11) | NO | MUL | 0 | |
| date_created | datetime | NO | | NULL | |
| changed_by | int(11) | YES | MUL | NULL | |
| date_changed | datetime | YES | | NULL | |
| retired | tinyint(1) | NO | | 0 | |
| retired_by | int(11) | YES | MUL | NULL | |
| date_retired | datetime | YES | | NULL | |
| retire_reason | varchar(255) | YES | | NULL | |
| report_definition_uuid | char(38) | NO | | NULL | |
+------------------------+---------------+------+-----+---------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment