TOPICK_DATACENTER

Tables (10)

AUTH (사이트접근 인증용)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • accessKey (Field4) — STRING
  • type (Field) — BOOLEAN
  • startDate (Field2) — DATE
  • endDate (Field3) — DATE
  • createdAt (Field5) — DATE
  • updatedAt (Field6) — DATE

COVERS (커버스픽)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • accessType (Field10) — STRING
  • match (Field) — JSON
  • time (Field4) — STRING
  • consensus (Field5) — JSON
  • sides (Field6) — JSON
  • picks (Field7) — JSON
  • createdAt (Field8) — DATE
  • updatedAt (Field9) — DATE

DIVGTR8_OVER (배당하락율 2.5언오버)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • accessType (Field15) — STRING
  • nation (Field) — JSON
  • time (Field11) — STRING
  • game (Field10) — STRING
  • home (Field2) — STRING
  • away (Field5) — STRING
  • over (Field7) — JSON
  • under (Field9) — JSON
  • ArrowType (Field14) — INTEGER
  • type (Field8) — STRING
  • drop (Field6) — FLOAT
  • createdAt (Field12) — DATE
  • updatedAt (Field13) — DATE

DIVGTR8_WINS (배당하락율 파이널)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • accessType (Field17) — STRING
  • nation (Field) — JSON
  • time (Field11) — STRING
  • game (Field10) — STRING
  • home (Field2) — STRING
  • away (Field5) — STRING
  • one (Field7) — INTEGER
  • thex (Field4) — JSON
  • two (Field15) — INTEGER
  • type (Field8) — STRING
  • ArrowType (Field14) — JSON
  • drop (Field6) — FLOAT
  • createdAt (Field12) — DATE
  • updatedAt (Field13) — DATE

LINEUP (라인업 테이블)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • accessType (Field12) — STRING
  • dvdnd (Field) — INTEGER
  • nation (Field2) — JSON
  • game (Field3) — STRING
  • home (Field4) — STRING
  • away (Field5) — STRING
  • O (Field8) — INTEGER
  • OO (Field9) — INTEGER
  • AO (Field10) — INTEGER
  • ArrowType (Field13) — JSON
  • matchimage (Field11) — JSON
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE
  • type (Field14) — INTEGER

LINEUP_FE (예상 라인업)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • LINEUPID (Key1) — INTEGER — Foreign key → LINEUP.id — NOT NULL
  • accessType (Field7) — STRING
  • type (Field) — BOOLEAN
  • number (Field4) — INTEGER
  • nation (Field2) — JSON
  • name (Field3) — STRING
  • rating (Field5) — STRING
  • gol (Field6) — INTGER

ODDSPORTAL (경기 데이터)

    PRCHSRATE_OVER (승무패 언오버 구매율)

    • id (Key) — INTEGER — Primary key — NOT NULL
    • accessType (Field8) — STRING
    • nation (Field) — JSON
    • time (Field2) — STRING
    • game (Field3) — STRING
    • U25 (Field4) — JSON
    • O25 (Field5) — JSON
    • vi (Field10) — FLOAT
    • vol (Field11) — FLOAT
    • createdAt (Field12) — DATE
    • updatedAt (Field13) — DATE

    PRCHSRATE_WINS (승무패 구매율)

    • id (Key) — INTEGER — Primary key — NOT NULL
    • accessType (Field14) — JSON
    • nation (Field) — JSON
    • time (Field2) — STRING
    • game (Field3) — STRING
    • one (Field4) — JSON
    • thex (Field5) — JSON
    • two (Field6) — JSON
    • vi (Field10) — STRING
    • vol (Field11) — STRING
    • createdAt (Field12) — DATE
    • updatedAt (Field13) — DATE

    TODATFACT (오늘의 팩트체크)

    • id (Key) — INTEGER — Primary key — NOT NULL
    • accessType (Field8) — STRING
    • game (Field) — TEXT
    • prediction (Field4) — JSON
    • content (Field6) — JSON
    • createdAt (Field5) — DATE
    • updatedAt (Field7) — DATE