SPI

Tables (3)

Article (Untitled2)

  • article_id (Key) — Long — Primary key — NOT NULL
  • total_hit (Field) — Integer — NOT NULL — 전체 조회수
  • weekly_hit (Field2) — Integer — NOT NULL — 일주일 조회수
  • monthly_hit (Field3) — Integer — NOT NULL — 한달 조회수

Hit (Untitled3)

  • hit_id (Key) — Long — Primary key — NOT NULL
  • article_id (Key2) — Long — Foreign key → Article.article_id — NOT NULL
  • created_at (Field) — LocalDateTime — NOT NULL — yyyy:MM:dd HH:mm:ss 형태

User (Untitled)

  • user_id (Key) — Long — Primary key — NOT NULL