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