sharefit
Tables (3)
Card (card)
- ID (id) — INT — Primary key — NOT NULL
- CenterID (center_id) — INT — Foreign key → Center.ID — NOT NULL
- Training (training) — VARCHAR(255) — NOT NULL
- CurrCnt (curr_cnt) — INT — NOT NULL
- Expiry (expiry) — DATE — NOT NULL
- TotalCnt (total_cnt) — INT — NOT NULL
Center (center)
- ID (id) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR(127) — NOT NULL
- PhoneNumber (phone_number) — VARCHAR(15) — NOT NULL
- Address (address) — VARCHAR(255) — NOT NULL
User (user)
- ID (id) — INT — Primary key — NOT NULL
- CardID (card_id) — INT — Foreign key → Card.ID — NOT NULL
- Name (name) — VARCHAR(127) — NOT NULL
- PhoneNumber (phone_number) — VARCHAR(15) — NOT NULL