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)