210430
테이블 (4)
Copy Of Untitled (CopyOfEC_Basket)
- Field (Order_No) — VARCHAR2(10) — 기본 키
- Field (Order_QTY) — NUMBER(3) — NOT NULL
- Field (Order_date) — DATE
- Field
Untitled (EC_Member)
- Field (UserID) — VARCHAR2(10) — 기본 키 — NOT NULL
- Field (Passwd) — VARCHAR2(10) — NOT NULL
- Field (Name) — VARCHAR2(10) — NOT NULL
- Field (Regist_No) — VARCHAR2(14) — NOT NULL
- Field (Email) — VARCHAR2(20)
- Field (Telephone) — VARCHAR2(12) — NOT NULL
- Field (Address) — VARCHAR2(40)
- Field (Timestamp) — DATE
Untitled (EC_Basket)
- Field (Order_No) — VARCHAR2(10) — 기본 키
- Field (Order_ID) — VARCHAR2(10) — 외래 키 → Untitled.Field — NOT NULL
- 상품코드 (Product_Code) — VARCHAR2(10) — 외래 키 → 상품목록.상품코드 — NOT NULL
- Field (Order_QTY) — NUMBER(3) — NOT NULL
- Field (Order_date) — DATE
상품목록 (EC_Product)
- 상품코드 (Product_Code) — VARCHAR2(10) — 기본 키 — NOT NULL
- 상품명 (Product_Name) — VARCHAR2(20) — NOT NULL
- Field (Standard) — VARCHAR2(20)
- Field (Unit) — VARCHAR2(10)
- Field (Unit_Price) — NUMBER(7) — NOT NULL
- Field (Left_QTY) — NUMBER(5)
- Field (Company) — VARCHAR2(20)
- Field (ImageName) — VARCHAR2(20)
- Field (Info) — VARCHAR2(80)
- Field (Detail_Info) — VARCHAR2(255)