stockGame_regacy

Tables (8)

COUPONS

  • coupon_no — number(10) — Primary key — NOT NULL
  • name — varchar2(50) — NOT NULL
  • price — number(10) — NOT NULL

COUPON_PURCHASE

  • coupon_purchase_no — number(10) — Primary key — NOT NULL
  • purchase_date — date — NOT NULL
  • price — number(10) — NOT NULL
  • name — varchar2(50) — NOT NULL
  • state — number(1) — NOT NULL
  • student_id — varchar2(20) — Foreign key → STUDENTS.student_id — NOT NULL
  • coupon_no — number(10) — Foreign key → COUPONS.coupon_no — NOT NULL

GET_POINT

  • get_point_no — number(10) — Primary key — NOT NULL
  • content — varchar2(50) — NOT NULL
  • point — number(20) — NOT NULL
  • get_date — DATE — NOT NULL
  • student_id — varchar2(20) — Foreign key → STUDENTS.student_id — NOT NULL

NEWS

  • news_no — number(10) — Primary key — NOT NULL
  • content — varchar2(1000) — NOT NULL

ORDERS

  • order_no — number(10) — Primary key — NOT NULL
  • content — varchar2(20) — NOT NULL
  • price — number(10) — NOT NULL
  • amount — number(3) — NOT NULL
  • state — varchar2(20) — NOT NULL
  • order_date — date — NOT NULL
  • student_id — varchar2(20) — Foreign key → STUDENTS.student_id — NOT NULL
  • stock_no — number(2) — Foreign key → STOCKS.stock_no — NOT NULL

STOCKS

  • stock_no — number(2) — Primary key — NOT NULL
  • name — varchar2(100) — NOT NULL
  • content — varchar2(500) — NOT NULL
  • publication_balance — number(3) — NOT NULL
  • publication_price — number(10) — NOT NULL
  • prev_price — number(10) — NOT NULL

STUDENTS

  • student_id — varchar2(20) — Primary key — NOT NULL
  • password — varchar2(50) — NOT NULL
  • name — varchar2(50) — NOT NULL
  • grade — number(1) — NOT NULL
  • class — varchar2(20) — NOT NULL
  • class_number — number(2) — NOT NULL
  • register_year — number(4) — NOT NULL
  • total_coupon — number(1) — NOT NULL
  • total_point — number(10) — NOT NULL

TRANSACTION

  • transaction_no — number(10) — Primary key — NOT NULL
  • transaction_date — date — NOT NULL
  • buy_order_no — number(10) — Foreign key → ORDERS.order_no — NOT NULL
  • sell_order_no — number(10)NULL — Foreign key → ORDERS.order_no