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)