Home

Hashtags Table

CREATE TABLE IF NOT EXISTS abilists.user_hashtags (
  uh_no BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  uh_tags VARCHAR(100) NULL,
  uh_status VARCHAR(2) NULL,
  uh_delete CHAR(1) NULL,
  user_id VARCHAR(100) NULL,
  ms_no BIGINT UNSIGNED,
  ms_kind VARCHAR(100) NULL,
  insert_time TIMESTAMP NULL,
  update_time TIMESTAMP NULL,
  PRIMARY KEY (uh_no)
) ENGINE=innoDB DEFAULT CHARSET=utf8mb4;
CREATE INDEX idx_user_hashtags_user_id ON abilists.user_hashtags(user_id);
CREATE INDEX idx_user_hashtags_ms_kind ON abilists.user_hashtags(ms_kind);