daily1_엔티티추출

테이블 (4)

교육생 (Entity1)

  • Contract Id (contact_id) — INT(11) — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Genaration (generation) — INT(1)
  • Major (major) — CHAR(1)
  • Leave (leave) — CHAR(1)
  • Location (location) — VARCHAR(255)
  • Class (class) — INT(1)

반 (Entity4)

  • Location (location) — VARCHAR(255) — 기본 키 — NOT NULL
  • Class (class) — INT(1) — 기본 키 — NOT NULL
  • Contract Id (contact_id) — INT(11) — 외래 키 → 교육생.Contract Id — NOT NULL
  • Contract Id (contact_id2) — INT(11) — 외래 키 → 컨설턴트.Contract Id — NOT NULL

컨설턴트 (Entity3)

  • Contract Id (contact_id) — INT(11) — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Task (task) — VARCHAR(255)

코치 (Entity2)

  • Contract Id (contact_id) — INT(11) — 기본 키 — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Task (task) — VARCHAR(255)
  • Location (location) — VARCHAR(255) — 외래 키 → 반.Location — NOT NULL
  • Class (class) — INT(1) — 외래 키 → 반.Class — NOT NULL