DGRR_ERD_v1

Tables (4)

Untitled (game)

  • Key (game_id) — integer — Primary key — NOT NULL
  • Field (game_type) — String — NOT NULL
  • Field (game_date) — datetime — NOT NULL

Untitled (user_game)

  • Key (id) — integer — Primary key — NOT NULL
  • Key (user_id) — integer — Foreign key → User.Key — NOT NULL
  • Key (game_id) — integer — Foreign key → Untitled.Key — NOT NULL
  • Field (game_score) — varchar(64)
  • Field (game_rank) — integer

Untitled (matching)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (point) — integer
  • Field (join_time) — datetime
  • Field (matching_number) — integer
  • Field (is_matching) — integer
  • Field (game_data) — String
  • Field (result) — boolean
  • Field (recent_game_id) — Long
  • Key (user_id) — integer — Foreign key → User.Key — NOT NULL

User (user)

  • Key (user_id) — integer — Primary key — NOT NULL
  • Field (username) — varchar(32) — NOT NULL
  • Field (password) — varchar(128) — NOT NULL
  • Field (name) — varchar(32) — NOT NULL
  • Field (age) — Integer
  • Field (create_date) — datetime — NOT NULL
  • Field (gender) — string — NOT NULL
  • Field (nickname) — varchar(32) — NOT NULL
  • Field (points) — integer
  • Field (birthday) — datetime — NOT NULL
  • Field (email) — varchar(64) — NOT NULL
  • Field (user_img) — text
  • Field (pin) — Integer
  • Field (pin_create_time) — datetime
  • Field (state_message) — Integer