internetlecture
Tables (4)
enrollment (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- student_id (Key2) — bigint — Foreign key → student.id — NOT NULL
- lecture_id (Key3) — bigint — Foreign key → lecture.id — NOT NULL
lecture (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- teacher_id (Key2) — bigint — Foreign key → teacher.id — NOT NULL
- name (Field) — varchar
- price (Field2) — int
- category (Field3) — enum
student (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- password (Field2) — varchar
teacher (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar
- birthday (Field2) — date