doit-blog

Tables (5)

Category (Untitled4)

  • categoryId (Key) — Long — Primary key — NOT NULL
  • type (Field) — Enum
  • createdAt (Field2) — DateTime
  • modifiedAt (Field3) — DateTime

Comment (Untitled2)

  • commentId (Key) — Long — Primary key — NOT NULL
  • content (Field) — String
  • createdAt (Field3) — DateTime
  • modifiedAt (Field4) — DateTime
  • postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
  • userId (Key3) — Long — Foreign key → User.userId — NOT NULL

Post (Untitled)

  • postId (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • image (Field6) — String
  • likeCount (Field3) — Integer
  • createdAt (Field4) — DateTime
  • modifiedAt (Field5) — DateTime
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • categoryId (Key3) — Long — Foreign key → Category.categoryId — NOT NULL

User (유저)

  • userId (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • loginId (Field2) — String
  • nickname (Field7) — String
  • password (Field3) — String
  • phoneNumber (Field4) — String
  • createdAt (Field5) — DateTime
  • modifiedAt (Field6) — DateTime

UserLikePost (Untitled3)

  • userLikePostId (Key) — Long — Primary key — NOT NULL
  • createdAt (Field) — DateTime
  • modifiedAt (Field2) — DateTime
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • postId (Key3) — Long — Foreign key → Post.postId — NOT NULL