scoremaster-doyung
Tables (11)
MEMBERS
- id — BIGINT — Primary key — NOT NULL
- create_date — TIMESTAMP
- modify_date — TIMESTAMP
- create_by — VARCHAR(255)
- modify_by — VARCHAR(255)
- name — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(255) — NOT NULL
- point — INT
coaches
- id — integer — Primary key — NOT NULL
- create_date — timestamp
- modify_date — timestamp
- country — varchar(255)
- frist_name — varchar(255)
- last_name — varchar(255)
- create_by — varchar(255)
- modify_by — varchar(255)
- away_team_score — integer — NOT NULL
- betting_point — integer — NOT NULL
- home_team_score — integer
- score_prediction_succed — boolean
- win_team_betting — varchar(255)
- win_team_prediction_succed — boolean — NOT NULL
- matchs_id — bigint
- members_id — bigint
coaches_aud
- id — bigint — Primary key — NOT NULL
- rev — integer — Primary key — NOT NULL
- revtype — tinyint
- create_date — timestamp
- modify_date — timestamp
- create_by — varchar(255)
- modify_by — varchar(255)
- away_team_score — integer
- away_team_score_mod — boolean
- betting_point — integer
- betting_point_mod — boolean
- home_team_score — integer
- home_team_score_mod — boolean
- win_team_betting — varchar(255)
- win_team_betting_mod — boolean
favorite_teams
- id — bigint — Primary key — NOT NULL
- create_date — timestamp
- modify_date — timestamp
- members_id — bigint — Foreign key → members.id — NOT NULL
- teams_id — BIGINT — Foreign key → teams.id — NOT NULL
leagues
- id — BIGINT — Primary key — NOT NULL
- create_date — datetime
- modify_date — datetime
- name — VARCHAR(255)
- start_date — date
- end_date — date
- logo — VARCHAR(255)
- country — VARCHAR(255)
- football_api_league_id — BIGINT
matchs
- id — BIGINT — Primary key — NOT NULL
- leagues_id — BIGINT
- home_team_id — BIGINT
- away_team_id — BIGINT
- stardiums_id — BIGINT
- match_status — VARCHAR(255)
- match_result — VARCHAR(255)
- home_team_score — INT
- away_team_score — INT
- referee — VARCHAR(255)
- football_api_fixture_id — BIGINT
matchs_aud
- id — bigint — Primary key — NOT NULL
- rev — integer — Primary key — NOT NULL
- revtype — tinyint
- away_team_score — integer
- away_team_score_mod — boolean
- home_team_score — integer
- home_team_score_mod — boolean
members
- id — bigint — Primary key — NOT NULL
- create_date — timestamp
- modify_date — timestamp
- create_by — varchar(255)
- modify_by — varchar(255)
- email — varchar(255)
- name — varchar(255) — NOT NULL
- password — varchar(255)
- point — int
revinfo
- rev — integer — Primary key — NOT NULL
- revtstmp — bigint
stardiums
- id — BIGINT — Primary key — NOT NULL
- create_date — datetime
- modify_date — datetime
- name — VARCHAR(255)
- full_name — VARCHAR(255)
- city — VARCHAR(255)
- address — VARCHAR(255)
- capacity — INT — NOT NULL
- country — VARCHAR(255)
- max_spectator — INT
- image_url — VARCHAR(255)
- football_api_stardium_id — BIGINT
teams
- id — BIGINT — Primary key — NOT NULL
- stardiums_id — BIGINT — Foreign key → stardiums.id — NOT NULL
- create_date — datetime
- modify_date — datetime
- name — VARCHAR(255)
- full_name — VARCHAR(255)
- code — VARCHAR(255)
- country — VARCHAR(255)
- city — VARCHAR(255)
- logo_url — VARCHAR(255)
- founded — INT
- football_api_team_id — BIGINT