소시개 최종
테이블 (11)
AUCTION
- ITEM_ID — NUMBER(10,0) — 외래 키 — NOT NULL
- BUYER_ID — NUMBER(10,0) — NOT NULL
- CONDITION — VARCHAR2(255 CHAR) — NOT NULL
- CONTACT_TYPE — VARCHAR2(255 CHAR) — NOT NULL
- CURRENT_BID — NUMBER(10,0) — NOT NULL
- END_TIME — TIMESTAMP — NOT NULL
- IMAGE — VARCHAR2(255 CHAR)
- START_PRICE — NUMBER(10,0) — NOT NULL
- START_TIME — TIMESTAMP
- FILE_NAME — VARCHAR2(255 CHAR)
- FILE_PATH — VARCHAR2(255 CHAR)
- WINNER — NUMBER(19,0)
BID
- BID_ID — NUMBER(10,0) — 기본 키 — NOT NULL
- AMOUNT — NUMBER(10,0) — NOT NULL
- BID_TIME — TIMESTAMP
- WINNER — NUMBER(10,0)
- ITEM_ID — NUMBER(10,0) — NOT NULL
- USER_ID — NUMBER(19,0) — 외래 키 → USER_INFO.USER_ID — NOT NULL
CATEGORY
- CAT_ID — NUMBER(10,0) — 기본 키 — NOT NULL
- CAT_NAME — VARCHAR2(255 CHAR) — NOT NULL
GROUPPURCHASE
- ITEM_ID — NUMBER(10,0) — 외래 키 — NOT NULL
- BUYER_ID — NUMBER(10,0)
- DISC_RATE — FLOAT(53)
- END_TIME — TIMESTAMP — NOT NULL
- MIN_QUANTITY — NUMBER(10,0) — NOT NULL
- START_TIME — TIMESTAMP — NOT NULL
- TOTAL_QUANTITY — NUMBER(10,0)
- FILE_NAME — VARCHAR2(255 CHAR)
- FILE_PATH — VARCHAR2(255 CHAR)
- ORIGINAL_PRICE — NUMBER(10,0)
ITEMINFO
- ITEM_ID — NUMBER(10,0) — 기본 키 — NOT NULL
- TYPE — VARCHAR2(31 CHAR) — NOT NULL
- DESCRIPTION — VARCHAR2(255 CHAR) — NOT NULL
- ITEM_NAME — VARCHAR2(255 CHAR) — NOT NULL
- PRICE — NUMBER(10,0) — NOT NULL
- STATUS — VARCHAR2(255 CHAR)
- USER_ID2 — NUMBER(19,0) — 외래 키 → USER_INFO.USER_ID
- CAT_ID — NUMBER(10,0) — 외래 키 → CATEGORY.CAT_ID — NOT NULL
- USER_ID — NUMBER(19,0) — 외래 키 → USER_INFO.USER_ID — NOT NULL
ORDERITEM
- LINE_NUM — NUMBER(10,0) — 기본 키 — NOT NULL
- ORDER_ID — VARCHAR2(255 CHAR) — 외래 키 — NOT NULL
- AMOUNT — NUMBER(10,0) — NOT NULL
- ORDER_PRICE — NUMBER(10,0) — NOT NULL
- STATUS — VARCHAR2(255 CHAR) — NOT NULL
- ITEM_ID — NUMBER(10,0) — 외래 키 → ITEMINFO.ITEM_ID — NOT NULL
- CHECK — (status in ('Complete','Cancel'))
ORDERS
- ORDER_ID — VARCHAR2(255 CHAR) — 기본 키 — NOT NULL
- BUYER_ID — NUMBER(10,0) — NOT NULL
- BUYER_NAME — VARCHAR2(255 CHAR) — NOT NULL
- PHONE_NUM — VARCHAR2(255 CHAR) — NOT NULL
- ADD_DETAIL — VARCHAR2(255 CHAR) — NOT NULL
- ADD_STREET — VARCHAR2(255 CHAR) — NOT NULL
- DELIVERY_LOCATION — VARCHAR2(255 CHAR)
- DELIVERY_REQUEST — VARCHAR2(255 CHAR)
- ZIP_CODE — VARCHAR2(255 CHAR) — NOT NULL
- EMAIL — VARCHAR2(255 CHAR) — NOT NULL
- INVOICE_NUMBER — NUMBER(10,0) — NOT NULL
- ORDER_DATE — TIMESTAMP — NOT NULL
- PAY_METHOD — VARCHAR2(255 CHAR) — NOT NULL
- PG — VARCHAR2(255 CHAR) — NOT NULL
- PRICE — NUMBER(10,0) — NOT NULL
- QUANTITY — NUMBER(10,0) — NOT NULL
- STATUS — VARCHAR2(255 CHAR) — NOT NULL
- TYPE — VARCHAR2(255 CHAR)
- CHECK — (status in ('Complete','Cancel'))
REVIEW
- REIVEW_ID — NUMBER(10,0) — 기본 키 — NOT NULL
- ITEM_ID — NUMBER(10,0) — NOT NULL
- PROMISE — FLOAT(53)
- REVIEWER_ID — NUMBER(10,0) — NOT NULL
- SATISFACTION_RATE — FLOAT(53)
- SPEED_OF_ANSWER — FLOAT(53)
- USER_ID — NUMBER(10,0) — NOT NULL
USEDGOODS
- ITEM_ID — NUMBER(10,0) — 외래 키 — NOT NULL
- BUYER_ID — NUMBER(10,0)
- CONDITION — VARCHAR2(255 CHAR) — NOT NULL
- CONTACT_TYPE — VARCHAR2(255 CHAR) — NOT NULL
- REGISTER_DATE — TIMESTAMP
- TRANSACTION_DATE — TIMESTAMP
- FILE_NAME — VARCHAR2(255 CHAR)
- FILE_PATH — VARCHAR2(255 CHAR)
USER_INFO
- USER_ID — NUMBER(19,0) — 기본 키 — NOT NULL
- ADD_DETAIL — VARCHAR2(255 CHAR)
- ADD_STREET — VARCHAR2(255 CHAR)
- EMAIL — VARCHAR2(255 CHAR) — NOT NULL
- NAME — VARCHAR2(255 CHAR) — NOT NULL
- NICKNAME — VARCHAR2(255 CHAR) — NOT NULL
- PASSWORD — VARCHAR2(255 CHAR) — NOT NULL
- PHONE_NUM — VARCHAR2(255 CHAR) — NOT NULL
- ZIPCODE — NUMBER(10,0) — NOT NULL
- REFRESH_TOKEN — VARCHAR2(1000 CHAR)
WISHLIST
- USER_ID — NUMBER(*,0)
- ITEM_ID — NUMBER(*,0)
- ITEM_TYPE — VARCHAR2(50 BYTE)
- ID — NUMBER(19,0) — NOT NULL