test

테이블 (11)

Consulting (consulting)

  • Consult_Num (consult_num) — int — 기본 키 — NOT NULL
  • Res_Num (res_num) — int — 외래 키 → Reservation.Res_Num — NOT NULL
  • Content (content) — varchar

Department (department)

  • Department_ID (department_id) — varchar — 기본 키 — NOT NULL
  • Name (name) — varchar
  • Numbern (number) — varchar

Professor (professor)

  • Professor_ID (professor_id) — varchar — 기본 키 — NOT NULL
  • Name (name) — varchar
  • Phone (phone) — varchar

Reservation (reservation)

  • Res_Num (res_num) — int — 기본 키 — NOT NULL
  • Date (date) — date
  • Receipt (receipt) — bool
  • Cancle (cancle) — bool
  • About (about) — varchar

Student (student)

  • Student_ID (student_id) — varchar — 기본 키 — NOT NULL
  • Name (name) — varchar
  • Phone (phone) — varchar

상담 (Untitled6)

    상담 (Untitled5)

      소속 (Untitled2)

        예약 (Untitled3)

          예약 (Untitled4)

            전공 (Untitled)