|
楼主 |
发表于 10-10-2004 07:07 PM
|
显示全部楼层
create table BillbuyingProfile (
BillbuyingID VARCHAR2(14) NOT NULL,
LogonID VARCHAR2(10) NOT NULL,
Price NUMBER(7,2) NOT NULL,
QuantityBuy NUMBER(5) NOT NULL,
TotalPrice NUMBER(5,2) NOT NULL,
ProductName VARCHAR2(50) NOT NULL,
Address1 VARCHAR2(50) NOT NULL,
City VARCHAR2(20) NOT NULL,
State VARCHAR(20) NOT NULL,
Phone VARCHAR2(20),
Email VARCHAR2(50) NOT NULL,
CONSTRAINT BillbuyingProfile_pk PRIMARY KEY(BillbuyingID),
CONSTRAINT BillbuyingProfile_fk FOREIGN KEY(LogonID) references UserProfile(LogonID))
/
INSERT INTO BillbuyingProfile (BillbuyingID, LogonID, Price, QuantityBuy, TotalPrice, ProductName, Address1, City, State, Phone, Email)
VALUES ('B8794864','LZ08879','25.00','100','2500.00','Office_Chair','66_Alpine_Park_Rd.','Sinagpore','Singapore','+65-65986565','[email protected]'); |
|