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)