mission

테이블 (8)

Untitled (Authors)

  • Key (author_ID*) — varchar2 — 기본 키 — NOT NULL
  • Field (author_First_Name) — varchar2
  • Field (author_Initials) — varchar2
  • Field (author_Last_Name) — varchar2
  • Field (author_Date_of_Birth) — date
  • Field (author_Gender_MFU) — varchar2
  • Field (author_Contact_Details) — varchar2
  • Field (author_Other_Details) — varchar2

Untitled (Order_items)

  • Key (item_Number*) — number — 기본 키 — NOT NULL
  • Key (order_ID*) — varchar2 — 외래 키 → Untitled.Key — NOT NULL
  • 아이디 (book_ID*) — varchar2 — 외래 키 → 책.아이디 — NOT NULL
  • Field (item_Agreed_Price) — number
  • Field2 — varchar2

Untitled (Customers)

  • Key (customer_ID*) — varchar2 — 기본 키 — NOT NULL
  • Field (customer_Code) — varchar2
  • Field (customer_Name) — varchar2
  • Field (customer_Address) — varchar2
  • Field (customer_Phone) — varchar2
  • Field (customer_Email) — varchar2

Untitled (Rdf_Contact_Types)

  • Key (contact_Type_Code*) — varchar2 — 기본 키 — NOT NULL
  • Field (contact_Type_Description) — varchar2

Untitled (Contacts)

  • Key (contact_ID*) — varchar2 — 기본 키 — NOT NULL
  • Key (contact_Type_Code*) — varchar2 — 외래 키 → Untitled.Key — NOT NULL
  • Field (contact_FirstName) — varchar2
  • Field (contact_LastName) — varchar2
  • Field (contact_WorkPhonenumber) — varchar2
  • Field (contact_CellPhonenumber) — varchar2
  • Field (contact_OtherDetails) — varchar2

Untitled (Orders)

  • Key (order_ID*) — varchar2 — 기본 키 — NOT NULL
  • Key (customer_ID*) — varchar2 — 외래 키 → Untitled.Key — NOT NULL
  • Field (order_Date*) — date
  • Field (order_Value) — varchar2

Untitled2 (Book_Categories)

  • Key (book_Category_Code*) — varchar2 — 기본 키 — NOT NULL
  • Field (book_Category_Description) — varchar2

책 (Books)

  • 아이디 (book_ID*) — varchar2 — 기본 키 — NOT NULL
  • Key (author_ID*) — varchar2 — 외래 키 → Untitled.Key — NOT NULL
  • Key (book_Category_Code*) — varchar2 — 외래 키 → Untitled2.Key — NOT NULL
  • Field (date_of_Publication) — date
  • Field (date_Acquired) — date
  • Field (book_Title) — varchar2
  • Field (book_Recommended_Price) — number
  • Field (book_Comments) — varchar2
  • Field