Flag ERD
Tables (9)
Activity
- id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL
- name — String — NOT NULL
- description — String — NOT NULL
- period — String — NOT NULL
- status — Enum — NOT NULL
- created_at — LocalDate — NOT NULL
- updated_at — LocalDate — NOT NULL
Login_log
- id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL
- status — Enum — NOT NULL
- created_at — LocalDate — NOT NULL
- updated_at — LocalDate — NOT NULL
Post
- id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL
- title — String — NOT NULL
- content — String — NOT NULL
- category — Enum — NOT NULL
- view_cnt — Long
- status — Enum — NOT NULL
- created_at — LocalDate — NOT NULL
- updated_at — LocalDate — NOT NULL
Post_log
- id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL
- post_id — Long — Foreign key → Post.id — NOT NULL
- created_at — LocalDate — NOT NULL
- updated_at — LocalDate — NOT NULL
Post_pile
- id — Long — Primary key — NOT NULL
- post_id — Long — Foreign key → Post.id — NOT NULL
- link — String — NOT NULL
- status — Enum — NOT NULL
- created_at — LocalDate — NOT NULL
- updated_at — LocalDate — NOT NULL
Reply
- id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL
- post_id — Long — Foreign key → Post.id — NOT NULL
- content — String — NOT NULL
- status — Enum — NOT NULL
- reply_group — Long — NOT NULL
- reply_order — Long — NOT NULL
- reply_depth — Long — NOT NULL
- created_at — LocalDate — NOT NULL
- updated_at — LocalDate — NOT NULL
Tag
- id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL
- description — String — NOT NULL
- created_at — LocalDate — NOT NULL
- updated_at — LocalDate — NOT NULL
User
- id — Long — Primary key — NOT NULL
- login_id — String — NOT NULL
- password — String — NOT NULL
- email — String — NOT NULL
- name — String — NOT NULL
- student_id — String — NOT NULL
- major — Enum — NOT NULL
- role — Enum — NOT NULL
- phone_number — String
- profile_img — String
- status — String — NOT NULL
- created_at — LocalDate — NOT NULL
- updated_at — LocalDate — NOT NULL