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