stamp
Tables (7)
customer (Untitled6)
- Key — Primary key — NOT NULL
- custid(식별자) (Field)
- tel (Field2)
- address (Field3)
- age (Field4)
- gender (Field5)
- grade (Field6)
- regdate (Field7)
dept (Untitled)
- deptno (Key) — Primary key — NOT NULL
- dname (Field)
- loc (Field2)
emp (Untitled2)
- empno (fk2) — Primary key — NOT NULL
- mgr (fk) — Primary key — NOT NULL
- Key — Foreign key → dept.deptno — NOT NULL
- ename (Field)
- job (Field2)
- mgr (Field3)
- deptno (fk22) — Foreign key → emp.empno — NOT NULL
- mgr (fk3) — Foreign key → emp.mgr — NOT NULL
- Key (Key2) — Foreign key → emp.Key — NOT NULL
emp_detail (Untitled3)
- Key — Primary key — NOT NULL
- empno (fk2) — Foreign key → emp.empno — NOT NULL
- mgr (fk) — Foreign key → emp.mgr — NOT NULL
- Key (Key2) — Foreign key → emp.Key — NOT NULL
- hiredate (Field)
- sal (Field2)
- comm (Field3)
order (Untitled5)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → product.Key — NOT NULL
- empno (fk2) — Foreign key → product.empno — NOT NULL
- mgr (fk) — Foreign key → product.mgr — NOT NULL
- Key (Key22) — Foreign key → product.Key — NOT NULL
- Key (Key3) — Foreign key → customer.Key — NOT NULL
- prodno(fk) (Field)
- order_DateTime (Field2)
- sale_price (Field3)
- deliver_add (Field4)
- deliver_tel (Field5)
order_detail (Untitled7)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → order.Key — NOT NULL
- Key (Key22) — Foreign key → order.Key — NOT NULL
- empno (fk2) — Foreign key → order.empno — NOT NULL
- mgr (fk) — Foreign key → order.mgr — NOT NULL
- Key (Key222) — Foreign key → order.Key — NOT NULL
- Key (Key3) — Foreign key → order.Key — NOT NULL
- Key (Key4) — Foreign key → customer.Key — NOT NULL
- Field
product (Untitled4)
- Key — Primary key — NOT NULL
- empno (fk2) — Foreign key → emp.empno — NOT NULL
- mgr (fk) — Foreign key → emp.mgr — NOT NULL
- Key (Key2) — Foreign key → emp.Key — NOT NULL
- pno(식별자) (Field)
- prod_name (Field2)
- unit price (Field3)
- stock (Field4)
- prod_type (Field5)