package com.dacrt.SBIABackend.entity;

import java.util.Date;

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 javax.validation.constraints.NotNull;

import org.springframework.lang.NonNull;

@Entity
@Table(name = "externalreqs",schema = "main")
public class Externalreqs {
	
	
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	private Integer id;

	@NotNull
	private int requesterid;
	
	@NotNull
	private int workerid;
	
	@NotNull
	private int status;
	
	private String requirements;
	
	private int externalreqtermpar;
	
	private String scenary;
	
	private String plan;
	
	@NonNull
	@Column(columnDefinition = "timestamp without time zone NOT NULL default now()")
	private Date createdat;
	
	@NonNull
	@Column(columnDefinition = "timestamp without time zone NOT NULL default now()")
	private Date modifiedat;

	public Externalreqs() {
		super();
		// TODO Auto-generated constructor stub
	}

	public Externalreqs(Integer id, @NotNull int requesterid, @NotNull int workerid, @NotNull int status,
			String requirements, int externalreqtermpar, String scenary, String plan, Date createdat, Date modifiedat) {
		super();
		this.id = id;
		this.requesterid = requesterid;
		this.workerid = workerid;
		this.status = status;
		this.requirements = requirements;
		this.externalreqtermpar = externalreqtermpar;
		this.scenary = scenary;
		this.plan = plan;
		this.createdat = createdat;
		this.modifiedat = modifiedat;
	}

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public int getRequesterid() {
		return requesterid;
	}

	public void setRequesterid(int requesterid) {
		this.requesterid = requesterid;
	}

	public int getWorkerid() {
		return workerid;
	}

	public void setWorkerid(int workerid) {
		this.workerid = workerid;
	}

	public int getStatus() {
		return status;
	}

	public void setStatus(int status) {
		this.status = status;
	}

	public String getRequirements() {
		return requirements;
	}

	public void setRequirements(String requirements) {
		this.requirements = requirements;
	}

	public int getExternalreqtermpar() {
		return externalreqtermpar;
	}

	public void setExternalreqtermpar(int externalreqtermpar) {
		this.externalreqtermpar = externalreqtermpar;
	}

	public String getScenary() {
		return scenary;
	}

	public void setScenary(String scenary) {
		this.scenary = scenary;
	}

	public String getPlan() {
		return plan;
	}

	public void setPlan(String plan) {
		this.plan = plan;
	}

	public Date getCreatedat() {
		return createdat;
	}

	public void setCreatedat(Date createdat) {
		this.createdat = createdat;
	}

	public Date getModifiedat() {
		return modifiedat;
	}

	public void setModifiedat(Date modifiedat) {
		this.modifiedat = modifiedat;
	}
	
}