address

테이블 (11)

Untitled (kosdaq)

  • Key (ranking) — number — 기본 키 — NOT NULL
  • Field (company) — varchar2(200)
  • Field — number
  • Field2 (market) — number

Untitled (Authors_sj)

  • Key (auther_id) — varchar(20) — 기본 키 — NOT NULL
  • Field (auther_First_Name) — varchar(20)
  • Field (auther_lnitals) — varchar(20)
  • Field (auther_Last_Name) — varchar(20)
  • Field (auther_Date_of_Birth) — number
  • Field (auther_Gender_MFU) — varchar(2)
  • Field (auther_Contact_details) — varchar(50)
  • Field (auther_Other_Details) — varchar(50)

Untitled (Customers_sj)

  • Key (Customers_ID) — varchar(20) — 기본 키 — NOT NULL
  • Field (Customers_Code) — varchar(20)
  • Field (Customers_Name) — varchar(20)
  • Field (Customers_Address) — varchar(50)
  • Field (Customers_Phone) — number
  • Field (Customers_Email) — varchar(50)

Untitled (Orders_sj)

  • Key (order_id) — varchar(20) — 기본 키 — NOT NULL
  • Key (Customers_ID) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (order_Date) — date
  • Field3 (order_Value) — varchar(100)

Untitled (Order_items_sj)

  • Key (item_Number) — number — 기본 키 — NOT NULL
  • Key (order_id) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (book_ID) — varchar(50) — 외래 키 → Untitled.Key — NOT NULL
  • Field (item_Agrred_Price) — number
  • Field (item_Comment) — varchar(50)

Untitled (Books_sj)

  • Key (book_ID) — varchar(50) — 기본 키 — NOT NULL
  • Key (auther_id) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (Book_Cathgorie_Code) — varchar(100) — 외래 키 → Untitled.Key — NOT NULL
  • Field (ISBN) — varchar(50)
  • Field (date_of_publication) — varchar(50)
  • Field (date_of_Acquired) — varchar(50)
  • Field (book_Title) — varchar(50)
  • Field (book_Recommended_Price) — number
  • Field (book_Comments) — varchar(50)

Untitled (Contacts_sj)

  • Key (Contact_ID) — varchar(100) — 기본 키 — NOT NULL
  • Key (contact_Type_Code) — varchar(100) — 외래 키 → Untitled.Key — NOT NULL
  • Field (contact_FirstName) — varchar(100)
  • Field (contact_LastName) — varchar(100)
  • Field (contact_WorkPhonenumber) — number
  • Field (contact_CellPhonenumber) — number
  • Field (contact_OtherDetails) — varchar(100)

Untitled (Ref_Contact_Types_sj)

  • Key (contact_Type_Code) — varchar(100) — 기본 키 — NOT NULL
  • Field (contact_Type_Despription) — varchar(100)

Untitled (Book_Cathgories_sj)

  • Key (Book_Cathgorie_Code) — varchar(100) — 기본 키 — NOT NULL
  • Field (Book_Cathgorie_Despription) — varchar(100)

주소 (address)

  • 아이디 (aid) — int — 기본 키 — NOT NULL
  • 이름 (aname) — varchar(20)

주소2 (add2)

  • 아이디 (addid) — int — 기본 키 — NOT NULL
  • 아이디 (aid) — int — 기본 키 — NOT NULL
  • 별명 (alias) — varchar(20)
  • 아이디 (aid2) — int — 외래 키 → 주소.아이디 — NOT NULL