superfantastic
Tables (8)
FinancialStatements (Untitled)
- TR (Field) — DOUBLE
- COGS (Field2) — DOUBLE
- GP (Field3) — DOUBLE
- SGNA (Field4) — DOUBLE
- RND (Field5) — DOUBLE
- AIAO (Field6) — DOUBLE
- DNA (Field7) — DOUBLE
- EBIT (Field8) — DOUBLE
- EBT (Field9) — DOUBLE
- CT (Field10) — DOUBLE
- NIAT (Field11) — DOUBLE
- NP (Field12) — DOUBLE
- EPS (Field13) — DOUBLE
- GPM (Field14) — DOUBLE
- OPM (Field15) — DOUBLE
- PTPM (Field16) — DOUBLE
- NPM (Field17) — DOUBLE
- EBITDA (Field18) — DOUBLE
- EBITDAM (Field19) — DOUBLE
- INV (Field20) — DOUBLE
- PE (Field21) — DOUBLE
- OCA (Field22) — DOUBLE
- CSTI (Field23) — DOUBLE
- TCA (Field24) — DOUBLE
- NPPE (Field25) — DOUBLE
- NIA (Field26) — DOUBLE
- LTI (Field27) — DOUBLE
- LTNR (Field28) — DOUBLE
- ONCA (Field29) — DOUBLE
- TNCA (Field30) — DOUBLE
- TA (Field31) — DOUBLE
- AP (Field32) — DOUBLE
- AE (Field33) — DOUBLE
- STB (Field34) — DOUBLE
- CPLTD (Field35) — DOUBLE
- OCL (Field36) — DOUBLE
- TCL (Field37) — DOUBLE
- LTD (Field38) — DOUBLE
- DTL (Field39) — DOUBLE
- OL (Field40) — DOUBLE
- TNCL (Field41) — DOUBLE
- TL (Field42) — DOUBLE
- TCSO (Field43) — DOUBLE
- APIC (Field44) — DOUBLE
- TS (Field45) — DOUBLE
- UGL (Field46) — DOUBLE
- TOE (Field47) — DOUBLE
- TE (Field48) — DOUBLE
- TCE (Field49) — DOUBLE
- TBVPS (Field50) — DOUBLE
- ND (Field51) — DOUBLE
- NCI (Field52) — DOUBLE
- D (Field53) — DOUBLE
- CWC (Field54) — DOUBLE
- OCF (Field55) — DOUBLE
- CAPEX (Field56) — DOUBLE
- OICFI (Field57) — DOUBLE
- DPR (Field58) — DOUBLE
- OFCFI (Field59) — DOUBLE
- FCF (Field60) — DOUBLE
- … +12
Indicator
- AwesomeOsi — FLOAT(20) — NOT NULL
- RSI — FLOAT(20) — NOT NULL
- StochasticOsi — FLOAT(20) — NOT NULL
- TrueStrength — FLOAT(20) — NOT NULL
- UltiOsi — FLOAT(20) — NOT NULL
- Williams (Willams) — FLOAT(20) — NOT NULL
- Commodity — FLOAT(20) — NOT NULL
- EMA20 — FLOAT(20) — NOT NULL
- MACD — FLOAT(20) — NOT NULL
- PSAR — FLOAT(20) — NOT NULL
- SMA20 — FLOAT(20) — NOT NULL
- TripleExp — FLOAT(20) — NOT NULL
- Accumulation — FLOAT(20) — NOT NULL
- ChaikinMon — FLOAT(20) — NOT NULL
- OnBalance — FLOAT(20) — NOT NULL
- PriceVol — FLOAT(20) — NOT NULL
- BBand — FLOAT(20) — NOT NULL
- Donchain — FLOAT(20) — NOT NULL
- Keltner — FLOAT(20) — NOT NULL
- Stock_code — CHAR(10) — Foreign key → Stock.Stock_code — NOT NULL
News (news)
- Title — CHAR(20) — Primary key — NOT NULL
- Date — DATE — NOT NULL
- Url — CHAR(50) — NOT NULL
- Stock_code — CHAR(10) — Foreign key → Stock.Stock_code — NOT NULL
Portfolios (Untitled2)
- UUID (Key) — BINARY(16) — Primary key — NOT NULL
- UID (UUID) — BIN(16) — Foreign key → User.UID — NOT NULL
- Name (Field2) — CHAR(20) — NOT NULL
- InvPeriod (Field) — INT(10) — NOT NULL
- RoR (Field3) — FLOAT(10) — NOT NULL
- SharpRatio (Field4) — FLOAT(10) — NOT NULL
- KellyRatio (Field5) — FLOAT(10) — NOT NULL
- MDD (Field6) — FLOAT(10) — NOT NULL
- Report (Field7) — BLOB — NOT NULL
- Returns (Field8) — FLOAT(10) — NOT NULL
- Weight (Field9) — JSON — NOT NULL
Price (price)
- Date — DATE — NOT NULL
- Open — INT(30)
- Close — INT(30)
- Volume — INT(60)
- High — INT(30)
- Low — INT(30)
- Stock_code — CHAR(10) — Foreign key → Stock.Stock_code — NOT NULL
Report (report)
- Title — CHAR(20) — Primary key — NOT NULL
- Publishing — CHAR(10) — NOT NULL
- Date — DATE — NOT NULL
- TargetPrice — INT(10)
- Opinion — CHAR(5)
- Stock_code — CHAR(10) — Foreign key → Stock.Stock_code — NOT NULL
Stock (stock)
- Stock_code — CHAR(10) — Primary key — NOT NULL
- Stock_name — CHAR(20) — NOT NULL
- Market — CHAR(6) — NOT NULL
- Sector — CHAR(20) — NOT NULL
User (user)
- UID (UUID) — BINARY(16) — Primary key — NOT NULL
- Email — CHAR(30) — NOT NULL
- PasswordHash — CHAR(60) — NOT NULL
- Stock_code — CHAR(10) — Foreign key → Stock.Stock_code — NOT NULL