DobDob-ERD

Tables (9)

Comment (Untitled4)

  • commentId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • postId (Key3) — Long — Foreign key → Post.postId — NOT NULL
  • content (Field) — String
  • isDeleted (Field4) — Boolean
  • createdAt (Field2) — DATETIME

Like (Untitled8)

  • likeId (Key) — Long — Primary key — NOT NULL
  • postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
  • userId (Key22) — Long — Foreign key → Post.userId — NOT NULL

Location (Untitled3)

  • locationId (Key) — Long — Primary key — NOT NULL
  • si (Field) — String
  • gu (Field2) — String
  • dong (Field3) — String
  • locationX (Field4) — Float
  • locationY (Field5) — Float

Post (Untitled2)

  • postId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL
  • locationId (Key3) — Long — Foreign key → Location.locationId — NOT NULL
  • title (Field) — String
  • content (Field2) — TEXT
  • isDeleted (Field6) — Boolean
  • createdAt (Field3) — DATETIME
  • editedAt (Field4) — DATETIME

PostImage (Untitled7)

  • postImageId (Key) — Long — Primary key — NOT NULL
  • postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
  • url (Field) — String

PostTag (Untitled6)

  • postId (Key) — Long — Foreign key → Post.postId — NOT NULL
  • tagId (Key4) — Long — Foreign key → Tag.tagId — NOT NULL

Tag (Untitled5)

  • tagId (Key) — Long — Primary key — NOT NULL
  • name (Field) — String

Untitled9

    User (Untitled)

    • userId (Key) — Long — Primary key — NOT NULL
    • locationId (Key2) — Long — Foreign key → Location.locationId — NOT NULL
    • email (Field) — String
    • socialType (Field2) — String
    • nickName (Field3) — String
    • profileUrl (Field4) — String
    • accessToken (Field5) — String
    • refreshToken (Field6) — String