MHJ_ERD
Tables (8)
Activitiy (Untitled7)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.ID — NOT NULL
- name (Field) — String — NOT NULL
- discription (Field4) — String — NOT NULL
- period (Field6) — String — NOT NULL
- status (Field5) — Enum — NOT NULL
- created_at (Field2) — LocalDate — NOT NULL
- updated_at (Field3) — LocalDate — NOT NULL
Login_log (Untitled8)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.ID — NOT NULL
- status (Field3) — Enum — NOT NULL
- created_at (Field) — LocalDate — NOT NULL
- updated_at (Field2) — LocalDate — NOT NULL
Post (Untitled3)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.ID — NOT NULL
- title (Field) — String — NOT NULL
- content (Field2) — String — NOT NULL
- category (Field3) — Enum — NOT NULL
- view_cnt (Field7) — Long
- status (Field6) — Enum — NOT NULL
- created_at (Field4) — LocalDate — NOT NULL
- updated_at (Field5) — LocalDate — NOT NULL
Post_log (Untitled9)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.ID — NOT NULL
- post_id (Key3) — Long — Foreign key → Post.id — NOT NULL
- created_at (Field) — LocalDate — NOT NULL
- updated_at (Field2) — LocalDate — NOT NULL
Post_pile (Untitled5)
- id (Key) — Long — Primary key — NOT NULL
- post_id (Key2) — Long — Foreign key → Post.id — NOT NULL
- link (Field3) — String — NOT NULL
- status (Field4) — Enum — NOT NULL
- created_at (Field) — LocalDate — NOT NULL
- updated_at (Field2) — LocalDate — NOT NULL
Reply (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key3) — Long — Foreign key → User.ID — NOT NULL
- post_id (Key2) — Long — Foreign key → Post.id — NOT NULL
- content (Field) — String — NOT NULL
- status (Field4) — Enum — NOT NULL
- created_at (Field2) — LocalDate — NOT NULL
- updated_at (Field3) — LocalDate — NOT NULL
Tag (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.ID — NOT NULL
- description (Field) — String — NOT NULL
- created_at (Field2) — LocalDate — NOT NULL
- updated_at (Field3) — LocalDate — NOT NULL
User (Untitled)
- ID (Key) — Long — Primary key — NOT NULL
- login_Id (Field8) — String — NOT NULL
- password (Field2) — String — NOT NULL
- email (Field9) — String — NOT NULL
- name (Field) — String — NOT NULL
- student_ID (Field10) — String — NOT NULL
- major (Field3) — Enum — NOT NULL
- role (Field6) — Enum — NOT NULL
- phone_number (Field11) — String
- profile_img (Field12) — String
- status (Field7) — String — NOT NULL
- created_at (Field4) — LocalDate — NOT NULL
- updated_at (Field5) — LocalDate — NOT NULL