test
Tables (4)
CLASS
- ID (CLASS_ID) — INT — Primary key — NOT NULL
- NAME (CLASS_NAME) — VARCHAR
CLASS (CLASS2)
- NAME (CLASS_NAME) — VARCHAR — Primary key — NOT NULL
STUDENT
- ID (STDUENT_ID) — INT — Primary key — NOT NULL
- ID (CLASS_ID) — INT — Foreign key → CLASS.ID — NOT NULL
- NAME (STUDENT_NAME) — VARCHAR
STUDENT (STUDENT2)
- ID (STUDENT_ID) — INT — Primary key — NOT NULL
- NAME (CLASS_NAME) — VARCHAR — Foreign key → CLASS.NAME — NOT NULL
- NAME (STUDENT_NAME) — VARCHAR