이커머스
테이블 (13)
ADMIN
- 관리자ID (ADMIN_ID) — VARCHAR2(30) — 기본 키 — NOT NULL
- 패스워드 (PASSWORD) — VARCHAR2(255) — NOT NULL
COUPON
- COUPON_CODE — VARCHAR2(50)
- QUANTITY — NUMBER
- COUPON_NAME — VARCHAR2(255)
- CREATED_DATE — DATE
- EXPIRY_DATE — DATE
LOGIN_HISTORY
- LOG_ID — NUMBER
- LOGIN_DATE — DATE — NOT NULL
- USER_ID — VARCHAR2(30) — NOT NULL
- USER_TYPE — VARCHAR2(20)
- 관리자ID (ADMIN_ID) — VARCHAR2(30) — 외래 키 → ADMIN.관리자ID — NOT NULL
MEMBER
- 회원ID (MEMBER_ID) — VARCHAR2(30) — 기본 키
- 패스워드 (PASSWORD) — VARCHAR2(255) — NOT NULL
- 이름 (NAME) — VARCHAR2(100) — NOT NULL
- 나이 (AGE) — NUMBER — NOT NULL
- 성별 (GENDER) — VARCHAR2(10)
- 연락처 (CONTACT) — VARCHAR2(20)
- 프로필이미지 (PROFILE_IMAGE) — VARCHAR2(255)
- 포인트 (POINTS) — NUMBER — NOT NULL
MEMBER_COUPON
- MEMBER_ID — VARCHAR2(30)
- COUPON_CODE — VARCHAR2(50)
- REGISTERED_DATE — DATE
- EXPIRY_DATE — DATE
ORDERS
- ORDER_ID — NUMBER
- MEMBER_ID — VARCHAR2(30)
- ORDER_DATE — DATE — NOT NULL
- TOTAL_AMOUNT — NUMBER — NOT NULL
- ORDER_STATUS — VARCHAR2(50)
- PAYMENT_STATUS — VARCHAR2(50)
ORDER_DETAIL
- DETAIL_ID — NUMBER
- ORDER_ID — NUMBER
- PRODUCT_ID — NUMBER
PAYMENT
- PAYMENT_ID — NUMBER
- PAYMENT_DATE — DATE — NOT NULL
- ORDER_ID — NUMBER
- PAYMENT_STATUS — VARCHAR2(50)
POINT_HISTORY
- 포인트내역ID (POINT_HISTORY_ID) — NUMBER — 기본 키
- 구분 (USE_TYPE) — VARCHAR2(20)
- 금액 (AMOUNT) — NUMBER
- 잔여금액 (REMAINING_BALANCE) — NUMBER
- 회원ID (MEMBER_ID2) — VARCHAR2(30) — 외래 키 → MEMBER.회원ID
PRODUCT
- PRODUCT_ID — NUMBER
- PRODUCT_NAME — VARCHAR2(255) — NOT NULL
- CATEGORY — VARCHAR2(100)
- PRICE — NUMBER — NOT NULL
- STOCK — NUMBER — NOT NULL
- PRODUCT_DESCRIPTION — VARCHAR2(4000)
- CREATED_DATE — DATE
- PRODUCT_IMAGE — VARCHAR2(255)
SHIPPING
- SHIPPING_ID — NUMBER
- ORDER_DETAIL_ID — NUMBER
- SHIPPING_STATUS — VARCHAR2(50)
- SHIPPING_DATE — DATE
coupon (Untitled2)
- coupon_id (Key) — 기본 키 — NOT NULL
member_coupon (Untitled)
- no (Key2) — 기본 키 — NOT NULL
- 회원ID (MEMBER_ID) — VARCHAR2(30) — 외래 키 → MEMBER.회원ID
- coupon_id (Key) — 외래 키 → coupon.coupon_id — NOT NULL