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