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