HospitalERD

Tables (5)

Charts (Untitled5)

  • 차트번호 (chartnum) — INT — Primary key — NOT NULL
  • 진료날짜 (date) — DATE — Foreign key → Medical ID.진료날짜 — NOT NULL
  • 진료번호 (m_num) — INT — Foreign key → Medical ID.진료번호 — NOT NULL
  • 의사ID (d_id) — INT — Foreign key → Doctors.의사ID — NOT NULL
  • 간호사ID (n_id) — INT — Foreign key → Nurses.간호사ID — NOT NULL
  • 환자ID (p_id) — INT — Foreign key → Patients.환자ID — NOT NULL
  • 진료의견 (c_opinion) — VARCHAR(100)

Doctors (Untitled)

  • 의사ID (d_id) — INT — Primary key — NOT NULL
  • 담당진료과목 (d_sub) — VARCHAR(30)
  • 성명 (d_name) — VARCAHR(30)
  • 성별 (d_gen) — VARCHAR(30)
  • 연락처 (d_call) — INT
  • 이메일 (d_email) — VARCHAR(30)
  • 직급 (d_rank) — VARCHAR(30)

Medical ID (Untitled4)

  • 진료날짜 (m_date) — DATE — Primary key — NOT NULL
  • 진료번호 (m_num) — INT — Primary key — NOT NULL
  • 의사ID (d_id) — INT — Foreign key → Doctors.의사ID — NOT NULL
  • 간호사ID (n_id) — INT — Foreign key → Nurses.간호사ID — NOT NULL
  • 환자ID (p_id) — INT — Foreign key → Patients.환자ID — NOT NULL
  • 진료내용 (m_sub) — VARCHAR(100)

Nurses (Untitled2)

  • 간호사ID (n_id) — INT — Primary key — NOT NULL
  • 담당업무 (n_sub) — VARCHAR(30)
  • 성명 (n_name) — VARCHAR(30)
  • 성별 (n_gen) — VARCHAR(30)
  • 연락처 (n_call) — INT
  • 이메일 (n_email) — VARCHAR(30)
  • 직급 (n_rank) — VARCHAR(30)

Patients (Untitled3)

  • 환자ID (p_id) — INT — Primary key — NOT NULL
  • 의사ID (d_id) — INT — Foreign key → Doctors.의사ID — NOT NULL
  • 간호사ID (n_id) — INT — Foreign key → Nurses.간호사ID — NOT NULL
  • 환자성명 (p_name) — VARCHAR(30)
  • 주민번호 (p_resnum) — INT
  • 성별 (p_gen) — VARCHAR(30)
  • 주소 (p_address) — VARCHAR(30)
  • 연락처 (t_call) — INT
  • 이메일 (t_email) — VARCHAR(30)
  • 직업 (t_job) — VARCHAR(30)