Skip to content

Instantly share code, notes, and snippets.

@wmene
Created April 14, 2015 18:42
Show Gist options
  • Save wmene/e775d78938abe0708cad to your computer and use it in GitHub Desktop.
Save wmene/e775d78938abe0708cad to your computer and use it in GitHub Desktop.
Fedora doFields MySQL table description
+---------------+--------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+---------------+--------------+-------------------+------+-----+---------+-------+---------------------------------+---------+
| pid | varchar(64) | latin1_bin | NO | MUL | NULL | | select,insert,update,references | |
| label | varchar(255) | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| state | varchar(1) | latin1_swedish_ci | NO | | A | | select,insert,update,references | |
| ownerId | varchar(64) | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| cDate | bigint(20) | NULL | NO | | NULL | | select,insert,update,references | |
| mDate | bigint(20) | NULL | NO | | NULL | | select,insert,update,references | |
| dcmDate | bigint(20) | NULL | YES | | NULL | | select,insert,update,references | |
| dcTitle | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcCreator | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcSubject | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcDescription | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcPublisher | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcContributor | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcDate | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcType | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcFormat | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcIdentifier | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcSource | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcLanguage | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcRelation | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcCoverage | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
| dcRights | text | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | |
+---------------+--------------+-------------------+------+-----+---------+-------+---------------------------------+————+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment