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