ㅁㅁ

Tables (3)

HEMP

  • EMPID — NUMBER(4) — Primary key — NOT NULL
  • BIRTH — DATE
  • HIREDATE — DATE
  • PHONE — NVARCHAR2(20)
  • ADDRESS — NVARCHAR2(20)
  • DNAME — NVARCHAR2(20)
  • JOB_LEVEL — NVARCHAR2(10)
  • ENAME — NVARCHAR2(20)

LOGIN

  • EMPID — NUMBER(4) — Foreign key → HEMP.EMPID — NOT NULL
  • EMPPW — NVARCHAR2(20)

SALARY

  • SALID — NUMBER(4) — Primary key — NOT NULL
  • EMPID — NUMBER(4) — Foreign key → HEMP.EMPID — NOT NULL
  • SALARY — NUMBER
  • COMM — NUMBER