SHOPPING_DEMO
Tables (14)
BOOK
- NO — NUMBER(10) — Primary key — NOT NULL
- NAME — VARCHAR2(30) — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
BOOK_RETURN_LIST
- RETNAL_NO — NUMBER(10) — NOT NULL
- RENTAL_LIST_NO — NUMBER(10) — NOT NULL
BUCKET
- PROD_NAME — VARCHAR2(50)
- PROD_COUNT — NUMBER(3)
CUSTOMER
- Key — VARCHAR(255) — Primary key — NOT NULL
- NAME — VARCHAR2(30) — NOT NULL
- ADDR — VARCHAR2(200) — NOT NULL
DELIVERY
- INVOICE_NO — VARCHAR(255) — Primary key — NOT NULL
DELIVERY_ADDR
- DEL_NO — NUMBER(10) — Primary key — NOT NULL
- Field3 — VARCHAR(255)
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field4 — CHAR(1)
ORDER
- ORDER_NO — NUMBER(10) — Primary key — NOT NULL
- ORDER_STATUS — VARCHAR2(50)
- ORDER_TOTAL — NUMBER(10) — NOT NULL
- ORDER_MESSAGE — VARCHAR2(200)
- PAY_YN — CHAR(1)
ORDER_LIST
- ORDER_COUNT — NUMBER(10) — NOT NULL
- 이하생략 — VARCHAR(255)
PAYMENT
- PAY_NO — VARCHAR(2) — Primary key — NOT NULL
PRODUCT
- PROD_ID — NUMBER(10) — Primary key — NOT NULL
- ENDDATE — DATE
- PROD_NAME — VARCHAR2(200) — NOT NULL
- PROD_CONTENT — VARCHAR2(500) — NOT NULL
- PROD_DISCOUNT — NUMBER(3,2) — NOT NULL
- PROD_COUNT — NUMBER(3)
PRODUCT_IMG
- IMG_NO — NUMBER(10) — Primary key — NOT NULL
- PROD_PATH — VARCHAR2(100)
RENTAL
- RETNAL_NO — NUMBER(10) — Primary key — NOT NULL
- START_DATE — VARCHAR2(30) — NOT NULL
- END_DATE — VARCHAR(30) — NOT NULL
- Key — VARCHAR(255) — NOT NULL
RENTAL_LIST
- RENTAL_LIST_NO — NUMBER(10) — Primary key — NOT NULL
- RETNAL_NO — NUMBER(10) — NOT NULL
- NO2 — NUMBER(10) — NOT NULL
USERS
- USER_ID — VARCHAR2(50) — Primary key — NOT NULL
- USER_PHONE — VARCHAR2(50)
- USER_ADDR — VARCHAR2(200)