erd
Tables (12)
CheckupBundleOfItem (Untitled4)
- 문진표 문항 — Foreign key → checkup_sheet_item.문진표 문항 — NOT NULL
- Key — Foreign key → checkupsheetBundle.Key — NOT NULL
- Key (Key22) — Foreign key → checkupsheetBundle.Key — NOT NULL
- medicalsupplybundleId (번들아이디) — Foreign key → checkupsheetBundle.medicalsupplybundleId — NOT NULL
- Key (Key222) — Foreign key → checkupsheetBundle.Key — NOT NULL
appointment (예약자)
- Key — Primary key — NOT NULL
- Key (Key3) — Foreign key → medicalsupply.Key — NOT NULL
appointmentEntry (방문자 테이블)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → appointment.Key — NOT NULL
- appointmentId (Key3) — Foreign key → appointment.Key — NOT NULL
appointmentEntryOfMEdicalSUpplyItem (Untitled2)
- Key — Foreign key → medicalSupplyItem.Key — NOT NULL
- Key (Key2) — Foreign key → appointmentEntry.Key — NOT NULL
checkup_result_entry (문진표 응답결과)
- Key — Primary key — NOT NULL
- 문진표 문항 키 (Key2) — Foreign key → checkup_sheet_item.문진표 문항 — NOT NULL
- 예약자정보테이블 (Key3) — Foreign key → appointmentEntry.Key — NOT NULL
- Key (Key22) — Foreign key → appointmentEntry.Key — NOT NULL
- Key (Key32) — Foreign key → appointmentEntry.appointmentId — NOT NULL
checkup_sheet (문진표 기본정보)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → medicalSupplyItem.Key — NOT NULL
- medicalsupplybundleId (번들아이디) — Foreign key → medicalSupplyItem.medicalsupplybundleId — NOT NULL
- Key (Key22) — Foreign key → medicalSupplyItem.Key — NOT NULL
checkup_sheet_item (문진표 문항)
- 문진표 문항 — Primary key — NOT NULL
checkupsheetBundle (Untitled3)
- Key — Primary key — NOT NULL
- Key (Key2) — Foreign key → checkup_sheet.Key — NOT NULL
- Key (Key22) — Foreign key → checkup_sheet.Key — NOT NULL
- medicalsupplybundleId (번들아이디) — Foreign key → checkup_sheet.medicalsupplybundleId — NOT NULL
- Key (Key222) — Foreign key → checkup_sheet.Key — NOT NULL
- Field
- Field2
medicalSupplyBundle (번들)
- Key — Primary key — NOT NULL
- medicalsuuplyid (상품키) — Foreign key → medicalsupply.Key — NOT NULL
medicalSupplyItem (Untitled)
- Key — Primary key — NOT NULL
- medicalsupplybundleId (번들아이디) — Foreign key → medicalSupplyBundle.Key — NOT NULL
- Key (Key22) — Foreign key → medicalSupplyBundle.medicalsuuplyid — NOT NULL
medical_supply_of_checkup_sheet (상품 문진표 매핑)
- medicalsupplyId (상품 키) — Foreign key → medicalsupply.Key — NOT NULL
- checkupSheetId (Key) — Foreign key → checkup_sheet.Key — NOT NULL
- medicalsupplybundleId (번들아이디) — Foreign key → checkup_sheet.medicalsupplybundleId — NOT NULL
medicalsupply (상품)
- Key — Primary key — NOT NULL
- Field
- Field2