해시태그에 카테고리 적용하기

[mingmingmon]

Describe

UX 측면을 고려하여 @Jeong-Ag 님이 해시태그에 분류를 적용하는 것을 제안 주셨습니다.
이 부분을 적용하기 위해 아래와 같이 분류를 생성하고 현재 존재하는 해시태그들을 분류하고자 합니다.

**LANGUAGE**
C
C++
Java
Javascript
Python
Assembly
Kotlin
Typescript

**FIELD**
Front-end
Back-end
AI
Game
Android
IOS

**SKILL**
DB
Devops
Infra
framework
algorithm

**ETC**
etc

Tasks

• 해시태그에 카테고리 적용하기

ETC

No response

[mingmingmon]

INSERT INTO hashtag (name, category, is_deleted, board_usage, created_at, updated_at) VALUES
-- LANGUAGE
('C', 'LANGUAGE', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('C++', 'LANGUAGE', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Java', 'LANGUAGE', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Javascript', 'LANGUAGE', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Python', 'LANGUAGE', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Assembly', 'LANGUAGE', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Kotlin', 'LANGUAGE', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Typescript', 'LANGUAGE', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- FIELD
('Front-end', 'FIELD', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Back-end', 'FIELD', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('AI', 'FIELD', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Game', 'FIELD', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Android', 'FIELD', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('IOS', 'FIELD', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- SKILL
('DB', 'SKILL', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Devops', 'SKILL', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Infra', 'SKILL', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('framework', 'SKILL', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('algorithm', 'SKILL', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),

-- ETC
('기타', 'ETC', false, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);


ALTER TABLE hashtag
ADD COLUMN hashtag_category VARCHAR(50) NOT NULL DEFAULT 'ETC';