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