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