정민 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