Untitled

package models;

import java.math.BigDecimal;
import java.sql.Timestamp;
import java.util.*;
import org.joda.*;
import javax.persistence.*;
import org.hibernate.annotations.ForeignKey;
import play.db.jpa.*;
import play.data.validation.*;

@Entity
@PersistenceUnit(name="db_saiiut")
@Table(name="alumnos")
public class Salumnos extends Model{
	
	@Id
	@Column(name="cve_alumno")
	public Integer cve_alumno;	
	
	public Boolean activo;
	public Boolean becado;

	@Column(name="cve_carrera")
	public Integer cveCarrera;

	@Column(name="cve_division")
	public Integer cveDivision;

	@Column(name="cve_generacion")
	public Integer cveGeneracion;

	@Column(name="cve_generacion_actual")
	public Integer cveGeneracionActual;

	@Column(name="cve_grupo")
	public Integer cveGrupo;

	@Column(name="cve_periodo_actual")
	public Integer cvePeriodoActual;

	@Column(name="cve_periodo_inicio")
	public Integer cvePeriodoInicio;

	@Column(name="cve_plan")
	public Integer cvePlan;

	@Column(name="cve_status")
	public Integer cveStatus;

	@Column(name="cve_turno")
	public Integer cveTurno;

	@Column(name="cve_unidad_academica")
	public Integer cveUnidadAcademica;

	@Column(name="cve_universidad")
	public Integer cve_universidad;

	@Column(name="fecha_alta")
	public Timestamp fechaAlta;
	
	@Column(name="grado_actual")
	public Short gradoActual;

	public String matricula;

	public String notas;

	public Short sancion;	
}

/********* Aca la tabla ********/


CREATE TABLE [alumnos] (
[cve_alumno] int NOT NULL,
[cve_universidad] int NULL,
[matricula] varchar(15) COLLATE Traditional_Spanish_CI_AS NULL,
[cve_grupo] int NULL DEFAULT NULL,
[cve_plan] int NULL DEFAULT NULL,
[cve_carrera] int NULL DEFAULT NULL,
[cve_division] int NULL DEFAULT NULL,
[cve_unidad_academica] int NULL DEFAULT NULL,
[cve_turno] int NULL DEFAULT NULL,
[cve_status] int NULL DEFAULT NULL,
[cve_periodo_actual] int NULL DEFAULT NULL,
[grado_actual] tinyint NULL DEFAULT NULL,
[fecha_alta] datetime NULL,
[becado] bit NULL,
[notas] varchar(200) COLLATE Traditional_Spanish_CI_AS NULL DEFAULT NULL,
[activo] bit NULL,
[cve_generacion] int NULL DEFAULT NULL,
[cve_periodo_inicio] int NULL DEFAULT NULL,
[cve_generacion_actual] int NULL DEFAULT NULL,
[sancion] bit NULL DEFAULT NULL,
CONSTRAINT [PK__alumnos] PRIMARY KEY ([cve_alumno]) 
)
GO