SSAFY

Tables (7)

Class

  • cls_id (Key) — int — Primary key — NOT NULL
  • region_id (Key3) — integer — Foreign key → Region.region_id — NOT NULL
  • coach_id (Key2) — integer — Foreign key → Coach.coach_id — NOT NULL
  • consultant_id (Key22) — integer — Foreign key → Consultant.consultant_id — NOT NULL
  • cls_number (Field) — integer

Coach (Entity1)

  • coach_id (Key) — integer — Primary key — NOT NULL
  • coach_name (att1) — character varying
  • coach_task (att2) — character varying

Consultant (Entity5)

  • consultant_id (Key2) — integer — Primary key — NOT NULL
  • consultant_name (attr3) — character varying
  • consultant_task (attr4) — character varying

Course (Entity6)

  • course_id (Key) — integer — Primary key — NOT NULL
  • course_name (attr7) — character varying

Region (Entity2)

  • region_id (Key) — integer — Primary key — NOT NULL
  • region_name (attr5) — character varying

Student (Untitled)

  • student_id (Key) — integer — Primary key — NOT NULL
  • year_id (Key2) — integer — Foreign key → Year.year_id — NOT NULL
  • course_id (Key3) — integer — Foreign key → Course.course_id — NOT NULL
  • cls_id (Key4) — int — Foreign key → Class.cls_id — NOT NULL
  • region_id (Key32) — integer — Foreign key → Class.region_id — NOT NULL
  • coach_id (Key22) — integer — Foreign key → Class.coach_id — NOT NULL
  • consultant_id (Key222) — integer — Foreign key → Class.consultant_id — NOT NULL
  • student_name (Field) — character varying
  • is_graduate (Field2) — boolean
  • is_major (Field3) — boolean

Year (Entity3)

  • year_id (Key) — integer — Primary key — NOT NULL
  • year_number (attr6) — integer