db1
Tables (10)
ASSIGNMENT (Untitled3)
- assignment_id (Key) — INT — Primary key — NOT NULL
- course_id (Field) — INT
- title (Field2) — VARCHAR
- description (Field3) — TEXT
- due_date (Field4) — DATE
- status (Field5) — VARCHAR
ASSIGNMENT
- assignment_id — INT
- course_id — INT — Foreign key → COURSE.course_id
- title — VARCHAR(100)
- description — TEXT
- due_date — DATE
- status — VARCHAR(20)
COURSE (Untitled2)
- course_id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → USER.user_id — NOT NULL
- user_id (Field) — INT
- course_name (Field2) — VARCHAR
- professor (Field3) — VARCHAR
- class_time (Field4) — VARCHAR
COURSE
- course_id — INT
- user_id — INT — Foreign key → USER.user_id
- course_name — VARCHAR(100)
- professor — VARCHAR(50)
- class_time — VARCHAR(50)
EXAM (Untitled4)
- exam_id (Key) — INT — Primary key — NOT NULL
- course_id (Field) — INT
- exam_type (Field2) — VARCHAR
- exam_date (Field3) — DATE
EXAM
- exam_id — INT
- course_id — INT — Foreign key → COURSE.course_id
- exam_type — VARCHAR(50)
- exam_date — DATE
TEAM_PROJECT (Untitled5)
- project_id (Key) — INT — Primary key — NOT NULL
- course_id (Field) — INT
- project_name (Field2) — VARCHAR
- presentation_date (Field3) — DATE
- member_info (Field4) — TEXT
TEAM_PROJECT
- project_id — INT
- course_id — INT — Foreign key → COURSE.course_id
- project_name — VARCHAR(100)
- presentation_date — DATE
- member_info — TEXT
USER (Untitled)
- user_id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR
- email (Field2) — VARCHAR
- password (Field3) — VARCHAR
USER
- user_id — INT
- name — VARCHAR(50)
- email — VARCHAR(100)
- password — VARCHAR(100)