ㅇ
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)