ㄴㄴㄴㄴㄴ

Tables (6)

AI_Analysis

  • Key — Primary key — NOT NULL
  • analysis_id — NUMBER
  • consultation_id — NUMBER — NOT NULL
  • analysis_text — CLOB

Consultation

  • Key (Key22) — Foreign key → Teacher.Key — NOT NULL
  • consultation_id — NUMBER
  • counsel_id — NUMBER — NOT NULL
  • consultation_date — DATE — NOT NULL
  • consultation_time — VARCHAR2(10)
  • status — VARCHAR2(20)

Result

  • Key (Key2) — Foreign key → AI_Analysis.Key — NOT NULL
  • Key (Key22) — Foreign key → Consultation.Key — NOT NULL
  • Key (Key23) — Foreign key → Subject.Key — NOT NULL
  • result_id — NUMBER
  • analysis_id — NUMBER — NOT NULL
  • summary — VARCHAR2(500)
  • guide — CLOB

Student

  • Key — Primary key — NOT NULL
  • student_id — VARCHAR2(20)
  • name — VARCHAR2(50) — NOT NULL
  • contact — VARCHAR2(20)
  • address — VARCHAR2(100)
  • password — VARCHAR2(100) — NOT NULL

Subject

  • Key (Key2) — Foreign key → Teacher.Key — NOT NULL
  • subject_id — NUMBER
  • name — VARCHAR2(50) — NOT NULL

Teacher

  • Key (Key2) — Foreign key → Student.Key — NOT NULL
  • teacher_id — VARCHAR2(20)
  • name — VARCHAR2(50) — NOT NULL
  • subject — VARCHAR2(50)
  • email — VARCHAR2(100)
  • password — VARCHAR2(100) — NOT NULL