spring-lv3

Tables (3)

comment (Untitled3)

  • Long (id) — bigint — Primary key — NOT NULL
  • Long (memo_id) — bigint — Foreign key → memo.Long — NOT NULL
  • Long (user_id) — bigint — Foreign key → user.Long — NOT NULL
  • String (username) — varchar(255)
  • String (comment) — varchar(255)
  • LocalDateTime (created_at) — datetime(6)
  • LocalDateTime (modified_at) — datetime(6)

memo (Untitled2)

  • Long (id) — bigint — Primary key — NOT NULL
  • Stringt (title) — varchar(255)
  • String (username) — varchar(255)
  • String (contents) — varchar(500)
  • LocalDateTime (created_at) — datetime(6)
  • LocalDateTime (modified_at) — datetime(6)

user (Untitled)

  • Long (id) — bigint — Primary key — NOT NULL
  • String (username) — varchar(255)
  • String (password) — varchar(255)
  • UserRoleEnum (role) — enum('admin,'user')