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)