GYM

Tables (4)

table (member)

  • no — int — Primary key — NOT NULL
  • trainer_no — int — Foreign key → table.no — NOT NULL
  • id — String
  • password — String
  • name — String
  • address — String
  • gender — String
  • hp — String
  • age — int

table (info)

  • no (no2) — int — Foreign key → table.no — NOT NULL
  • register_date — date — NOT NULL
  • date_count — int — NOT NULL
  • pt_count (remain_pt) — int

table (trainer)

  • no (auto_increment) — int — Primary key — NOT NULL
  • id — String
  • password — String
  • name — String
  • address — String
  • gender — String
  • hp — String
  • age — int

table (introduction)

  • no (auto_increment) — int — Primary key — NOT NULL
  • trainer_no — int — Foreign key → table.no — NOT NULL
  • orgName (Field) — String
  • saveName (Field2) — String
  • filePath (Field3) — String
  • fileSize (Field4) — String
  • title (Field5) — String
  • content (Field6)