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)