Skip to content

Instantly share code, notes, and snippets.

@georgebullock

georgebullock/comment-tags.md

Last active April 29, 2020 13:19
Show Gist options
  • Save georgebullock/410718521cc5e1dd2827d337ba3021a9 to your computer and use it in GitHub Desktop.
Save georgebullock/410718521cc5e1dd2827d337ba3021a9 to your computer and use it in GitHub Desktop.
Download ZIP
React Interactive Dashboard Draft MySQL Schema v1.0.0
Raw
comment-tags.md
field type specs
comment_id INT(11)
Raw
comments.md
field type specs
id INT(11)
user_id INT(11)
body TEXT
created_at TIMESTAMP
Raw
tags.md
field type specs
id INT(11)
user_id INT(11)
tag VAR(255)
created_at TIMESTAMP
Raw
users.md
field type specs
id INT(11)
username VAR(255) UNIQUE
email VAR(255) UNIQUE
password VAR(255)
created_at TIMESTAMP
@Sebastian-Fitzner
Copy link

Sebastian-Fitzner commented Apr 8, 2020 •
edited
Loading

It looks good, you can continue with that, perhaps you need to have one more table like comment-tags in which you save the relation between comment and tag ...

@georgebullock
Copy link
Author

It looks good, you can continue with that, perhaps you need to have one more table like comment-tags in which you save the relation between comment and tag ...

@Sebastian-Fitzner I added the additional table. Still not sure about the tags type in the comments table. Using VAR(255) for now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment