sampledb
Tables (5)
branch_master (Untitled)
- branch (Key) — VARCHAR(255) — Primary key — NOT NULL
course_master (Untitled3)
- course (Key) — VARCHAR(255) — Primary key — NOT NULL
courses (Untitled4)
- course (Key) — VARCHAR(255) — Foreign key → course_master.course — NOT NULL
- student_id (Key2) — CHAR(5) — Foreign key → students.student_id — NOT NULL
exams (Untitled5)
- exam_no (Key2) — INT — Primary key — NOT NULL
- subject (Key3) — VARCHAR(255) — Primary key — NOT NULL
- student_id (Key) — CHAR(5) — Foreign key → students.student_id — NOT NULL
- score (Field) — INT
students (Untitled2)
- student_id (Key) — CHAR(5) — Primary key — NOT NULL
- student_name (Field) — VARCHAR(255)
- mobile_phone (Field2) — VARCHAR(255)
- school (Field3) — VARCHAR(255)
- branch (Key2) — VARCHAR(255) — Foreign key → branch_master.branch — NOT NULL