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