UMC Week10
Tables (6)
BaseEntity (Untitled2)
- createdAt (생성 시간) — datetime
- updatedAt (수정 시간) — datetime
Department (진료과)
- id (진료과id) — bigint — Primary key — NOT NULL
- hospital_id (병원 id) — bigint — Foreign key → Hospital.id — NOT NULL
- name (진료과 이름) — varchar(50)
Doctor (의사)
- id (의사 id) — bigint — Primary key — NOT NULL
- department_id (진료과id) — bigint — Foreign key → Department.id — NOT NULL
- hospital_id (병원 id) — bigint — Foreign key → Department.hospital_id — NOT NULL
- name (이름) — varchar(10)
- career (경력) — int
Hospital (병원)
- id (병원 id) — bigint — Primary key — NOT NULL
- name (병원 이름) — varchar(20)
- address (병원 주소) — varchar(100)
Patient (Untitled)
- id (환자 id) — bigint — Primary key — NOT NULL
- name (이름) — varchar(10) — NOT NULL
- gender (성별) — varchar(10) — NOT NULL
- age (나이) — int — NOT NULL
Reservation (예약 정보)
- id (예약 id) — bigint — Primary key — NOT NULL
- patient_id (환자 id) — bigint — Foreign key → Patient.id — NOT NULL
- doctor_id (의사 id) — bigint — Foreign key → Doctor.id — NOT NULL
- id (진료과id) — bigint — Foreign key → Doctor.department_id — NOT NULL
- hospital_id (병원 id) — bigint — Foreign key → Doctor.hospital_id — NOT NULL
- time (예약 시간) — datetime — NOT NULL
- status (예약 상태) — varchar(10) — NOT NULL
- fee (병원비) — int