1117mission

Tables (8)

Untitled (authors_bks)

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

Untitled (customers_bks)

  • Key (customer_ID) — varchar — Primary key — NOT NULL
  • Field (customer_Code) — varchar
  • Field (customer_Name) — varchar
  • Field (customer_Address) — varchar
  • Field (customer_Phone) — varchar
  • Field (customer_Email) — varchar

Untitled (orders_bks)

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

Untitled (order_items_bks)

  • Key (item_Number) — int — Primary key — NOT NULL
  • Field (itme_Agreed_Price) — int
  • Field (itme_Comment) — int
  • book_ID — varchar — Foreign key → books.book_ID — NOT NULL
  • Key (order_ID) — varchar — Foreign key → Untitled.Key — NOT NULL

Untitled (book_categories_bks)

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

Untitled (ref_contact_type_bks)

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

Untitled (contacts_bks)

  • Key (contacts_ID) — varchar — Primary key — NOT NULL
  • Field (contacts_FirstName) — varchar
  • Field (contacts_LastName) — varchar
  • Field (contacts_WorkPhonenumber) — varchar
  • Field (contacts_CellPhonenumber) — varchar
  • Field (contacts_OtherDetails) — varchar
  • Key (contact_Type_Code) — varchar — Foreign key → Untitled.Key — NOT NULL

books (books_bks)

  • book_ID — varchar — Primary key — NOT NULL
  • Field — int
  • Field2 (date_of_Publication) — date
  • Field2 (date_Acquired) — date
  • Field2 (book_title) — varchar
  • Field2 (book_Recommended_Price) — int
  • Field2 (book_Comment) — varchar
  • Key (author_ID) — varchar — Foreign key → Untitled.Key — NOT NULL
  • Key (book_Category_Code) — varchar — Foreign key → Untitled.Key — NOT NULL