Notes

----WorkspaceListDTO.java-----

/*
* Copyright 2006-2021 HighRadius Corporation
*/

package com.highradius.g4.redline.dto;

import javax.xml.bind.annotation.XmlRootElement;

/**
* The Class WorkspaceListDTO represents the resource g4_workspace.
*
* @author shouvik.ch
* @author shourya.sisodia
*/
@XmlRootElement(name="g4_workspace")

public class WorkspaceListDTO {

/** The workspace id. */
private Long pkWorkspaceId;

/** The name of workspace. */
private String name;

/** The description of the workspace. */
private String description;


/**
* Gets the workspace id.
*
* @return the workspace id
*/
public Long getPkWorkspaceId() {
return pkWorkspaceId;
}

/**
* Sets the workspace id.
*
* @param pkWorkspaceId the new workspace id
*/
public void setPkWorkspaceId(Long pkWorkspaceId) {
this.pkWorkspaceId = pkWorkspaceId;
}

/**
* Gets the name.
*
* @return the name
*/
public String getName() {
return name;
}

/**
* Sets the name.
*
* @param name the new name
*/
public void setName(String name) {
this.name = name;
}

/**
* Gets the description
*
* @return the description
*/
public String getDescription() {
return description;
}


/**
* Sets the description
*
* @param description the new description
*/
public void setDescription(String description) {
this.description = description;
}



}


----WorkspaceList.java----- [entity]
/*
* Copyright 2006-2021 HighRadius Corporation
*/
package com.highradius.g4.redline.entity;

import java.sql.Timestamp;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.annotations.SQLDelete;
import org.hibernate.annotations.Where;

/**
* The WorkspaceList entity.
*
* @author shouvik.ch
* @author shourya.sisodia
*/
@Entity
@Table(name = "g4_workspace")
@SQLDelete(sql = "UPDATE g4_workspace SET is_deleted = 1, update_time=now(), update_user='system' WHERE pk_workspace_id = ?")
@Where(clause = "is_deleted = 0")
public class WorkspaceList {

/** The workspace id. */
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name ="pk_workspace_id")
private Long pkWorkspaceId;

/** The name. */
@Column(name = "name")
private String name;

/** The description. */
@Column(name = "description")
private String description;

/** The is deleted. */
@Column(name = "is_deleted")
private boolean isDeleted = false;

/** The create user. */
@Column(name = "create_user")
private String createUser;

/** The create time. */
@Column(name = "create_time")
private Timestamp createTime;

/** The update user. */
@Column(name = "update_user")
private String updateUser;

/** The update time. */
@Column(name = "update_time")
private Timestamp updateTime;

/** The account id. */
@Column(name = "account_id")
private String accountId;


/**
* Gets the creates the user.
*
* @return the creates the user
*/
public String getCreateUser() {
return createUser;
}

/**
* Sets the creates the user.
*
* @param createUser the new creates the user
*/
public void setCreateUser(String createUser) {
this.createUser = createUser;
}

/**
* Gets the creates the time.
*
* @return the creates the time
*/
public Timestamp getCreateTime() {
return createTime;
}

/**
* Sets the creates the time.
*
* @param createTime the new creates the time
*/
public void setCreateTime(Timestamp createTime) {
this.createTime = createTime;
}

/**
* Gets the update user.
*
* @return the update user
*/
public String getUpdateUser() {
return updateUser;
}

/**
* Sets the update user.
*
* @param updateUser the new update user
*/
public void setUpdateUser(String updateUser) {
this.updateUser = updateUser;
}

/**
* Gets the update time.
*
* @return the update time
*/
public Timestamp getUpdateTime() {
return updateTime;
}

/**
* Sets the update time.
*
* @param updateTime the new update time
*/
public void setUpdateTime(Timestamp updateTime) {
this.updateTime = updateTime;
}

/**
* Gets the workspace id
*
* @return the workspace id
*/
public Long getPkWorkspaceId() {
return pkWorkspaceId;
}

/**
* Sets the workspace id
*
* @param pkWorkspaceId the new workspace id
*/
public void setPkWorkspaceId(Long pkWorkspaceId) {
this.pkWorkspaceId = pkWorkspaceId;
}

/**
* Gets the name
*
* @return the name
*/
public String getName() {
return name;
}
/**
* Sets the name
*
* @param name the new name
*/

public void setName(String name) {
this.name = name;
}

/**
* Gets the description
*
* @return the description
*/
public String getDescription() {
return description;
}

/**
* Sets the description
*
* @param description the new description
*/

public void setDescription(String description) {
this.description = description;
}


/**
* Gets the account id
*
* @return the account id
*/
public String getAccountId() {
return accountId;
}
/**
* Sets the account id
*
* @param accountId the new account id
*/

public void setAccountId(String accountId) {
this.accountId = accountId;
}

/**
* Checks if is deleted.
*
* @return the isDeleted
*/
public boolean isDeleted() {
return isDeleted;
}

/**
* Sets the deleted.
*
* @param isDeleted the isDeleted to set
*/
public void setDeleted(boolean isDeleted) {
this.isDeleted = isDeleted;
}

}



----MapWorkspace.java----[entity]

/*
* Copyright 2006-2021 HighRadius Corporation
*/
package com.highradius.g4.redline.entity;

import java.sql.Timestamp;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import org.hibernate.annotations.SQLDelete;
import org.hibernate.annotations.Where;
import javax.persistence.CascadeType;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;

/**
* The Class MapWorkspace
* @author shouvik.ch
* @author shourya.sisodia
*/
@Entity
@Table(name = "map_workspace_user")
@SQLDelete(sql = "UPDATE map_workspace_user SET is_deleted = 1, update_time=now(), update_user='system' WHERE pk_map_workspace_user_id = ?")
@Where(clause = "is_deleted = 0")
public class MapWorkspace {

/** The pk map workspace user id. */
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name ="pk_map_workspace_user_id")
private Long pkMapWorkspaceUserId;

/** The fk workspace id. */
@ManyToOne(cascade = CascadeType.ALL)
@JoinColumn(name = "fk_workspace_id")
private WorkspaceList fkWorkspaceId;

/** The fk user id. */
@Column(name = "fk_user_id")
private Integer fkUserId;

/** The is deleted. */
@Column(name ="is_deleted")
private boolean isDeleted = false;

/** The user role. */
@Column(name = "user_role")
private String userRole;

/** The create user. */
@Column(name = "create_user")
private String createUser;

/** The create date. */
@Column(name = "create_time")
private Timestamp createTime;

/** The update user. */
@Column(name = "update_user")
private String updateUser;

/** The update date. */
@Column(name = "update_time")
private Timestamp updateTime;

/**
* Gets the pk map workspace user id.
*
* @return the pkWorkspaceUserId
*/
public Long getPkMapWorkspaceUserId() {
return pkMapWorkspaceUserId;
}

/**
* Sets the pk map workspace user id.
*
* @param pkWorkspaceUserId the pkMapWorkspaceId to set
*/
public void setPkMapWorkspaceUserId(Long pkMapWorkspaceUserId) {
this.pkMapWorkspaceUserId = pkMapWorkspaceUserId;
}

/**
* Gets the fk workspace id.
*
* @return the fkWorkspaceId
*/
public WorkspaceList getFkWorkspaceId() {
return fkWorkspaceId;
}

/**
* Sets the fk workspace id id.
*
* @param fkWorkspaceId the fkWorkspaceId to set
*/
public void setFkWorkspaceId(WorkspaceList fkWorkspaceId) {
this.fkWorkspaceId = fkWorkspaceId;
}

/**
* Gets the fk user id.
*
* @return the fkUserId
*/
public Integer getFkUserId() {
return fkUserId;
}

/**
* Sets the fk user id.
*
* @param fkUserId the fkUserId to set
*/
public void setFkUserId(Integer fkUserId) {
this.fkUserId = fkUserId;
}

/**
* Checks if is deleted.
*
* @return the isDeleted
*/
public boolean isDeleted() {
return isDeleted;
}

/**
* Sets the deleted.
*
* @param isDeleted the isDeleted to set
*/
public void setDeleted(boolean isDeleted) {
this.isDeleted = isDeleted;
}

/**
* Gets the user role.
*
* @return the userRole
*/
public String getUserRole() {
return userRole;
}

/**
* Sets the user role.
*
* @param useRole the userRole to set
*/
public void setUserRole(String userRole) {
this.userRole = userRole;
}

/**
* Gets the creates the user.
*
* @return the createUser
*/
public String getCreateUser() {
return createUser;
}


/**
* Sets the creates the user.
*
* @param createUser the createUser to set
*/
public void setCreateUser(String createUser) {
this.createUser = createUser;
}

/**
* Gets the creates the time.
*
* @return the createTime
*/
public Timestamp getCreateTime() {
return createTime;
}

/**
* Sets the creates the time.
*
* @param createTime the createTime to set
*/
public void setCreateTime(Timestamp createTime) {
this.createTime = createTime;
}

/**
* Gets the update user.
*
* @return the updateUser
*/
public String getUpdateUser() {
return updateUser;
}

/**
* Sets the update user.
*
* @param updateUser the updateUser to set
*/
public void setUpdateUser(String updateUser) {
this.updateUser = updateUser;
}

/**
* Gets the update time.
*
* @return the updateTime
*/
public Timestamp getUpdateTime() {
return updateTime;
}

/**
* Sets the update time.
*
* @param updateTime the updateTime to set
*/
public void setUpdateDate(Timestamp updateTime) {
this.updateTime = updateTime;
}

}