GPT TJ

Tables (6)

BOOK

  • materialId — VARCHAR(50) — Primary key — NOT NULL
  • bookName — VARCHAR(50)
  • subject — VARCHAR(40)
  • grade — INT
  • author — VARCHAR(40)
  • publicationDate — DATE
  • isbn — VARCHAR(13)
  • price — INT
  • pageCount — INT
  • series — INT
  • isTextbook — CHAR(1)
  • educationSystem — VARCHAR(255)

COUPON

  • couponID — VARCHAR(255) — Primary key — NOT NULL
  • coupons — INT — NOT NULL
  • issueDate — DATE — NOT NULL
  • expirationDate — DATE

COUPONS

  • couponID — VARCHAR(255) — Foreign key → COUPON.couponID — NOT NULL
  • memberId — VARCHAR(15) — Foreign key → MEMBER.id — NOT NULL
  • useOrNot — INT — NOT NULL

MEMBER

  • id — VARCHAR(15) — Primary key — NOT NULL
  • pw — VARCHAR(15) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • addr — VARCHAR(100)
  • phone — VARCHAR(11) — NOT NULL
  • email — VARCHAR(100)
  • birth — DATE
  • gender — CHAR(1)
  • userType — VARCHAR(10)
  • child — CHAR(1)
  • levelNum — INT — Foreign key → MEMBER_GRADE.levelNum — NOT NULL

MEMBER_GRADE

  • levelNum — INT — Primary key — NOT NULL
  • levelName — VARCHAR(20) — NOT NULL

ORDERS

  • orderId — INT — Primary key — NOT NULL
  • orderAmount — INT — NOT NULL
  • orderPay — INT — NOT NULL
  • orderDate — DATE — NOT NULL
  • orderStatus — INT
  • memberId — VARCHAR(15) — Foreign key → MEMBER.id — NOT NULL