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