home *** CD-ROM | disk | FTP | other *** search

---

/ Network Support Encyclopedia 9 / novell-nsepro-1992-vol09.iso / graphics / apn_0292.pcl / 2-CREATE.PCX (.png)

< prev

next >

PC Paintbrush Image  |  1992-03-04  |  39KB  |  648x468  |  4-bit (4 colors)

Labels: book | bulletin board | reckoner | tree | window
OCR: CREATE TABLE Custorrer (PRIMARY KEY (CustID). CustID INT(4) Nams CHAR(30) Phone CHAR 10 CRFATE TABLE Inventory (PRIMARY KEY (PartID) PartiD INT{4} Description CHAR(30), Quantity INT4) CREATE TABLE Invoice (PRIMARY KEY {InvID} FOREIGN KEY cfk {CustID} REFERENCES Custoner ON DELETE CASCADE InvID INT{4} CustID INT{4} InvDate DATE): CREATE TABLE InvDetal (PRIMARY KEY (InvID LineNo) FOREIGN KEY lik InvID} REFERENCES Invelce ON DEL ETE CASCADE FOREIGN KEY pfk (Part) REFERENCES Inventory ON DELETE RESTRICT InvID INT(4 LineNo INT(2) Part INT(4), Quantity INT{4}, UnitPrice MONEY; Custormner Name ParID Quantir Involce IKEY LinsNo

---