커피 생두 쇼핑몰

테이블 (10)

BUYER_INFO

  • ID — NUMBER — 외래 키 → MEMBER.ID
  • RANK — VARCHAR2(20)
  • COMPANY_NAME — VARCHAR2(40)
  • COMPANY_ADDR — VARCHAR2(100)
  • COMPANY_PHONE — VARCHAR2(30)

CART

  • CART_ID — NUMBER — 기본 키
  • ID — NUMBER — 외래 키 → MEMBER.ID
  • PRO_ID — NUMBER — 외래 키 → PRODUCT.PRO_ID

MEMBER

  • ID — NUMBER — 기본 키
  • PASSWORD — VARCHAR2(30) — NOT NULL
  • USERTYPE — VARCHAR2(20) — NOT NULL
  • 사업자) — )
  • NAME — VARCHAR2(20) — NOT NULL
  • NICKNAME — VARCHAR2(30) — NOT NULL
  • PHONE — VARCHAR2(30) — NOT NULL
  • ADDRESS — VARCHAR2(100) — NOT NULL
  • GENDER — VARCHAR2(10)
  • BIRTH — DATE
  • JOINDATE — DATE
  • EMAIL — VARCHAR2(100) — NOT NULL

MEMBER_OAUTH

  • MEMBER_ID — NUMBER — 외래 키 → MEMBER.ID
  • ID — NUMBER
  • OAUTH_RSERVER — VARCHAR2(20) — NOT NULL
  • OAUTH_USER_ID — VARCHAR2(200) — NOT NULL

ORDERLIST

  • ORDER_ID — NUMBER — 기본 키
  • ID (ID2) — NUMBER — 외래 키 → MEMBER.ID
  • PRO_ID — NUMBER — 외래 키 → PRODUCT.PRO_ID
  • ORDER_ADDRESS — VARCHAR2(100)
  • ORDER_DATE — DATE
  • ORDER_COUNT — NUMBER

PRODUCT

  • PRO_ID — NUMBER — 기본 키
  • PRO_NAME — VARCHAR2(100)
  • PRO_PRICE — NUMBER
  • PRO_IMG — VARCHAR2(200)
  • PRO_REGION — VARCHAR2(50)
  • PRO_COUNTRY — VARCHAR2(20)
  • PRO_DESCRIPTION — CLOB

comments

  • comID — number — 기본 키
  • qnaID — number — 외래 키 → qna.qnaID
  • qnaWriter — NUMBER — 외래 키 → qna.qnaWriter
  • comWriter — VARCHAR2(1000)
  • comContent — CLOB
  • comDate — DATE
  • comQnaid — number

notice

  • notID — NUMBER — 기본 키
  • notWriter — NUMBER — 외래 키 → MEMBER.ID
  • notTitle — VARCHAR2(2000)
  • notDate — DATE
  • notContent — CLOB

order_status

  • ORDER_DATE — DATE — 기본 키
  • ID — NUMBER — 외래 키 → MEMBER.ID
  • STATUS — VARCHAR2(30)

qna

  • qnaID — number — 기본 키
  • qnaWriter — NUMBER — 외래 키 → MEMBER.ID
  • qnaTitle — VARCHAR2(2000)
  • qnaDate — DATE
  • qnaContent — CLOB