ㅏㅏ

Tables (6)

Chart (차트)

  • chartId (차트ID) — BIGINT — Primary key — NOT NULL
  • doctorId (의사ID) — BIGINT — Foreign key → Doctor.doctorId — NOT NULL
  • patientId (환자ID) — BIGINT — Foreign key → Patient.patientId — NOT NULL
  • opinion (소견) — VARCHAR(255)

Doctor (의사)

  • doctorId (의사ID) — BIGINT — Primary key — NOT NULL
  • department (담당진료과목) — VARCHAR(255)
  • name (성명) — VARCHAR(255)
  • sex (성별) — CHAR(1)
  • phoneNumber (연락처) — VARCHAR(11)
  • email (이메일) — VARCHAR(255)
  • rank (직급) — VARCHAR(255)

Nurse (간호사)

  • nurseId (간호사ID) — BIGINT — Primary key — NOT NULL
  • task (담당업무) — VARCHAR(255)
  • name (성명) — VARCHAR(255)
  • sex (성별) — CHAR(1)
  • phoneNumber (연락처) — VARCHAR(11)
  • email (이메일) — VARCHAR(255)
  • rank (직급) — VARCHAR(255)

Nurse-Chart (간호사와 차트 중간 테이블)

  • nurseId (간호사ID) — BIGINT — Foreign key → Nurse.nurseId — NOT NULL
  • chartId (차트ID) — BIGINT — Foreign key → Chart.chartId — NOT NULL

Patient (환자)

  • patientId (환자ID) — BIGINT — Primary key — NOT NULL
  • doctorId (의사ID) — BIGINT — Foreign key → Doctor.doctorId — NOT NULL
  • nurseId (간호사ID) — BIGINT — Foreign key → Nurse.nurseId — NOT NULL
  • name (성명) — VARCHAR(255)
  • sex (성별) — CHAR(1)
  • residentNumber (주민번호) — CHAR(13)
  • address (주소) — VARCHAR(255)
  • phoneNumber (연락처) — VARCHAR(11)
  • job (직업) — VARCHAR(255)

Treatment (진료)

  • treatmentId (진료날짜+진료순번) — BIGINT — Primary key — NOT NULL
  • doctorId (의사ID) — BIGINT — Foreign key → Doctor.doctorId — NOT NULL
  • nurseId (간호사ID) — BIGINT — Foreign key → Nurse.nurseId — NOT NULL
  • patientId (환자ID) — BIGINT — Foreign key → Patient.patientId — NOT NULL
  • content (진료내용) — VARCHAR(255)
  • createdAt (진료날짜) — DATETIME