erd
Tables (5)
games
- Id (Key) — Integer — Primary key — NOT NULL
- language — tinyint
items
- Key — Integer — Primary key — NOT NULL
- Key (Key2) — Integer — Foreign key → users.Key — NOT NULL
- price — integer — NOT NULL
- stock_quantity — integer — NOT NULL
- name — varchar(255)
parts
- Id (Key) — Integer — Foreign key → games.Id — NOT NULL
- game_id — bigint
- id — bigint
stages
- Key — Integer — Primary key — NOT NULL
- Id (Key2) — Integer — Foreign key → parts.Id — NOT NULL
- reward_coin — integer — NOT NULL
- part_id — bigint
- input_description — varchar(255)
- input_example — varchar(255)
- output_description — varchar(255)
- output_example — varchar(255)
- stage_description — varchar(255)
users
- Key — Integer — Primary key — NOT NULL
- birth — date
- coin — integer — NOT NULL
- latest_stage — integer — NOT NULL
- preffered_language — tinyint
- email — varchar(255)
- login_id — varchar(255)
- login_password — varchar(255)
- name — varchar(255)
- nickname — varchar(255)
- phone_number — varchar(255)
- Field