프로젝트 초안
테이블 (3)
상품 (Product)
- ProductNumber (num) — number(10) — 기본 키 — NOT NULL
- ProductName (pdname) — varchar2(20 char)
- Price (price) — number(7)
- Inventory (inventory) — number(5)
- Category (category) — varchar2(30 char)
- Status (status) — varchar2(20 char)
- Information (information) — varchar2(50 char)
주문 (Order)
- OrderNumber (num) — number(10) — 기본 키 — NOT NULL
- ID (id) — varchar2(20 char) — 외래 키 → 회원정보.ID — NOT NULL
- ProductNumber (num2) — number(10) — 외래 키 → 상품.ProductNumber — NOT NULL
- Name (name) — varchar2(15 char)
- PhoneNumber (phone) — number(11)
- Address (address) — varchar2(30 char)
- DelieveryState (state) — varchar2(20 char)
- OrderQuantity (quantity) — number(3)
- ProductName (pdname) — varchar2(20 char)
- Field
회원정보 (UserInformation)
- ID (id) — varchar2(20 char) — 기본 키 — NOT NULL
- PassWord (password) — varchar2(20 char)
- Name (name) — varchar2(15 char)
- PhoneNumber (phone) — number(11)
- BirthDate (birthdate) — date
- Gender (gender) — varchar2(15 char)
- Address (address) — varchar2(30 char)