pro

Tables (6)

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

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