wordle

Tables (3)

t_nf_play

  • play_seq — INT — Primary key — NOT NULL
  • start_date — DATETIME
  • end_date — DATETIME
  • answer — VARCHAR(100)
  • word_length — INT
  • count — INT
  • play_time — INT
  • email — VARCAHR(100) — Foreign key → t_nf_user.email — NOT NULL

t_nf_user

  • email — VARCAHR(100) — Primary key — NOT NULL
  • password — VARCHAR(100)
  • name — VARCHAR(100)
  • gender — TINYINT
  • reg_date — DATETIME
  • user_status — ENUM
  • pwd_fail_count — INT

t_nf_word (Untitled)

  • word_seq — INT — Primary key — NOT NULL
  • word — VARCHAR(10)
  • meaning — VARCHAR(10)