Leets BE Blog

Tables (4)

Comment (Untitled5)

  • comId (Key) — bigint — Primary key — NOT NULL
  • postId (Key2) — bigint — Foreign key → Post.postId — NOT NULL
  • detail (Field) — varchar
  • id (Key3) — bigint — Foreign key → User.id — NOT NULL

Post (Untitled4)

  • postId (Key) — Long — Primary key — NOT NULL
  • title (Field) — varchar
  • id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • detail (Field2) — varchar
  • imageUrl (Field3) — varchar

RefreshToken (Untitled7)

  • refId (Key) — bigint — Primary key — NOT NULL
  • token (Field) — char
  • issuedAt (Field2) — datetime
  • expiresAt (Field3) — datetime
  • revoked (Field4) — boolean
  • id (Key2) — bigint — Foreign key → User.id — NOT NULL

User (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • status (Field) — varchar
  • email (Field2) — varchar
  • name (Field3) — varchar
  • birthDate (Field4) — DateTime
  • nickname (Field5) — varchar
  • intro (Field6) — varchar
  • profileImage (Field7) — varchar
  • provider (Field8) — Provider
  • createdAt (Field9) — DateTime
  • updatedAt (Field10) — DateTime
  • providerUserId (Field11) — varchar
  • passwordHash (Field12) — varchar