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