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