d

Tables (8)

Authors_yh (Untitled)

  • author_ID* (author_id) — int(20) — Primary key — NOT NULL
  • author_First_Name (author_first_name) — varchar(20)
  • author_Initials (author_initials) — varchar(20)
  • author_Last_Name (author_last_name) — varchar(20)
  • author_Date_of_Birth (author_date_of_birth) — char(8)
  • author_Gender_MFU (author_gender_mfu) — char(8)
  • author_Contact_Details (author_contact_details) — varchar(50)
  • author_Other_Details (author_other_details) — varchar(50)

Book_Categories_yh (Untitled4)

  • book_Category_Code* (book_category_code) — int(20) — Primary key — NOT NULL
  • book_Category_Description (book_category_description) — varchar(10)

Books_yh

  • book_ID* (book_id) — int(11) — Primary key — NOT NULL
  • ISBN (isbn) — varchar(50)
  • book_Category_Code* (book_category_code) — int(20) — Foreign key → Book_Categories_yh.book_Category_Code* — NOT NULL
  • author_ID* (author_id) — int(20) — Foreign key → Authors_yh.author_ID* — NOT NULL
  • date_of_Publication (Field) — char(8)
  • date_Acquired (Field2) — char(8)
  • book_Title (Field3) — varchar(50)
  • book_Recommended_Price (Field4) — number
  • book_Comments (Field5) — varchar(50)

Contacts (Untitled7)

  • contact_ID (Key) — varchar(50) — Primary key — NOT NULL
  • Contact_FirstName (FirstName) — varchar(50)
  • Contact_LastName (Field) — varchar(50)
  • Contact_WorkPhonenumber (Field2) — varchar(50)
  • Contact_CellPhonenumber (Field3) — varchar(50)
  • Contact_OtherDetails (Field4) — varchar(50)
  • Cpmtact_Type_Code (Key2) — varchar(50) — Foreign key → Ref_Contact_Types.Cpmtact_Type_Code — NOT NULL

Customers_yh (Untitled2)

  • customer_ID* (customer_id) — int(20) — Primary key — NOT NULL
  • customer_Code (customer_code) — int(11)
  • customer_Name (customer_name) — varchar(20)
  • customer_Address (customer_address) — varchar(255)
  • customer_Phone (customer_phone) — varchar(20)
  • customer_Email (customer_email) — varchar(255)

Order_Items (Untitled5)

  • item_Number (Key2) — number — Primary key — NOT NULL
  • order_ID* (order_id) — varchar(50) — Foreign key → Orders.order_ID* — NOT NULL
  • book_ID* (book_id) — int(11) — Foreign key → Books_yh.book_ID* — NOT NULL
  • item_Agreed_Price (Field) — number
  • item_Comment (Field2) — varchar(50)

Orders (Untitled3)

  • order_ID* (order_id) — varchar(50) — Primary key — NOT NULL
  • customer_ID* (customer_id) — varchar(50) — Foreign key → Customers_yh.customer_ID* — NOT NULL
  • order_Date (order_date) — char(8)
  • order_Value (order_value) — varchar(10)

Ref_Contact_Types (Untitled6)

  • Cpmtact_Type_Code (Key) — varchar(50) — Primary key — NOT NULL
  • contact_Type_Description (Field) — varchar(50)