ddddd
Tables (8)
AI_Analysis
- analysis_id — NUMBER
- consultation_id — NUMBER — NOT NULL
- analysis_text — CLOB
Consultation
- consultation_id — NUMBER
- counsel_id — NUMBER — NOT NULL
- consultation_date — DATE — NOT NULL
- consultation_time — VARCHAR2(10)
- status — VARCHAR2(20)
Consultation_Subject
- consultation_id — NUMBER — Primary key — NOT NULL
- subject_id — NUMBER — Primary key — NOT NULL
Counsel
- counsel_id — NUMBER
- student_id — VARCHAR2(20) — NOT NULL
- teacher_id — VARCHAR2(20) — NOT NULL
Result
- result_id — NUMBER
- analysis_id — NUMBER — NOT NULL
- summary — VARCHAR2(500)
- guide — CLOB
Student
- student_id — VARCHAR2(20)
- name — VARCHAR2(50) — NOT NULL
- contact — VARCHAR2(20)
- address — VARCHAR2(100)
- password — VARCHAR2(100) — NOT NULL
Subject
- subject_id — NUMBER
- name — VARCHAR2(50) — NOT NULL
Teacher
- teacher_id — VARCHAR2(20)
- name — VARCHAR2(50) — NOT NULL
- subject — VARCHAR2(50)
- email — VARCHAR2(100)
- password — VARCHAR2(100) — NOT NULL