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