천재
테이블 (15)
BOOK
- materialId — NUMBER(10) — 기본 키 — NOT NULL
- bookName — VARCHAR2(50) — NOT NULL
- subject — VARCHAR2(40) — NOT NULL
- grade — NUMBER(2) — NOT NULL
- author — VARCHAR2(40) — NOT NULL
- publicationDate — DATE — NOT NULL
- isbn — VARCHAR2(13)
- price — NUMBER(10) — NOT NULL
- pageCount — NUMBER(5) — NOT NULL
- series — NUMBER(1) — 0(단행본), 1(시리즈)
- isTextbook — NUMBER(1) — 0(일반서), 1(교재)
- educationSystem — VARCHAR2(255) — NOT NULL
COUPON
- couponID — VARCHAR2(50) — 기본 키 — NOT NULL
- couponAmount — NUMBER — NOT NULL
- issueDate — DATE — NOT NULL
- expirationDate — DATE — NOT NULL
COUPONS
- cGroupNO — NUMBER — 기본 키 — NOT NULL
- useOrNot — NUMBER(1) — 0(미사용), 1(사용)
- couponID — VARCHAR2(50) — NOT NULL
- id — VARCHAR2(15) — NOT NULL
- orderId — NUMBER(13)
CopyOfPAYMENTS
- salesId — NUMBER — 기본 키 — NOT NULL
- salesAmount — NUMBER(10)
- salesDate — DATE
EVENT
- eventID — NUMBER(10) — 기본 키 — NOT NULL
- eventName — VARCHAR2(100) — NOT NULL
- eventDetails — VARCHAR2(500) — NOT NULL
- startDate — DATE — NOT NULL
- endDate — DATE — NOT NULL
LOGIN
- id — VARCHAR2(15) — 기본 키 — NOT NULL
- pw — VARCHAR2(15) — NOT NULL
LOGIN_USER
- id — VARCHAR2(15) — 기본 키 — NOT NULL
- inDate — DATE
- outDate — DATE
- isLogin — NUMBER(1) — 0(로그아웃), 1(로그인)
MEMBER
- id — VARCHAR2(15) — 기본 키 — NOT NULL
- pw — VARCHAR2(15) — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- addr — VARCHAR2(100)
- phone — VARCHAR2(11) — NOT NULL
- email — VARCHAR2(100)
- birth — DATE
- gender — NUMBER(1) — 0(남), 1(여)
- userType — VARCHAR2(10)
- child — CHAR(1)
- levelNum — NUMBER(3) — 1(Silver), 2(Gold), 3(VIP)
- levelNum (levelNum2) — NUMBER(3) — 외래 키 → MEMBER_GRADE.levelNum — NOT NULL
MEMBER_GRADE
- levelNum — NUMBER(3) — 기본 키 — NOT NULL
- levelName — VARCHAR2(20) — NOT NULL
ORDERS
- orderNo — NUMBER(13) — 기본 키 — NOT NULL
- orderAmount — NUMBER(3) — NOT NULL
- orderPay — NUMBER(15) — NOT NULL
- orderDate — DATE — NOT NULL
- orderStatus — NUMBER(1) — 0(미처리), 1(처리완료)
- materialId — NUMBER(10) — NOT NULL
- id — VARCHAR2(15) — NOT NULL
ORDER_DETAIL
- orderNo — NUMBER(13) — 기본 키 — NOT NULL
- amount — NUMBER — NOT NULL
PAYMENTS
- paymentId — VARCHAR2(15) — 기본 키 — NOT NULL
- orderNo — NUMBER(13) — NOT NULL
- paymentAmount — NUMBER(10)
- orderDate — DATE — NOT NULL
REVIEW
- reviewNO — NUMBER(10) — 기본 키 — NOT NULL
- writeDate — DATE — NOT NULL
- content — VARCHAR2(500) — NOT NULL
- id — VARCHAR2(15) — NOT NULL
- materialId — NUMBER(10) — NOT NULL
WINNER
- eventID — NUMBER(10) — 기본 키 — NOT NULL
- reviewNO — NUMBER(10) — 기본 키 — NOT NULL