bowling-club

Tables (8)

Copy Of games (CopyOfUntitled3)

  • seq (Key) — int — Primary key — NOT NULL
  • masterSeq (Key2) — int — Foreign key → accounts.seq — NOT NULL
  • gameDate (Field) — date
  • regular (Field3) — int

accounts (Untitled)

  • seq (Key) — int — Primary key — NOT NULL
  • id (Field) — varchar(30)
  • password (Field2) — varchar(255)
  • nickname (Field3) — varchar(30)
  • regTime (Field4) — datetime
  • lastLogin (Field5) — datetime

clubConfigs (Untitled5)

  • seq (Key2) — int — Foreign key → accounts.seq — NOT NULL
  • womanHandy (Field) — int
  • maximumAvg (Field2) — int
  • lastMonthCount (Field3) — int

gameScores (Untitled4)

  • seq (Key) — int — Primary key — NOT NULL
  • gameSeq (Key2) — int — Foreign key → games.seq — NOT NULL
  • teamMappingSeq (Key3) — int — Foreign key → teamMappings.seq — NOT NULL
  • index (Field2) — int
  • score (Field) — int

gameScores (Untitled6)

  • seq (Key) — Primary key — NOT NULL
  • memberSeq (Field)
  • teamIndex (Field3)
  • score (Field2)

games (Untitled3)

  • seq (Key) — int — Primary key — NOT NULL
  • gameDate (Field) — date
  • regular (Field3) — int

members (Untitled2)

  • seq (Key) — int — Primary key — NOT NULL
  • masterSeq (Key2) — int — Foreign key → accounts.seq — NOT NULL
  • name (Field) — varchar(30)
  • gender (Field2) — int

teamMappings (Untitled7)

  • seq (Key) — int — Primary key — NOT NULL
  • memberSeq (Key3) — int — Foreign key → members.seq — NOT NULL
  • index (Field)