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