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