Specialist Bookseller
Tables (8)
Untitled (Books)
- Key (book_ID*) — varchar2(50) — Primary key — NOT NULL
- Field (ISBN) — varchar2(100)
- Field (date_of_Publication) — date
- Field (date_Aquired) — date
- Field (book_Title) — varchar2(50)
- Field (book_Recommended_Price) — number
- Field (book_Comments)
- Key (book_Category_Code*) — varchar2(50) — Foreign key → Untitled4.Key — NOT NULL
- Key (author_ID*) — varchar2(50) — Foreign key → Untitled.Key — NOT NULL
Untitled (Authors)
- Key (author_ID*) — varchar2(50) — Primary key — NOT NULL
- Field (author_First_Name) — varchar2(50)
- Field (author_Initials) — varchar2(10)
- Field (author_Last_Name) — varchar2(50)
- Field (author_Date_of_Birth) — date
- Field (author_Gender_MFU) — varchar2(50)
- Field (author_Contact_Details) — varchar2(50)
- Field (author_Other_Details) — varchar2(50)
Untitled (Other_Items)
- Key (item_Number) — number — Primary key — NOT NULL
- Key (order_ID*) — varchar2(50) — Foreign key → Untitled3.Key — NOT NULL
- Key (book_ID*) — varchar2(50) — Foreign key → Untitled.Key — NOT NULL
- Field (item_Agreed_Price) — number
- Field (item_Comment)
Untitled2 (Customers)
- Key (customer_ID*) — varchar2(50) — Primary key — NOT NULL
- Field (customer_Code) — varchar2(50)
- Field (customer_Name) — varchar2(50)
- Field (customer_Address) — varchar2(50)
- Field (customer_Phone) — varchar2(50)
- Field (customer_Email) — varchar2(50)
Untitled3 (Orders)
- Key (order_ID*) — varchar2(50) — Primary key — NOT NULL
- Key (customer_ID*) — varchar2(50) — Foreign key → Untitled2.Key — NOT NULL
- Field (order_Date*) — date
- Field (order_Value) — number
Untitled4 (Book_Categories)
- Key (book_Category_Code*) — varchar2(50) — Primary key — NOT NULL
- Field (book_Category_Description) — varchar2(50)
Untitled5 (Ref_Contact_Types)
- Key (contact_Type_Code*) — varchar2(50) — Primary key — NOT NULL
- Field (contact_Type_Description) — varchar2(50)
Untitled6 (Contacts)
- Key (contact_ID*) — varchar2(50) — Primary key — NOT NULL
- Field (contact_FirstName) — varchar2(50)
- Field (contact_LastName) — varchar2(50)
- Field (contact_WorkPhonenumber) — varchar2(50)
- Field (contact_CellPhonenumber) — varchar2(50)
- Field (contact_OtherDetails) — varchar2(50)
- Key (contact_Type_Code*) — varchar2(50) — Foreign key → Untitled5.Key — NOT NULL