stock

Tables (7)

BOARD_CATEGORY (Untitled)

  • CATEGORY_ID (Key) — NUMBER(20) — Primary key — NOT NULL
  • CATEGORY_NAME (Field) — VARCHAR(100)

COMMENTS (Untitled2)

  • COMMENT_D (Key) — NUMBER — Primary key — NOT NULL
  • POST_ID (Key2) — NUMBER — Foreign key → POST.POST_ID — NOT NULL
  • USERID (Key3) — VARCHAR2(50) — Foreign key → USERS.USERID — NOT NULL
  • CATEGORY_ID (Key32) — NUMBER(20) — Foreign key → POST.CATEGORY_ID — NOT NULL
  • STOCK_CODE (Key4) — VARCHAR2(20) — Foreign key → POST.STOCK_CODE — NOT NULL
  • CONTENT (Field3) — VARCHAR2(1000)
  • CREATED_AT (Field4) — DATE

POST (Untitled3)

  • POST_ID (Key) — NUMBER — Primary key — NOT NULL
  • USERID (Key2) — VARCHAR2(50) — Foreign key → USERS.USERID — NOT NULL
  • CATEGORY_ID (Key3) — NUMBER(20) — Foreign key → BOARD_CATEGORY.CATEGORY_ID — NOT NULL
  • STOCK_CODE (Key4) — VARCHAR2(20) — Foreign key → STOCK.STOCK_CODE — NOT NULL
  • TITLE (Field4) — VARCHAR2(200)
  • CONTENT (Field5) — CLOB
  • CREATED_AT (Field6) — DATE
  • UPDATED_AT (Field7) — DATE
  • VIEW_COUNT (Field8) — NUMBER

STOCK (Untitled4)

  • STOCK_CODE (Key) — VARCHAR2(20) — Primary key — NOT NULL
  • STOCK_NAME (Field) — VARCHAR2(100)

STOCK_PRICE_D (Untitled5)

  • STOCK_CODE (Key) — VARCHAR2(20) — Primary key — NOT NULL
  • PRICE_DATE (Key2) — DATE — Primary key — NOT NULL
  • STOCK_CODE (Key3) — VARCHAR2(20) — Foreign key → STOCK.STOCK_CODE — NOT NULL
  • OPEN_PRICE (Field) — NUMBER(12)
  • HIGH_PRICE (Field2) — NUMBER(12)
  • LOW_PRICE (Field3) — NUMBER(12)
  • CLOSE_PRICE (Field4) — NUMBER(12)
  • VOLUME (Field5) — NUMBER

TRADE_RECORD (Untitled6)

  • RECORD_ID (Key) — NUMBER — Primary key — NOT NULL
  • USERID (Key2) — VARCHAR2(50) — Foreign key → USERS.USERID — NOT NULL
  • STOCK_CODE (Key3) — VARCHAR2(20) — Foreign key → STOCK.STOCK_CODE — NOT NULL
  • TRADE_DATE (Field3) — DATE
  • TRADE_TYPE (Field4) — VARCHAR2(10)
  • QUANTITY (Field5) — NUMBER
  • PRICE (Field6) — NUMBER(12)
  • MEMO (Field7) — VARCHAR2(500)
  • CREATED_AT (Field8) — VARCHAR2
  • STOCK_NAME (Field9) — VARCHAR2(100)

USERS (Untitled7)

  • USERID (Key) — VARCHAR2(50) — Primary key — NOT NULL
  • PASSWORD (Field) — VARCHAR2(100)
  • NAME (Field2) — VARCHAR2(50)
  • ROLE (Field3) — VARCHAR2(20)
  • JOIN_DATE (Field4) — DATE