천재

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

Untitled

  • Key — 기본 키 — NOT NULL

WINNER

  • eventID — NUMBER(10) — 기본 키 — NOT NULL
  • reviewNO — NUMBER(10) — 기본 키 — NOT NULL