정민 JSP 테이블
테이블 (6)
BOARD_CATEGORY (Untitled2)
- category_id — NUMBER — 기본 키 — NOT NULL
- category_name — VARCHAR2(100)
COMMENTS (Untitled4)
- comment_id — NUMBER — 기본 키 — NOT NULL
- post_id (Key) — NUMBER — 외래 키 → POST.post_id — NOT NULL
- user_id — VARCHAR2(30) — 외래 키 → USERS.user_id
- content — VARCHAR2(1000)
- create_at — DATE
POST (Untitled3)
- post_id (Key) — NUMBER — 기본 키 — NOT NULL
- user_id — VARCHAR2(30) — 외래 키 → USERS.user_id
- category_id — NUMBER — 외래 키 → BOARD_CATEGORY.category_id — NOT NULL
- stock_code — VARCHAR2(20) — 외래 키 → STOCK.stock_code — NOT NULL
- title — VARCHAR2(200)
- content — CLOB
- create_at — DATE
- view_count — NUMBER
STOCK (Untitled)
- stock_code — VARCHAR2(20) — 기본 키 — NOT NULL
- stock_name — VARCHAR2(100)
- last_price — NUMBER(12,2)
- last_updated — DATE
TRADE_RECORD (Untitled5)
- record_id — NUMBER — 기본 키 — NOT NULL
- user_id — VARCHAR2(30) — 외래 키 → USERS.user_id
- stock_code — VARCHAR2(20) — 외래 키 → STOCK.stock_code — NOT NULL
- trade_date — DATE
- trade_type — VARCHAR2(10)
- quantity — NUMBER
- pricep (price) — NUMBER
- memo — VARCHAR2(500)
USERS (CopyOfSchedule)
- user_id — VARCHAR2(30) — 기본 키
- username — VARCHAR2(50)
- password — VARCHAR2(100) — NOT NULL
- name — VARCHAR2(50)
- email — VARCHAR2(100)
- role — VARCHAR2(20) — NOT NULL
- reg_date — DATE — NOT NULL