report#1
Tables (5)
J (Untitled)
- J# (Key) — VARCHAR2(4) — Primary key — NOT NULL
- JNAME (Field) — VARCHAR2(10)
- CITY (Field2) — VARCHAR2(6)
P
- P# (S#) — VARCHAR2(4) — Primary key — NOT NULL
- PNAME (Field) — VARCHAR2(10)
- COLOR (Field2) — VARCHAR2(6)
- WEIGHT (Field3) — NUMBER
- CITY (Field4) — VARCHAR2(6)
S
- S# — VARCHAR2(4) — Primary key — NOT NULL
- SNAME (Field) — VARCHAR2(10)
- STATUS (Field2) — NUMBER
- CITY (Field3) — VARCHAR2(6)
SP (Untitled2)
- S# (Key) — VARCHAR2(4) — Primary key — NOT NULL
- P# (Key2) — VARCHAR2(4) — Primary key — NOT NULL
- QTY (Field) — NUMBER
SPJ (Untitled3)
- S# (Key) — VARCHAR2(4) — Primary key — NOT NULL
- P# (Key2) — VARCHAR2(4) — Primary key — NOT NULL
- J# (Key3) — VARCHAR2(4) — Primary key — NOT NULL
- QTY (Field) — NUMBER