SSAFY_ERD

Tables (5)

class (Entity4)

  • class_id (Key) — int — Primary key — NOT NULL
  • region (Field) — varchar(20)
  • class_num (Field2) — int

coach (Entity5)

  • coach_id (Key2) — int — Primary key — NOT NULL
  • class_id (Key) — int — Foreign key → class.class_id — NOT NULL
  • name (att3) — varchar(20)
  • work (att4) — varchar(20)

consultant (Entity6)

  • consultant_id (Key) — int — Primary key — NOT NULL
  • class_id (Key2) — int — Foreign key → class.class_id — NOT NULL
  • name (Field) — varchar(20)
  • work (Field2) — varchar(20)

project (Entity2)

  • curriculum_id (Key) — int — Primary key — NOT NULL
  • field (att5) — varchar(20)

trainee (Entity1)

  • student_id (Key2) — int — Primary key
  • curriculum_id (Key4) — int — Foreign key → project.curriculum_id — NOT NULL
  • class_id (Key) — int — Foreign key → class.class_id — NOT NULL
  • major (att2) — boolean
  • cardinal (att1) — int
  • name (Field) — varchar(20)
  • discharge (Field2) — boolean