Please find below the schema for employee table .. its same table as in maker used for advance security purpose. thank you for your support and rectification of this issue that leads to further decision for the procurement of this product. Our oracle version is 19c.
CREATE TABLE "emp" (
"E_ID" NUMBER VISIBLE NOT NULL,
"Name" VARCHAR2(255 BYTE) VISIBLE,
"LastName" VARCHAR2(20 BYTE) VISIBLE,
"FirstName" VARCHAR2(10 BYTE) VISIBLE,
"Title" VARCHAR2(30 BYTE) VISIBLE,
"TitleOfCourtesy" VARCHAR2(25 BYTE) VISIBLE,
"BirthDate" DATE VISIBLE,
"HireDate" DATE VISIBLE,
"Address" VARCHAR2(60 BYTE) VISIBLE,
"City" VARCHAR2(15 BYTE) VISIBLE,
"Region" VARCHAR2(15 BYTE) VISIBLE,
"PostalCode" VARCHAR2(10 BYTE) VISIBLE,
"Country" VARCHAR2(15 BYTE) VISIBLE,
"HomePhone" VARCHAR2(24 BYTE) VISIBLE,
"Extension" VARCHAR2(4 BYTE) VISIBLE,
"Email" VARCHAR2(30 BYTE) VISIBLE,
"Photo" VARCHAR2(255 BYTE) VISIBLE,
"ReportsTo" NUMBER(11,0) VISIBLE,
"UserLevel" NUMBER(11,0) VISIBLE,
"Username" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
"Activated" CHAR(1 BYTE) VISIBLE NOT NULL,
"Profile" VARCHAR2(1000 BYTE) VISIBLE,
"Notes" VARCHAR2(1000 BYTE) VISIBLE,
"Password" VARCHAR2(255 BYTE) VISIBLE
)
-- Primary Key structure for table emp
ALTER TABLE "emp" ADD CONSTRAINT "SYS_C00802052" PRIMARY KEY ("E_ID");
-- Checks structure for table emp
ALTER TABLE "emp" ADD CONSTRAINT "SYS_C00802051" CHECK ("E_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "emp" ADD CONSTRAINT "SYS_C00802054" CHECK ("Username" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "emp" ADD CONSTRAINT "SYS_C00802055" CHECK ("Activated" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;