erd_practice

Tables (4)

CLASS (반)

  • CLASSNO (classno) — INT — Primary key — NOT NULL
  • AREA (area) — VARCHAR(45) — Primary key — NOT NULL
  • STUDENTNO (studentno) — INT — Foreign key → STUDENT.STUDENTNO — NOT NULL
  • CONSULTANT (consultant) — VARCHAR(45)
  • COACH (coach) — VARCHAR(45)
  • PROCESS (process) — VARCHAR(45)

COACH (코치)

  • COACHNO (coachno) — INT — Primary key — NOT NULL
  • CLASSNO (classno) — INT — Foreign key → CLASS.CLASSNO — NOT NULL
  • AREA (area) — VARCHAR(45) — Foreign key → CLASS.AREA — NOT NULL
  • STUDENTNO (studentno) — INT — Foreign key → CLASS.STUDENTNO — NOT NULL
  • BUSINESS (business) — VARCHAR(45)

CONSULTANT (컨설턴트)

  • CONSULTANTNO (consultantno) — INT — Primary key — NOT NULL
  • CLASSNO (classno) — INT — Foreign key → CLASS.CLASSNO — NOT NULL
  • AREA (area) — VARCHAR(45) — Foreign key → CLASS.AREA — NOT NULL
  • STUDENTNO (studentno) — INT — Foreign key → CLASS.STUDENTNO — NOT NULL
  • BUSINESS (business) — VARCHAR(45)

STUDENT (교육생)

  • STUDENTNO (studentno) — INT — Primary key — NOT NULL
  • GENERATION (generation) — INT
  • MAJOR (major) — VARCHAR(50)
  • LEAVE (leave) — INT
  • STUDENTNAME (studentname) — VARCHAR(20)