Entity

Tables (4)

article

  • article_id (id) — Long — Primary key — NOT NULL
  • created_at (createdAt) — LocalDateTime — Foreign key → time.created_at — NOT NULL
  • updated_at (updatedAt) — LocalDateTime — Foreign key → time.updated_at — NOT NULL
  • content — String — NOT NULL
  • is_notice (isNotice) — boolean — NOT NULL
  • title — String — NOT NULL
  • view_cnt (viewCnt) — Integer — NOT NULL
  • user_id (userId) — Long — Foreign key → user.user_id — NOT NULL

comment (Comment)

  • comment_id (id) — Long — Primary key — NOT NULL
  • created_at (createdAt) — LocalDateTime — Foreign key → time.created_at — NOT NULL
  • updated_at (updatedAt) — LocalDateTime — Foreign key → time.updated_at — NOT NULL
  • comment — String — NOT NULL
  • user_id (userId) — Long — NOT NULL
  • article_id (articleId) — Long — Foreign key → article.article_id — NOT NULL

time (Time)

  • created_at (createdAt) — LocalDateTime — Primary key — NOT NULL
  • updated_at (updatedAt) — LocalDateTime — Primary key — NOT NULL

user (User)

  • user_id (id) — Long — Primary key — NOT NULL
  • email — String — NOT NULL
  • name — String — NOT NULL
  • password — String — NOT NULL
  • role — String — NOT NULL