ㅏㅏ
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