Skip to content

Instantly share code, notes, and snippets.

@andidp
Created August 9, 2016 03:01
Show Gist options
  • Save andidp/2890eda9e8564345356eb071c6d6069a to your computer and use it in GitHub Desktop.
Save andidp/2890eda9e8564345356eb071c6d6069a to your computer and use it in GitHub Desktop.
questions and answers tables
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| title | varchar(255) | NO | | NULL | |
| body | mediumtext | NO | | NULL | |
| created_at | timestamp | YES | | NULL | |
| updated_at | timestamp | YES | | NULL | |
+------------+------------------+------+-----+---------+----------------+
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| question_id | int(10) unsigned | NO | MUL | 0 | |
| title | varchar(255) | NO | | NULL | |
| body | text | NO | | NULL | |
| created_at | timestamp | YES | | NULL | |
| updated_at | timestamp | YES | | NULL | |
+-------------+------------------+------+-----+---------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment