비트코스

테이블 (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