My contact

Tables (7)

Class (class)

  • class_num — int — Primary key — NOT NULL
  • loc_num — int — Foreign key → Location.loc_num — NOT NULL

Coach (coach)

  • coach_id — int — Primary key — NOT NULL
  • class_num — int — Foreign key → Class.class_num — NOT NULL
  • task_num — int — Foreign key → Task.task_num — NOT NULL

Consultant (consultant)

  • consultant_id — int — Primary key — NOT NULL
  • class_num — int — Foreign key → Class.class_num — NOT NULL
  • task_num — int — Foreign key → Task.task_num — NOT NULL

Curriculum (curriculum)

  • curriculum_num — int — Primary key — NOT NULL
  • curriculum_name — string

Location (location)

  • loc_num — int — Primary key — NOT NULL
  • loc_name — string

Student (student)

  • student_id — int — Primary key — NOT NULL
  • semester — int
  • is_major — boolean
  • is_leave — boolean
  • class_num — int — Foreign key → Class.class_num — NOT NULL
  • curriculum_num — int — Foreign key → Curriculum.curriculum_num — NOT NULL

Task (task)

  • task_num — int — Primary key — NOT NULL
  • task_name — string