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)