STOCK_PROJECT

Tables (5)

DEPT (Untitled5)

  • DNO (Key) — Primary key — NOT NULL
  • DNAME (Field)

EMPLOYEE (Untitled3)

  • ENO (Key) — Primary key — NOT NULL
  • ENAME (Field)
  • PERF (Field2)
  • DNO (Key2) — Foreign key → DEPT.DNO — NOT NULL

MEMBER (Untitled)

  • LNO (Key) — Primary key — NOT NULL
  • MID (Field)
  • PW (Field2)
  • GRADE (Field3)
  • ENO (Key2) — Foreign key → EMPLOYEE.ENO — NOT NULL

PRODUCT (Untitled2)

  • PNO (Key) — Primary key — NOT NULL
  • PNAME (Field)
  • STOCK (Field2)
  • INPRICE (Field3)
  • OUTPRICE (Field4)

TRADE (Untitled4)

  • TNO (Key2) — Primary key — NOT NULL
  • PNO (Key) — Foreign key → PRODUCT.PNO — NOT NULL
  • ENO (Key3) — Foreign key → EMPLOYEE.ENO — NOT NULL
  • TQUANT (Field2)
  • TDATE (Field)
  • FLAG (Field3)
  • TPRICE (Field4)