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