tech-swipe

Tables (8)

Copy Of Untitled (tech_post_keyword)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (tect_post_id) — BIGINT — Foreign key → tech_content.Key — NOT NULL — IX1, UK1
  • Key (keyword_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL — IX2, UK1

Untitled (tech_blog)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (crawling_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (dtype) — NOT NULL — rss, atom, 크롤링, api (rss 경우 <![CDATA[ ]]> 빼기)
  • Field (type) — code — NOT NULL — 국내 기업 기술 블로그, 해외 기업 기술블로그, ...
  • Field (title) — VARCHAR — NOT NULL
  • Field (link) — VARCHAR — NOT NULL
  • Field (feed_link) — VARCHAR — NOT NULL

Untitled (tech_post_category)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (tect_post_id) — BIGINT — Foreign key → tech_content.Key — NOT NULL — IX1
  • Field (name) — code — NOT NULL — IX2

Untitled (scrapping)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR — NOT NULL — UK1. 미디엄, velog, custom, ...
  • Field (title) — VARCHAR
  • Field (content) — VARCHAR
  • Field (posted_at) — DATETIME
  • Field2 (post_last_modified_at) — DATETIME
  • Field2 (created_at) — DATETIME — NOT NULL
  • Field3 (last_modified_at) — DATETIME — NOT NULL

Untitled (generation_history)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • id (prompt_id) — BIGINT — Foreign key → prompt.id — NOT NULL
  • Key (tech_blog_id) — BIGINT — Foreign key → tech_content.Key — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (last_modifeid_at) — DATETIME — NOT NULL

Untitled (keyword)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR — NOT NULL — UK
  • Field (created_at) — DATETIME — NOT NULL
  • Field (last_modified_at) — DATETIME — NOT NULL

prompt

  • id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • Field (type) — code — NOT NULL — 국내 블로그, 해외 블로그, 키워드 추출, ...
  • Field (version) — VARCHAR — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (last_modified_at) — DATETIME — NOT NULL

tech_content (tect_post)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (provider_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (uid) — VARCHAR — NOT NULL — UK1
  • Field (link) — VARCHAR — NOT NULL — UK2
  • Field2 (title) — VARCHAR(1000) — NOT NULL
  • Field (content) — LONGTEXT — NOT NULL
  • Field (summary) — TEXT — NOT NULL
  • Field (post_created_at) — DATETIME — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (last_modified_at) — DATETIME — NOT NULL
  • Field3 (deleted) — BOOLEAN — NOT NULL
  • Field4 (deleted_at) — DATETIME — NOT NULL