CREATE TABLE article (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  user_id INTEGER UNSIGNED NOT NULL,
  comment_id INTEGER UNSIGNED NOT NULL,
  user_comment_id INTEGER UNSIGNED NOT NULL,
  title VARCHAR NULL,
  content TEXT NULL,
  created_at TIMESTAMP NULL,
  updated_at TIMESTAMP NULL,
  PRIMARY KEY(id, user_id, comment_id, user_comment_id),
  INDEX article_FKIndex1(user_id, user_comment_id),
  INDEX article_FKIndex2(comment_id)
);

CREATE TABLE article_has_tag (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  article_id INTEGER UNSIGNED NOT NULL,
  tag_id INTEGER UNSIGNED NOT NULL,
  article_user_id INTEGER UNSIGNED NOT NULL,
  article_comment_id INTEGER UNSIGNED NOT NULL,
  article_user_comment_id INTEGER UNSIGNED NOT NULL,
  PRIMARY KEY(id, article_id, tag_id, article_user_id, article_comment_id, article_user_comment_id),
  INDEX article_has_tag_FKIndex2(article_id, article_user_id, article_comment_id, article_user_comment_id),
  INDEX article_has_tag_FKIndex2(tag_id)
);

CREATE TABLE comment (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  user_id INTEGER UNSIGNED NULL,
  article_id INTEGER UNSIGNED NULL,
  created_at TIMESTAMP NULL,
  content TEXT NULL,
  PRIMARY KEY(id)
);

CREATE TABLE group (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  user_profile_user_id INTEGER UNSIGNED NOT NULL,
  user_profile_id INTEGER UNSIGNED NOT NULL,
  user_profile_user_comment_id INTEGER UNSIGNED NOT NULL,
  group_name VARCHAR NULL,
  PRIMARY KEY(id, user_profile_user_id, user_profile_id, user_profile_user_comment_id),
  INDEX group_FKIndex1(user_profile_id, user_profile_user_id, user_profile_user_comment_id)
);

CREATE TABLE tag (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  name INTEGER UNSIGNED NULL,
  PRIMARY KEY(id)
);

CREATE TABLE user (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  comment_id INTEGER UNSIGNED NOT NULL,
  username INTEGER UNSIGNED NULL,
  password VARCHAR NULL,
  group INTEGER UNSIGNED NULL,
  is_admin BOOL NULL,
  created_at TIMESTAMP NULL,
  PRIMARY KEY(id, comment_id),
  INDEX user_FKIndex1(comment_id)
);

CREATE TABLE user_profile (
  id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  user_id INTEGER UNSIGNED NOT NULL,
  user_comment_id INTEGER UNSIGNED NOT NULL,
  group_id INTEGER UNSIGNED NULL,
  firstname VARCHAR NULL,
  lastname VARCHAR NULL,
  email VARCHAR NULL,
  PRIMARY KEY(id, user_id, user_comment_id),
  INDEX user_profile_FKIndex1(user_id, user_comment_id)
);