juteukki

Tables (6)

comments (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • content (Field) — String
  • userId (Key2) — Long — Foreign key → users.id — NOT NULL
  • postId (Key3) — Long — Foreign key → posts.id — NOT NULL
  • parents_comment_id (Key4) — Long — Foreign key → comments.id — NOT NULL
  • createdAt (Field2) — Date
  • updatedAt (Field3) — Date

follow (Untitled6)

  • createdAt (Field) — Date
  • my_id (Key) — Long — Foreign key → users.id — NOT NULL
  • follower_id (Key2) — Long — Foreign key → users.id — NOT NULL

like (Untitled4)

  • Key — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → users.id — NOT NULL
  • id (Key3) — String — Foreign key → posts.id — NOT NULL

manager (Untitled5)

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

posts (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • viewCount (Field3) — Long
  • id (Key2) — Long — Foreign key → users.id — NOT NULL
  • createdAt (Field4) — Date
  • updatedAt (Field5) — Date

users (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • email (Field) — String
  • password (Field2) — String?
  • provider (Field3) — String?
  • nickname (Field4) — String
  • joinedAt (Field5) — Date