blackjack
Tables (4)
PlayRecord
- RecordNum (Key) — INT — Primary key — NOT NULL
- UserNumber (Key2) — INT — Foreign key → UserData.UserNumber — NOT NULL
- MatchWinningBonus (Field2) — INT
- Wins (Field3) — INT
Tear
- TearID (Key) — INT(1) — Primary key — NOT NULL
- TearName (Field) — VARCHAR(10)
UserData
- UserNumber (Key) — INT — Primary key — NOT NULL
- RankingNumber (Key3) — INT — Foreign key → UserRanking.RankingNumber — NOT NULL
- TearID (Key4) — INT(1) — Foreign key → Tear.TearID — NOT NULL
- UserID (Field) — VARCHAR(30) — NOT NULL
- UserPassword (Field2) — VARCHAR(12) — NOT NULL
- Balance (Field3) — INT
UserRanking
- RankingNumber (Key) — INT — Primary key — NOT NULL
- RecordNum (Key3) — INT — Foreign key → PlayRecord.RecordNum — NOT NULL
- Rank (Field) — INT
- UserNum (Field2) — INT — NOT NULL
- TearName (Field3) — VARCHAR(10)
- Wins (Field4) — INT
- MatchWinningBonus (Field5) — INT