2차 스프린트 ERD
테이블 (9)
coupon_purchase
- coupon_purchase_no — int — 기본 키 — NOT NULL
- student_id — varchar(20) — 외래 키 → students.student_id — NOT NULL
- coupon_no — int — 외래 키 → coupons.coupon_no — NOT NULL
- purchase_date — datetime — NOT NULL
- purchase_point — int — NOT NULL
- name — varchar(50) — NOT NULL
- purchase_state — varchar(10) — NOT NULL
coupons
- coupon_no — int — 기본 키 — NOT NULL
- name — varchar(300) — NOT NULL
- coupon_point — int — NOT NULL
get_point
- get_point_no — int — 기본 키 — NOT NULL
- student_id — varchar(20) — 외래 키 → students.student_id — NOT NULL
- get_point_content — varchar(255) — NOT NULL
- point — int — NOT NULL
- get_point_date — datetime — NOT NULL
news
- news_no — int — 기본 키 — NOT NULL
- news_content — varchar(300) — NOT NULL
orders
- order_no — int — 기본 키 — NOT NULL
- student_id — varchar(20) — 외래 키 → students.student_id — NOT NULL
- stock_no — int — 외래 키 → stocks.stock_no — NOT NULL
- order_content — varchar(10) — NOT NULL
- order_point — int — NOT NULL
- amount — smallint — NOT NULL
- order_state — varchar(10) — NOT NULL
- order_date — datetime — NOT NULL
stocks
- stock_no — int — 기본 키 — NOT NULL
- name — varchar(20) — NOT NULL
- stock_content — varchar(300) — NOT NULL
- publication_balance — smallint — NOT NULL
- publication_point — int — NOT NULL
- prev_point — int — NOT NULL
students
- student_id — varchar(20) — 기본 키 — NOT NULL
- password — varchar(100) — NOT NULL
- name — varchar(50) — NOT NULL
- grade — tinyint — NOT NULL
- class_name — varchar(20) — NOT NULL
- student_number — tinyint — NOT NULL
- register_year — date — NOT NULL
- total_coupon — tinyint — NOT NULL
- total_point — int — NOT NULL
trade
- trade_no — int — 기본 키 — NOT NULL
- buy_order_no — int — 외래 키 → orders.order_no — NOT NULL
- sell_order_no — int — 외래 키 → orders.order_no
- trade_date — datetime — NOT NULL
계정 (User)
- 유저넘버 (userno) — int — 기본 키 — NOT NULL
- 유저아이디 (userid) — varchar(20)
- 비밀번호 (password) — varchar(100)
- 권한 (role) — enum
- 가입날짜 (created)