커피 생두 쇼핑몰
테이블 (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