ㅇ

Tables (10)

Company_info

  • symbol — VARCHAR2(100)
  • name — VARCHAR2(100)
  • CIK — VARCHAR2(100)
  • Exchange — VARCHAR2(100)
  • Currency — VARCHAR2(100)
  • Country — VARCHAR2(100)
  • Sector — VARCHAR2(100)
  • Industry — VARCHAR2(100)
  • MarketCapitalization — NUMBER
  • EBITDA — NUMBER
  • PERatio — NUMBER
  • PEGRatio — NUMBER
  • BookValue — NUMBER
  • DividendPerShare — NUMBER
  • DividendYield — NUMBER
  • EPS — NUMBER
  • RevenuePerShareTTM — NUMBER
  • ProfitMargin — NUMBER
  • OperatingMarginTTM — NUMBER
  • ReturnOnAssetsTTM — NUMBER
  • ReturnOnEquityTTM — NUMBER
  • RevenueTTM — NUMBER
  • GrossProfitTTM — NUMBER
  • DilutedEPSTTM — NUMBER
  • QuarterlyEarningsGrowthYOY — NUMBER
  • QuarterlyRevenueGrowthYOY — NUMBER
  • AnalystTargetPrice — NUMBER
  • AnalystRatingStrongBuy — NUMBER
  • AnalystRatingBuy — NUMBER
  • AnalystRatingHold — NUMBER
  • AnalystRatingSell — NUMBER
  • AnalystRatingStrongSell — NUMBER
  • TrailingPE — NUMBER
  • ForwardPE — NUMBER
  • PriceToSalesRatioTTM — NUMBER
  • PriceToBookRatio — NUMBER
  • EVToRevenue — NUMBER
  • EVToEBITDA — NUMBER
  • Beta — NUMBER
  • FiftyTwoWeekHigh — NUMBER
  • FiftyTwoWeekLow — NUMBER
  • FiftyDayMovingAverage — NUMBER
  • TwoHundredDayMovingAverage — NUMBER
  • SharesOutstanding — NUMBER

STOCK_INFO

  • symbol — VARCHAR2(10)
  • company_name — VARCHAR2(100) — NOT NULL
  • type — VARCHAR2(20) — NOT NULL

board

  • board_idx — NUMBER(10)
  • title — VARCHAR2(400) — NOT NULL
  • write_date — DATE — NOT NULL
  • content — VARCHAR2(4000) — NOT NULL
  • view_count — NUMBER(10)
  • like_count — NUMBER(10)
  • content_file — VARCHAR2(400)
  • notice_code — VARCHAR2(20)
  • type — VARCHAR2(50) — NOT NULL
  • member_idx — NUMBER(10) — Foreign key → member.member_idx — NOT NULL
  • complain_category — VARCHAR2(40)

board_comment

  • comment_idx — NUMBER(10)
  • comment_content — VARCHAR2(2000) — NOT NULL
  • board_idx — NUMBER(10) — Foreign key → board.board_idx — NOT NULL
  • member_idx — NUMBER(10) — Foreign key → member.member_idx — NOT NULL
  • step — NUMBER(10)
  • comment_time — DATE

favorites

  • member_idx — NUMBER — Foreign key → member.member_idx — NOT NULL
  • symbol — VARCHAR2(10) — NOT NULL
  • type — VARCHAR2(10)
  • UNIQUE(member_idx, — symbol)

history

  • history_idx — NUMBER(10)
  • member_idx — NUMBER(10) — Foreign key → profile.member_info_idx — NOT NULL
  • board_idx — NUMBER(10)
  • history_type — VARCHAR2(50) — NOT NULL
  • action_type — VARCHAR2(50) — NOT NULL
  • changed_by — NUMBER(10) — NOT NULL
  • change_content — VARCHAR2(2000)
  • updated_at — VARCHAR2(50) — NOT NULL

member

  • member_idx — NUMBER(10)
  • member_name — VARCHAR2(50) — NOT NULL
  • member_id — VARCHAR2(50) — NOT NULL
  • password — VARCHAR2(70)
  • birth — NUMBER(10)
  • email — VARCHAR2(50) — NOT NULL
  • type — VARCHAR2(30) — NOT NULL

portfolio

  • portfolio_idx — NUMBER(10)
  • personal_tendency_code — VARCHAR2(50) — NOT NULL
  • member_idx — NUMBER(10) — Foreign key → member.member_idx — NOT NULL
  • title — VARCHAR2(50) — NOT NULL
  • create_at — VARCHAR2(50) — NOT NULL
  • deposit — NUMBER — NOT NULL
  • profit_Rate — NUMBER — NOT NULL

portfolio_info

  • portfolio_info_idx — NUMBER(10)
  • portfolio_idx — NUMBER(10) — Foreign key → portfolio.portfolio_idx — NOT NULL
  • stock_name — VARCHAR2(40) — NOT NULL
  • symbol — VARCHAR2(40) — NOT NULL
  • asset_type — VARCHAR2(40) — NOT NULL
  • price — NUMBER
  • amount — NUMBER

profile

  • member_info_idx — NUMBER(10)
  • member_idx — NUMBER(10) — Foreign key → member.member_idx — NOT NULL
  • member_name — VARCHAR2(20)
  • role — VARCHAR2(20) — NOT NULL
  • created_at — VARCHAR2(30) — NOT NULL
  • is_active — CHAR(1) — NOT NULL
  • birth — NUMBER(10)
  • personal_tendency_code — VARCHAR2(50)