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