second

Tables (5)

account (계좌)

  • acct no (Key) — Primary key — NOT NULL
  • amt (Field)
  • branch (Field2)
  • acctmgr (Field3)
  • customerid (Key2) — char(3) — Foreign key → customer.customerid — NOT NULL

customer (고객)

  • customerid (Key) — char(3) — Primary key — NOT NULL
  • password (Field) — varchar2(10)
  • customername (Field2) — varchar2(10)
  • address (Field3) — varchar2(15)
  • telephone (Field4) — char(15)

dept (부서)

  • deptno (Key) — Primary key — NOT NULL
  • dname (Field)
  • loc (Field2)

emp (직원)

  • empno (Key) — Primary key — NOT NULL
  • ename (Field)
  • job (Field2)
  • hiredate (Field3)
  • sal (Field6)
  • comm (Field4)
  • mgr (Field5)
  • deptno (Key2) — Foreign key → dept.deptno — NOT NULL

subject (과목)

  • subno (Key) — Primary key — NOT NULL
  • subname (Field)