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