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