소시개 최종

테이블 (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