/*
  Warnings:

  - You are about to drop the column `remark` on the `EmployeeWork` table. All the data in the column will be lost.
  - You are about to drop the column `workEndDate` on the `EmployeeWork` table. All the data in the column will be lost.
  - You are about to drop the `EmployeeInCountryNotice` table. If the table is not empty, all the data it contains will be lost.

*/
-- DropForeignKey
ALTER TABLE "EmployeeInCountryNotice" DROP CONSTRAINT "EmployeeInCountryNotice_employeeId_fkey";

-- AlterTable
ALTER TABLE "EmployeeWork" DROP COLUMN "remark",
DROP COLUMN "workEndDate",
ADD COLUMN     "identityNo" TEXT;

-- DropTable
DROP TABLE "EmployeeInCountryNotice";