sparta-Lv3

Tables (3)

Comment (comment)

  • id — bigint — Primary key
  • postId (postid) — bigint
  • username — varchar(100)
  • contents — varchar(100)

Memo (memo)

  • id — bigint — Primary key — NOT NULL
  • Title (title) — varchar(100)
  • contents — varchar(500)
  • username — varchar(100)
  • createdAt (created_at) — timestamp
  • modifiedAt (modified_at) — timestamp

User (user)

  • username — varchar(100) — Primary key
  • password — varchar(100)
  • role — varchar(10)