ERD_이승현11

테이블 (8)

Authors (Untitled)

  • author_ID (PKey) — 기본 키 — NOT NULL
  • author_First_Name (afname)
  • author_Initials (alnitials)
  • author_Last_Nme (alname)
  • author_Date_of_Birth (abirth)
  • author_Gender_MFU (agender)
  • author_Contact_Details (acontant)
  • author_Other_Details (aother)

Book_Categories (Untitled6)

  • book_Category_Code (PKey) — 기본 키 — NOT NULL
  • book_Category_Description (bcdescription)

Books (Untitled3)

  • book_ID (PKey) — 기본 키 — NOT NULL
  • ISBN
  • date_of_Publication (date)
  • date_Acquired (Date)
  • book_Title (tiele)
  • book_Recommended_Price (rpice)
  • book_Comments (comments)
  • author_ID (FKey)
  • book_Category_Code2 (fkey)

Contacts (Untitled8)

  • contact_ID (PKey) — 기본 키 — NOT NULL
  • Contact_Type_Code (FKey)
  • Contact__FirstName (cfname)
  • Contact_LastName (clname)
  • Contact_WorkPhonenumber (cwphone)
  • Contact_CellPhonenumber (ccphone)
  • Contact_OtherDetails (cother)

Customers (Untitled2)

  • customer_ID (PKey) — 기본 키 — NOT NULL
  • customer_Code (cuscode)
  • customer_Name (cusname)
  • customer_Address (cusaddress)
  • customer_Phone (cusphone)
  • custormer_Email (cusemail)

Order_Items (Untitled5)

  • item_Number (PKey) — 기본 키 — NOT NULL
  • item_Agreed_Price (iprice)
  • book_ID (FKey)
  • item_Comment (icomment)
  • order_ID (fKey)

Orders (Untitled4)

  • oder_ID (PKey) — 기본 키 — NOT NULL
  • customer_ID (FKey)
  • oder_Date (date)
  • order_Value (value)

Ref_Contact_Types (Untitled7)

  • Contact_Type_Code (Pkey) — 기본 키 — NOT NULL
  • contact_Type_Description (ctdescription)