13
Tables (6)
can
- can_id — int(100) — Primary key — NOT NULL
- 이름 (can_name) — varchar(100)
- 난이도 (can_level) — int(50)
general
- general_id (general_Id) — int(100) — Primary key — NOT NULL
- 이름 (general_name) — varchar(100)
- 난이도 (general_level) — int(50)
paper
- paper_id — int(100) — Primary key — NOT NULL
- 이름 (paper_name) — varchar(100)
- 난이도 (papaer_level) — int(50)
plastic
- plastic_Id — int(100) — Primary key — NOT NULL
- 이름 (plastic_name) — varchar(100)
- 난이도 (plastic_level) — int(50)
player
- player_id — int(100) — Primary key — NOT NULL
- 이름 (player_name) — varchar(100)
- 맞은 개수 (player_correct) — int(50)
- paper_id — int(100) — Foreign key → paper.paper_id — NOT NULL
- general_id (general_Id) — int(100) — Foreign key → general.general_id — NOT NULL
- can_id — int(100) — Foreign key → can.can_id — NOT NULL
- plastic_Id — int(100) — Foreign key → plastic.plastic_Id — NOT NULL
waste
- waste_id — int(50) — Primary key — NOT NULL
- 쓰레기 이름 (waste_name) — warchar(100)
- 분리수거 (waste_separate) — varchar(100)
- 난이도 (waste_level) — int(50)