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)