georgebullock/comment-tags.md

Last active April 29, 2020 13:19

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/georgebullock/410718521cc5e1dd2827d337ba3021a9.js"></script>
Save georgebullock/410718521cc5e1dd2827d337ba3021a9 to your computer and use it in GitHub Desktop.

React Interactive Dashboard Draft MySQL Schema v1.0.0

Raw

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

Author

georgebullock commented Apr 14, 2020

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.

georgebullock/comment-tags.md

georgebullock commented Apr 14, 2020

Uh oh!