using System; using Microsoft.EntityFrameworkCore.Migrations; using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; #nullable disable namespace vendorApproverBackend.Migrations { /// public partial class EvaluationData1 : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "evaluation_data", columns: table => new { id = table.Column(type: "bigint", nullable: false) .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), status = table.Column(type: "integer", nullable: false), total_score = table.Column(type: "double precision", nullable: false), evaluation_date = table.Column(type: "text", nullable: false), evaluated_by = table.Column(type: "text", nullable: false), timestmp = table.Column(type: "timestamp with time zone", nullable: false), request_renew_id = table.Column(type: "bigint", nullable: false), Evaluation = table.Column(type: "jsonb", nullable: false) }, constraints: table => { table.PrimaryKey("PK_evaluation_data", x => x.id); }); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "evaluation_data"); } } }