Typing Solution

Tables (5)

Untitled (namelist)

  • Key (name) — varchar(20) — Primary key — NOT NULL

Untitled (mambers_info)

  • Key (name) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (pw) — varchar(64) — NOT NULL
  • Field (join_date) — join_date — NOT NULL

Untitled (admin_info)

  • Key (name) — varchar(20) — Primary key — NOT NULL
  • Field (pw) — varchar(64) — NOT NULL
  • Field (join_date) — date — NOT NULL

Untitled (member_record)

  • Key (id) — number — Primary key — NOT NULL
  • Key (name) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (speed) — number — NOT NULL
  • Field (accuracy) — number — NOT NULL
  • Field (typing_date) — date — NOT NULL

Untitled (renewal_list)

  • Key (name) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (max_speed_id) — number — NOT NULL
  • Field2 (max_speed) — varchar(1) — NOT NULL
  • Field2 (renewal_speed) — number — NOT NULL
  • Field3 (renewal_yn) — number — NOT NULL
  • Field4 (ex_max_speed_id) — number
  • Field (ex_max_speed) — number
  • Field2 (ex_renewal_speed) — number