학습용

테이블 (4)

class_tbl (Untitled4)

  • class_id (Key) — number — 기본 키 — NOT NULL
  • name (Field) — varchar2(30)

mydelpt (Untitled2)

  • deptid (Field) — number
  • deptname (Field2) — char

myemp (Untitled)

  • empid (Field) — number
  • empname (Field2) — char
  • age (Field3)
  • deptid (Field4) — number

student (Untitled3)

  • id (Key) — number — 기본 키 — NOT NULL
  • name (Field) — varchar2(15)
  • score (Field2) — number
  • score (Field3) — number
  • class_id (Key2) — number — 외래 키 → class_tbl.class_id — NOT NULL