Spring Assignment

Tables (3)

COMMENT (comment)

  • commentId (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → USER.userId — NOT NULL
  • postId (Key3) — bigint — Foreign key → POST.postId — NOT NULL
  • contents (Field) — varchar
  • createdAt (Field2) — datetime
  • modifiedAt (Field3) — datetime

POST (post)

  • postId (Key) — bigint — Primary key — NOT NULL
  • userId (Key2) — bigint — Foreign key → USER.userId — NOT NULL
  • title (Field) — varchar
  • contents (Field3) — varchar
  • createdAt (Field4) — datetime
  • moditiedAt (Field5) — datetime

USER (user)

  • userId (Key) — bigint — Primary key — NOT NULL
  • nickname (Field) — varchar — NOT NULL
  • password (Field2) — varchar
  • createdAt (Field3) — datetime
  • modifiedAt (Field4) — datetime