package entity;

import java.util.Date;
import java.util.List;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.ForeignKey;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.Lob;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import com.querydsl.core.annotations.QueryEntity;
import javax.persistence.OneToMany;
import javax.persistence.CascadeType;
import javax.persistence.FetchType;

@QueryEntity
@Entity
@Table(name = "Post")
public class Post {
    @Id
    @Column(name = "post_id", length = 64, nullable = false)
    public String postid;

    @Column(name = "title", length = 255, nullable = false)
    public String posttitle;

    @Lob
    @Column(name = "content", nullable = false)
    public String postcontent;

    @Column(name = "author_id", length = 36, nullable = false)
    public String postuserid;

    @ManyToOne(optional = false)
    @JoinColumn(name = "author_id", referencedColumnName = "user_id", foreignKey = @ForeignKey(name = "fk_post_user"), insertable = false, updatable = false)
    public User author;
    
    @Column(name = "created_at", nullable = false)
    @Temporal(TemporalType.TIMESTAMP)
    public Date posttime;

    @Column(name = "reply_count", nullable = false)
    public int replytime;

    @Column(name = "view_count", nullable = false)
    public int readtime;
}