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)