jdbcProject

Tables (3)

matches

  • match_id — INT — Primary key
  • teamA — VARCHAR(30) — NOT NULL
  • teamB — VARCHAR(30) — NOT NULL
  • match_date — DATE — NOT NULL
  • result — VARCHAR2(10) — NOT NULL

members

  • user_no — INT — Primary key
  • userId — VARCHAR2(30) — NOT NULL
  • userPwd — VARCHAR2(30) — NOT NULL
  • userName — VARCHAR2(20) — NOT NULL
  • myTeam — VARCHAR2(30)

teams

  • team_id — INT — Primary key
  • teamName — VARCHAR2(30) — NOT NULL
  • win — NUMBER
  • draw — NUMBER
  • lose — NUMBER
  • totalScore — NUMBER