testver
Tables (5)
ORDERS
- ORDER_ID — NUMBER(10) — Primary key — NOT NULL
- USER_NO — NUMBER(8) — NOT NULL
- ADDRESS_ID — NUMBER(8) — NOT NULL
- ORDER_DATE — DATE — NOT NULL
- TOTAL_AMOUNT — NUMBER(10) — NOT NULL
- STATUS — VARCHAR2(20) — NOT NULL
- PAYMENT_METHOD — VARCHAR2(20) — NOT NULL
ORDER_DETAIL
- DETAIL_ID — NUMBER(10) — Primary key — NOT NULL
- ORDER_ID — NUMBER(10) — NOT NULL
- PROD_ID — NUMBER(8) — NOT NULL
- QUANTITY — NUMBER(5) — NOT NULL
- PRICE — NUMBER(10) — NOT NULL
PRODUCT
- PROD_ID — NUMBER(8) — Primary key — NOT NULL
- NAME — VARCHAR2(300) — NOT NULL
- DESCRIPTION — VARCHAR2(3000)
- PRICE — NUMBER(10) — NOT NULL
USER_ADDRESS
- ADDRESS_ID — NUMBER(8) — Primary key — NOT NULL
- USER_NO — NUMBER(8) — NOT NULL
- ADDRESS — VARCHAR2(200) — NOT NULL
- MESSAGE — VARCHAR2(200)
- RECIPIENT_NAME — VARCHAR2(50) — NOT NULL
- RECIPIENT_PHONE — VARCHAR2(15) — NOT NULL
USER_INFO
- USER_NO — NUMBER(8) — Primary key — NOT NULL
- NAME — VARCHAR2(50) — NOT NULL
- PHONE_NUMBER — VARCHAR2(15) — NOT NULL