비트코스
테이블 (9)
BOARD (커뮤니티(게시판))
- post_id (Key) — NUMBER — 기본 키 — NOT NULL
- title (Field2) — VARCHAR(300)
- content (Field3) — CLOB
- view_count (Field4) — NUMBER (DE 0)
- created_at (Field5) — TIMESTAMP de Current_timestamp
- deleted_at (Field) — TIMESTAMP de Current_timestamp
- updated_at (Field6) — TIMESTAMP de Current_timestamp
BOARD_IMAGES (게시글당 첨부되는 이미지들)
- post_id (Key) — NUMBER — 외래 키 → BOARD.post_id — NOT NULL
- image_url (Field) — VARCHAR
- sort_order (Field2) — NUMBER
BOARD_LIKE (좋아요 관리)
- USER_ID (Key) — NUMBER — 외래 키 → USERS.USER_ID — NOT NULL
- post_id (Key2) — NUMBER — 외래 키 → BOARD.post_id — NOT NULL
- created_at (Field) — TIMESTAMP de Current_timestamp
FINANCIAL_ANNUAL (1종목당 10년(10개) 재무 데이터)
- id (Key) — NUMBER — 기본 키 — NOT NULL
- stock_id (Key2) — NUMBER — 외래 키 → STOCK_OF_USA.stock_id — NOT NULL
- fiscal_year (Field2) — NUMBER
- roe_pct (Field3) — NUMBER
- roic_pct (Field4) — NUMBER
- net_margin_pct (Field5) — NUMBER
- gross_margin_pct (Field6) — NUMBER
- debt_to_equity (Field7) — NUMBER
- interest_coverage (Field8) — NUMBER
- net_income_growth_pct (Field) — NUMBER
- net_income (Field9) — NUMBER
- eps (Field10) — NUMBER
- total_revenue (Field11) — NUMBER
- total_equity (Field12) — NUMBER
- total_liabilities (Field13) — NUMBER
- operating_income (Field14) — NUMBER
- interest_expense (Field15) — NUMBER
- gross_profit (Field16) — NUMBER
NOTIFICATION (알림)
- noti_id (Key) — NUMBER — 기본 키 — NOT NULL
- USER_ID (Key2) — NUMBER — 외래 키 → USERS.USER_ID — NOT NULL
- noti_type (Field) — VARCHAR
- message (Field2) — VARCHAR
- related_url (Field3) — VARCHAR
- is_read (Field4) — VARCHAR
- created_at (Field5) — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
STOCK_OF_USA (미국 주식 종목 정보)
- stock_id (Key) — NUMBER — 기본 키 — NOT NULL
- ticker (Field) — VARCHAR2(unique)
- company_name (Field2) — VARCHAR2
- exchange (Field3) — VARCHAR2
- industry (Field4) — VARCHAR2
- index_type (Field5) — VARCHAR2
- buffett_score (Field6) — NUMBER
- last_annual_update (Field7) — DATE
STOCK_PRICE (주가 정보)
- stock_id (Key) — NUMBER — 외래 키 → STOCK_OF_USA.stock_id — NOT NULL
- current_price (Field) — NUMBER
- pbr (Field3) — NUMBER
- per (Field4) — NUMBER
- earnings_yield (Field5) — NUMBER
TRADE (모의투자 거래 기록)
- trade_id (Key) — NUMBER — 기본 키 — NOT NULL
- USER_ID (Key2) — NUMBER — 외래 키 → USERS.USER_ID — NOT NULL
- ticker (Field2) — VARCHAR(20)
- position (Field3) — VARCHAR2(10)
- entry_price (Field4) — NUMBER
- exit_price (Field5) — NUMBER
- amount (Field6) — NUMBER
- leverage (Field7) — NUMBER(DEFAULT 1)
- liquidation_price (Field8) — NUMBER
- status (Field9) — VARCHAR(20)
- created_at (Field10) — TIMESTAMP(DE CURRENT_TIMESTAMP)
- opened_at (Field) — TIMESTAMP(DE CURRENT_TIMESTAMP)
- closed_at (Field11) — TIMESTAMP(DE CURRENT_TIMESTAMP)
USERS (카카오 전용 회원 관리(모의 투자용 잔고 포함))
- USER_ID (Key) — NUMBER — 기본 키 — NOT NULL
- kakao_id (Field) — NUMBER(unique)
- email (Field2) — VARCHAR2
- nickname (Field3) — VARCHAR2(unique)
- created_at (Field4) — DATE
- deleted_at (Field5) — DATE
- PROFILE_IMAGE (Field6) — VARCHAR2(500)
- cash_balance (Field7) — NUMBER(DEFAULT 100000000)
- last_reset_date (Field8) — DATE
- role (Field9) — VARCHAR2