dash

Tables (31)

Chart (CopyOfchart)

  • id (Key) — number — Primary key — NOT NULL
  • team-id (Key3) — number — Foreign key → Team.id — NOT NULL
  • title (Field) — string
  • x-axis (Field2) — string
  • dateSliceFrom (Field5) — string
  • dateSliceTo (Field6) — string
  • compareTo (Field7) — string
  • playersId (Field8) — string
  • createdAt (Field9) — Date
  • updatedAt (Field10) — Date
  • chartType (Field3) — string

REPORT_CHART (Untitled2)

  • report-id (Key) — number — Foreign key → Report.id — NOT NULL
  • chart-id (Key3) — number — Foreign key → Chart.id — NOT NULL
  • order (Field) — number

Report (CopyOfreport)

  • id (Key) — number — Primary key — NOT NULL
  • team-id (Key2) — number — Foreign key → Team.id — NOT NULL
  • title (Field) — string
  • createdAt (Field3) — Date
  • updatedAt (Field4) — Date
  • memo (Field2) — string
  • numbers (Field5) — number

Team (CopyOfTeam)

  • id (Key) — number — Primary key — NOT NULL
  • name (Field) — string
  • plan (Field2) — enum
  • members (Field3) — number
  • sport (Field4) — number
  • units (Field5) — string
  • createdAt (Field6) — Date
  • updatedAt (Field7) — Date

Team

  • id (Key) — number — Primary key — NOT NULL
  • name (Field) — string
  • plan (Field2) — enum
  • members (Field3) — number
  • sport (Field4) — number
  • units (Field5) — string
  • createdAt (Field6) — Date
  • updatedAt (Field7) — Date

auto record (auto-record)

  • id (Key) — number — Primary key — NOT NULL
  • player device figure id (Key2) — number — Foreign key → player device figure.id — NOT NULL
  • team id (Key3) — number — Foreign key → Team.id — NOT NULL
  • player id (Key4) — number — Foreign key → player.id — NOT NULL
  • id (Key5) — number — Foreign key → device-figures.id — NOT NULL
  • id (Key22) — number — Foreign key → device-figures.id — NOT NULL
  • attribute (Field) — string
  • figureName (Field2) — string
  • moduleName (Field3) — string
  • time (Field4) — Date
  • value (Field5) — number

auto record (CopyOfCopyOfself-record2)

  • id (Key) — number — Primary key — NOT NULL
  • player-id (Key2) — number — Foreign key → player.id — NOT NULL
  • figure-id (Key3) — number — Foreign key → auto record figure.id — NOT NULL
  • value (Field) — number
  • createdAt (Field2) — Date
  • updatedAt (Field3) — Date

auto record figure (CopyOfCopyOfself-record-figures)

  • id (Key) — number — Primary key — NOT NULL
  • group-id (Key2) — number — Foreign key → auto record group.id — NOT NULL
  • figureName (Field) — string
  • digit (Field2) — number
  • unit (Field3) — string
  • createdAt (Field4) — Date
  • updatedAt (Field5) — Date

auto record figure - player (CopyOfUntitled)

  • figure-id (Key) — number — Foreign key → auto record figure.id — NOT NULL
  • player-id (Key2) — number — Foreign key → player.id — NOT NULL
  • isActive (Field2) — string

auto record group (CopyOfauto-record-figure-group)

  • id (Key) — number — Primary key — NOT NULL
  • team-id (Key2) — number — Foreign key → Team.id — NOT NULL
  • groupName (Field) — string
  • createdAt (Field2) — Date
  • updatedAt (Field3) — Date

auto record group - player (Untitled)

  • group-id (Key) — number — Foreign key → auto record group.id — NOT NULL
  • player-id (Key3) — number — Foreign key → player.id — NOT NULL
  • access-token (Field) — string
  • refresh-token (Field2) — string

char figures (chart_figures)

  • id (Key) — number — Primary key — NOT NULL
  • chart id (Key2) — number — Foreign key → chart.id — NOT NULL
  • order (Field3) — number
  • createdAt (Field4) — Date
  • updatedAt (Field5) — Date
  • selfRecordId (Field) — number
  • autoRecordId (Field2) — number

chart

  • id (Key) — number — Primary key — NOT NULL
  • report id (Key2) — number — Foreign key → report.id — NOT NULL
  • title (Field) — string
  • x-axis (Field2) — string
  • dateSliceFrom (Field5) — string
  • dateSliceTo (Field6) — string
  • compareTo (Field7) — string
  • playersId (Field8) — string
  • createdAt (Field9) — Date
  • updatedAt (Field10) — Date
  • chartType (Field3) — string

chart-figure (CopyOfchart_figures)

  • id (Key) — number — Primary key — NOT NULL
  • chart-id (Key2) — number — Foreign key → Chart.id — NOT NULL
  • order (Field3) — number
  • createdAt (Field4) — Date
  • updatedAt (Field5) — Date
  • selfRecordId (Field) — number
  • autoRecordId (Field2) — number

coach

  • id (Key) — number — Primary key — NOT NULL
  • team id (Key3) — number — Foreign key → Team.id — NOT NULL
  • level (Field) — string
  • status (Field2) — boolean
  • createdAt (Field3) — Date
  • updatedAt (Field4) — Date
  • user id (Key2) — number — Foreign key → user.id — NOT NULL

coach (CopyOfcoach)

  • id (Key) — number — Primary key — NOT NULL
  • team-id (Key2) — number — Foreign key → Team.id — NOT NULL
  • level (Field) — string
  • status (Field2) — boolean
  • email (Field5) — string
  • password (Field6) — string
  • name (Field7) — string
  • privacyPolicy (Field9) — boolean
  • termsOfService (Field10) — boolean
  • refreshToken (Field11) — boolean
  • createdAt (Field3) — Date
  • updatedAt (Field4) — Date

device

  • id (Key) — number — Primary key — NOT NULL
  • name (Field) — string
  • isActive (Field2) — boolean
  • type (Field3) — enum
  • createdAt (Field4) — Date
  • updatedAt (Field5) — Date

device-figures

  • id (Key) — number — Primary key — NOT NULL
  • id (Key2) — number — Foreign key → device.id — NOT NULL
  • type (Field) — string
  • createAt (Field2) — Date
  • updatedAt (Field3) — Date

figure-setting

  • id (Key) — number — Primary key — NOT NULL
  • id (Key2) — number — Foreign key → device.id — NOT NULL
  • name (Field) — string
  • deviceName (Field2) — string
  • isActive (Field3) — boolean
  • createdAt (Field4) — Date
  • updatedAt (Field5) — Date

player (CopyOfplayer)

  • id (Key) — number — Primary key — NOT NULL
  • team-id (Key2) — number — Foreign key → Team.id — NOT NULL
  • photo (Field) — string
  • unit (Field2) — string
  • position (Field3) — string
  • status (Field4) — boolean
  • teamUnit (Field5) — string
  • number (Field6) — number
  • phoneNumber (Field7) — string
  • birth (Field8) — Date
  • memo (Field9) — string
  • email (Field12) — string
  • password (Field13) — string
  • name (Field14) — string
  • pravacyPolicy (Field16) — boolean
  • termsPolicy (Field17) — boolean
  • refreshToken (Field18) — boolean
  • createdAt (Field10) — Date
  • updatedAt (Field11) — Date

player

  • id (Key) — number — Primary key — NOT NULL
  • team id (Key3) — number — Foreign key → Team.id — NOT NULL
  • photo (Field) — string
  • unit (Field2) — string
  • position (Field3) — string
  • status (Field4) — boolean
  • teamUnit (Field5) — string
  • number (Field6) — number
  • phoneNumber (Field7) — string
  • birth (Field8) — Date
  • memo (Field9) — string
  • createdAt (Field10) — Date
  • updatedAt (Field11) — Date
  • user id (Key2) — number — Foreign key → user.id — NOT NULL

player device figure (player-device-figure)

  • id (Key) — number — Primary key — NOT NULL
  • team id (Key2) — number — Foreign key → Team.id — NOT NULL
  • player device id (Key3) — number — Foreign key → player-device.id — NOT NULL
  • name (Field) — string
  • isAgree (Field2) — boolean
  • createdAt (Field3) — Date
  • updatedAt (Field4) — Date

player-device

  • id (Key) — number — Primary key — NOT NULL
  • player id (Key3) — number — Foreign key → player.id — NOT NULL
  • isActive (Field) — boolean
  • type (Field2) — enum
  • accessToken (Field3) — string
  • refreshToken (Field4) — string
  • createdAt (Field5) — Date
  • updatedAt (Field6) — Date

report

  • id (Key) — number — Primary key — NOT NULL
  • team id (Key2) — number — Foreign key → Team.id — NOT NULL
  • title (Field) — string
  • createdAt (Field3) — Date
  • updatedAt (Field4) — Date
  • memo (Field2) — string
  • numbers (Field5) — number
  • isTeam (Field6) — boolean

self record (CopyOfself-record2)

  • id (Key) — number — Primary key — NOT NULL
  • figure-id (Key2) — number — Foreign key → self record figure.id — NOT NULL
  • player-id (Key3) — number — Foreign key → player.id — NOT NULL
  • value (Field) — number
  • createdAt (Field2) — Date
  • updatedAt (Field3) — Date

self record (self-record)

  • id (Key) — number — Primary key — NOT NULL
  • selfRecordFigureid (Key2) — number — Foreign key → self record figure.id — NOT NULL
  • player id (Key3) — number — Foreign key → player.id — NOT NULL
  • value (Field) — number
  • createdAt (Field2) — Date
  • updatedAt (Field3) — Date

self record figure (CopyOfself-record-figures)

  • id (Key) — number — Primary key — NOT NULL
  • group-id (Key2) — number — Foreign key → self record group.id — NOT NULL
  • figureName (Field) — string
  • digit (Field2) — number
  • unit (Field3) — string
  • createdAt (Field4) — Date
  • updatedAt (Field5) — Date

self record figure (self-record-figures)

  • id (Key) — number — Primary key — NOT NULL
  • selfRecordFigureGroupId (Key2) — number — Foreign key → self record figure group.id — NOT NULL
  • figureName (Field) — string
  • digit (Field2) — number
  • unit (Field3) — string
  • createdAt (Field4) — Date
  • updatedAt (Field5) — Date

self record figure group (self-record-figure-groups)

  • id (Key) — number — Primary key — NOT NULL
  • team id (Key2) — number — Foreign key → Team.id — NOT NULL
  • groupName (Field) — string
  • createdAt (Field2) — Date
  • updatedAt (Field3) — Date

self record group (CopyOfself-record-figure-groups)

  • id (Key) — number — Primary key — NOT NULL
  • team-id (Key2) — number — Foreign key → Team.id — NOT NULL
  • groupName (Field) — string
  • createdAt (Field2) — Date
  • updatedAt (Field3) — Date

user

  • id (Key) — number — Primary key — NOT NULL
  • email (Field) — string
  • password (Field2) — string
  • name (Field3) — string
  • type (Field4) — enum
  • privacyPolicy (Field5) — boolean
  • termsOfService (Field6) — boolean
  • refreshToken (Field7) — string
  • createdAt (Field8) — Date
  • updatedAt (Field9) — Date