daily_1_엔티티추출

테이블 (6)

Batches

  • id — INT
  • name — VARCHAR(50) — NOT NULL

Classes

  • id — INT
  • region — ENUM('서울', '대전', '구미', '광주', '부울경') — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • consultant_id — INT — NOT NULL
  • coach_id — INT

Coaches

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • responsibility — VARCHAR(100) — NOT NULL

Consultants

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • responsibility — VARCHAR(100) — NOT NULL

Courses

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • type — ENUM('공통', '특화', '자율') — NOT NULL
  • Field

Students

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • batch_id — INT — NOT NULL
  • major — BOOLEAN — NOT NULL
  • is_graduated — BOOLEAN — NOT NULL