BTD
Tables (10)
article (AI로생성된기사)
- id (생성된기사아이디) — BIGINT — Primary key — NOT NULL
- title (기사제목) — VARCHAR(50)
- body (기사본문) — TEXT
article_category (생성된기사의카테고리)
- id (기사카테고리아이디) — BIGINT — Primary key — NOT NULL
- article_id (기사아이디) — BIGINT — Foreign key → article.id — NOT NULL
- category (기사카테고리) — ENUM
article_image (생성된기사의이미지)
- id (기사이미지아이디) — BIGINT — Primary key — NOT NULL
- article_id (기사아이디) — BIGINT — Foreign key → article.id — NOT NULL
- image_url (기사이미지url) — VARCHAR(100)
article_source (생성된기사의출처)
- id (출처기사아이디) — BIGINT — Primary key — NOT NULL
- article_id (기사아이디) — BIGINT — Foreign key → article.id — NOT NULL
- title (출처기사제목) — VARCHAR(50)
- url (출처기사url) — VARCHAR(200)
- press_company (출처기사언론사) — ENUM
custom_info (유저가커스텀한정보)
- id (커스텀정보아이디) — BIGINT — Primary key — NOT NULL
- custom_id (커스텀아이디) — BIGINT — Foreign key → user_custom.id — NOT NULL
- start_point (하이라이트문장시작점) — INT
- end_point (하이라이트문장끝점) — INT
- highlights_color (하이라이트색) — ENUM
- font_color (하이라트문장폰트색) — ENUM
- font_size (하이라이트문장폰트크기) — INT
- is_bold (하이라트문장볼드여부) — BOOLEAN
user (유저)
- id (유저아이디) — BIGINT — Primary key — NOT NULL
- nickname (닉네임) — VRCHAR(10)
- provided_id (유저식별자) — VARCHAR(100)
- profile_url (유저프로필url) — VARCHAR(200)
- provider (소셜로그인종류) — VRCHAR(15)
- status (상태) — ENUM
- inactive_date (비활성화날짜) — DATETIME(6)
user_custom (유저가커스텀한기사)
- id (커스텀아이디) — BIGINT — Primary key — NOT NULL
- user_id (커스텀한유저아이디) — BIGINT — Foreign key → user.id — NOT NULL
- article_id (커스텀한기사아이디) — BIGINT — Foreign key → article.id — NOT NULL
- background_color (기사배경색) — VARCHAR(15)
user_scrap (유저가스크랩한기사)
- id (스크랩아이디) — BIGINT — Primary key — NOT NULL
- article_id (스크랩한기사아이디) — BIGINT — Foreign key → article.id — NOT NULL
- user_id (스크랩한유저아이디) — BIGINT — Foreign key → user.id — NOT NULL
user_tag (유저의관심분야태그)
- id (태그아이디) — BIGINT — Primary key — NOT NULL
- user_id (유저아이디) — BIGINT — Foreign key → user.id — NOT NULL
- tag (유저의관심분야태그) — ENUM
wordcloud (워드클라우드)
- id (워드클라우드단어아이디) — BIGINT — Primary key — NOT NULL
- word (단어) — VRCHAR(20)
- score (단어검색량) — INT