MOHAE

Tables (4)

Comments (CopyOfUntitled)

  • Id (Key) — Long — Primary key — NOT NULL
  • nickname (Field3) — String
  • comment (Field4) — String
  • insert_dt (Field5) — String
  • postId (Key2) — Long — Foreign key → Post.Id — NOT NULL
  • userId (Key22) — Long — Foreign key → User.Id — NOT NULL

Likes (CopyOfCopyOfUntitled2)

  • Id (Key2) — String — Primary key — NOT NULL
  • is_check (Field4) — boolean
  • userId (Key22) — Long — Foreign key → User.Id — NOT NULL
  • postId (Key23) — Long — Foreign key → Post.Id — NOT NULL

Post (Untitled)

  • Id (Key2) — Long — Primary key — NOT NULL
  • title (Field3) — String
  • content (Field4) — String
  • imageUrl (Field5) — String
  • commentCount (Field6) — Long
  • likeCount (Key) — Long — NOT NULL
  • userId (Key22) — Long — Foreign key → User.Id — NOT NULL

User (CopyOfUntitled2)

  • Id (Key2) — Long — Primary key — NOT NULL
  • username (Field2) — Long
  • nickname (Field3) — Long
  • password (Field4) — Long