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