SW#7
Tables (5)
Consultants
- id — INT — Primary key — NOT NULL
- classes_id — INT — Foreign key → classes.id — NOT NULL
- tasks_id — INT — Foreign key → tasks.id — NOT NULL
- email — VARCHAR(45) — NOT NULL
- name — VARCHAR(45) — NOT NULL
- birth_date — DATE — NOT NULL
- phone — VARCHAR(45) — NOT NULL
- INDEX — `fk_Consultants_tasks1_idx`
- INDEX — `fk_Consultants_classes1_idx`
classes
- id — INT — Primary key — NOT NULL
- location — VARCHAR(45) — NOT NULL
- class_number — INT — NOT NULL
- cource — VARCHAR(45)
coaches
- id — INT — Primary key — NOT NULL
- tasks_id — INT — Foreign key → tasks.id — NOT NULL
- classes_id — INT — Foreign key → classes.id — NOT NULL
- email — VARCHAR(45) — NOT NULL
- name — VARCHAR(45) — NOT NULL
- phone — VARCHAR(45) — NOT NULL
- birth_date — DATE — NOT NULL
- INDEX — `fk_coaches_tasks1_idx`
- INDEX — `fk_coaches_classes1_idx`
students
- id — INT — Primary key — NOT NULL
- classes_id — INT — Foreign key → classes.id — NOT NULL
- email — VARCHAR(45) — NOT NULL
- name — VARCHAR(45) — NOT NULL
- phone — VARCHAR(45) — NOT NULL
- birth_date — DATE — NOT NULL
- cohort — INT — NOT NULL
- is_major — TINYINT — NOT NULL
- is_discharged — TINYINT — NOT NULL
- INDEX — `fk_students_classes1_idx`
tasks
- id — INT — Primary key — NOT NULL
- name — VARCHAR(45) — NOT NULL