Your application allows you to manage Task and Project

entities.

You have to add missing annotations and code over entity classes

and converters to make it possible to store Task and Project

and their relations in specified tables.

:Requirements:

$(1).$Project. updates should be persisted in a table with thefollowing structure:

Table name: PROJECT$\_$EVENT$\_$UPDATES

Columns:

PROJECT$\_$ID : foreign key;

USER$\_$NAME : value of Itemupdate.user ;

EVENT$\_$DATE: value of Itemupdate. date

$(2)$Task$.$watchers should be persisted in a table with the

Table name: TODO$\_$WATCHERS :

Columns:TODO$\_$ID : foreign key;

LOGIN: value of string from the set.

$(3)$ Task.comments should prsisted in a table with the following structur

TODO$\_$Table name: COMMENTS with columns TODO$\_$ID$,$AUTHOR$,$ADD$\_$DATE, COMMENT ;

$(4)$Task$.$updates should prsisted in a table with the following structur

$1.$Table name:TODO$\_$UPDATES

$2.$columns:

$1.$TODO$\_$ID:foreing key$2.$AUTHOR:value of Itemupdate.user $3.$UPDATE$\_$DATE:value of Itemupdate.user

$(5)$Task$.$tags should be persisted in a table with the following structure

$1.$Table name:TODO$\_$TAGS

$2.$columns:

$1.$TODO$\_$ID:foreing key$2.$Name:key from the Map$3.$DESCRIPTION:value of Map

The following tables should exist after implementation:

$1.$ PROJECTS with columnS PROJECT$\_$ID$,$NAME ;$2.$PROJECT$\_$EVENT$\_$UPDATES with columnS PROJECT$\_$ID$,$USER$\_$NAME, EVENT$\_$DATE ;

$3.$TODOS with columns TODO$\_$ID$,$SUBJECT$,$ DETAILS;$4.$TODO$\_$WATCHERS with columnS TODO$\_$ID$,$LOGIN ;

$5.$TODO$\_$COMMENTS with columns TODO$\_$ID$,$AUTHOR$,$ADD$\_$DATE, COMMENT ;$6.$TODO$\_$UPDATES with columns TODO$\_$ID$,$AUTHOR$,$UPDATE$\_$DATE;

$7.$TODO$\_$WATCHERS with columnS TODO$\_$ID$,$NAME$,$DESCRIPTION $.$

@Entity

@Table$($name $=$ "PROJECTS"$)$

@NoArgsConstructor$($access$=$AccessLevel.PRIVATE$)$

public class Project $\{$

@Id

@Column$($name $=$ "PROJECT$\_$ID$")$

private Long id;

@Column$($name $=$ "NAME",nullable $=$ false$)$

private String name;

@Transient

private List updates$=$new ArrayList$<>()$ ;

private Project$($ProjectBuilder builder$)$

$\{$this$.$id$=$builder.id;this.name$=$builder.name; this.updates$=$builder.updates;$\}$

static ProjectBuilder builder$($Long id$,$String name$)$

$\{$

return new ProjectBuilder$($id$,$name$)$;

$\}$

static class ProjectBuilder

$\{$private final Long id;private final String name;

private final List updates$=$new ArrayList$<>()$;

ProjectBuilder$($Long id$,$String name$)$

$\{$this$.$id$=$id;this.name$=$name;

$\}$

ProjectBuilder add$($ItemUpdate update$)$

$\{$updates$.$add$($update$)$;

return this;

$\}$

Project build$()\{$return new Project$($this$)$;$\}$

@Entity

@Table$($name $=$ "TODOS"$)$

@NoArgsConstructor$($access$=$AccessLevel.PRIVATE$)$

public class Task $\{$

@Id

@Column$($name $=$ "TODO$\_$ID$")$

private Long id;

@Column$($name $=$ "SUBJECT",nullable $=$ false$)$

private String subject;

@Column$($name $=$ "DETAILS",columnDefinition $=$ "CLOB"$)$

private String details;

@Transient

private Set watchers$=$new HashSet$<>()$;

@Transient

private List comments$=$new ArrayList$<>()$;

@Transient

private List$<$ItemUpdate$>$ updates$=$new ArrayList$<>()$;

@Transient

private Map$<$String,String$>$ tags$=$new HashMap$<>()$;

private Task$($TaskBuilder builder$)$

$\{$

this.id$=$builder.id;this.subject$=$builder.subject;this.details$=$builder.details;this.watchers$=$builder.watchers;this.comments$=$builder.comments;

this.updates$=$builder.updates;

this.tags$=$builder.tags;$\}$

static TaskBuilder builder$($Long id$,$String subject,String details$)$

$\{$

return new TaskBuilder$($id$,$subject,details$)$;

$\}$

static class TaskBuilder

$\{$

private final Long id;private final String subject;private final String details;private final Set$<$String$>$ watchers$=$new HashSet$<>()$;

private final List$<$Comment$>$ comments$=$new ArrayList$<>()$;

private final List$<$ItemUpdate$>$ updates$=$new ArrayList$<>()$;

private final Map$<$String,String$>$ tags$=$new HashMap$<>()$;

public TaskBuilder$($Long id$,$ String subject, String details$)\{\}$

TaskBuilder addWatcher$($String watcher$)$

$\{$watchers$.$add$($watcher$)$; return this;

$\}$

TaskBuilder add$($Comment comment$)$

$\{$comments$.$add$($comment$)$;return this;

$\}$

TaskBuilder add$($ItemUpdate update$)$

$\{$updates$.$add$($update$)$;return this;$\}$

TaskBuilder addTag$($String name,String description$)$

$\{$tags$.$put$($name$,$description$)$;return this;$\}$

Task build$()$

$\{$return new Task$($this$)$;$\}$

@Embeddable

@NoArgsConstructor$($access$=$AccessLevel.PRIVATE$)$

public class ItemUpdate $\{$private String user;private LocalDate date;$\}$

@Embeddable

@NoArgsConstructor$($access$=$AccessLevel.PRIVATE$)$

public class Comment $\{$

@Column$($name $=$ "AUTHOR"$)$

private String author;

@Column$($name $=$ "ADD$\_$DATE"$)$

private LocalDate date;

@Column$($name $=$ "COMMENT"$)$

private String comment;

$\}\backslash$table$[[$Project$.$java $</$p$><$code class$=$"asciimath"$>$x$</$code$><$p$>,$Task.java $</$p$><$code class$=$"asciimath"$>$x$</$code$></$div$><$div$><$img src$=\text{'}$https:$//$media$.$cheggcdn.com$/$study$/7$fd$/7$fd$3015$c$-2$a$5$e$-47$cb$-$a$844-6$dd$7$f$4$cf$435$b$/$IMG$-20240120-$WA$0044.$jpg$\text{'}/></$div$>$