erd books

Tables (8)

Untitled (Books)

  • Key (book_ID) — varchar(51) — Primary key — NOT NULL
  • Field (ISBN) — varchar(51)
  • Field (date_of_Publication) — date
  • Field (date_Acquired) — date
  • Field (book_Title) — varchar(51)
  • Field (book_Recommended_Price) — number
  • Field (book_Comments) — varchar(51)
  • Key (author_ID) — varchar(51) — Foreign key → Untitled.Key — NOT NULL
  • Key (book_Category_Code2) — varchar(51) — Foreign key → Untitled.Key — NOT NULL

Untitled (Authors)

  • Key (author_ID) — varchar(51) — Primary key — NOT NULL
  • Field (author_First_Name) — varchar(51)
  • Field (author_Initials) — varchar(51)
  • Field (author_Last_Name) — varchar(51)
  • Field (author_Date_of_Birth) — date
  • Field (author_Gender_MFU) — varchar(51)
  • Field (author_Contact_Details) — varchar(51)
  • Field (author_Other_Details) — varchar(51)

Untitled (Book_Categories)

  • Key (book_Category_Code) — varchar(51) — Primary key — NOT NULL
  • Field (book_Category_Description) — varchar(51)

Untitled (Order_Items)

  • Key (item_Number) — number — Primary key — NOT NULL
  • Field (item_Agreed_Price) — number
  • Key (book_ID) — varchar(51) — Foreign key → Untitled.Key — NOT NULL
  • Field (item_Comment) — varchar(51)
  • Key (order_ID) — varchar(51) — Foreign key → Untitled.Key — NOT NULL

Untitled (Orders)

  • Key (order_ID) — varchar(51) — Primary key — NOT NULL
  • Key (customer_ID) — varchar(51) — Foreign key → Untitled.Key — NOT NULL
  • Field (order_Date) — date
  • Field (order_Value) — varchar(51)

Untitled (Customers)

  • Key (customer_ID) — varchar(51) — Primary key — NOT NULL
  • Field (customer_Code) — varchar(51)
  • Field (customer_Name) — varchar(51)
  • Field (customer_Address) — varchar(51)
  • Field (customer_Phone) — varchar(10)
  • Field (custormer_Email) — varchar(25)

Untitled (Contacts)

  • Key (contact_ID) — varchar(51) — Primary key — NOT NULL
  • Key (Contact_Type_Code) — varchar(51) — Foreign key → Untitled.Key — NOT NULL
  • Field (Contact_FirstName) — vacrhar(30)
  • Field (Contact_LastName) — varchar(30)
  • Field (Contact_WorkPhonenumber) — varchar(10)
  • Field (Contact_CellPhonenumber) — varchar(10)
  • Field (Contact_OtherDetails) — varchar(51)

Untitled (Ref_Contact_Types)

  • Key (Contact_Type_Code) — varchar(51) — Primary key — NOT NULL
  • Field (contact_Type_Description) — varchar(51)