Insight

Tables (8)

Analysis (CopyOfCopyOfCopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL
  • image_id (Key2) — Foreign key → Dicom_Image.id — NOT NULL
  • result (Field)

Analysis_Detail (Untitled2)

  • Key — Primary key — NOT NULL
  • analysis_id (Key2) — Foreign key → Analysis.id — NOT NULL
  • detail (Field)

Analysis_Failed_Detail (CopyOfUntitled22)

  • id (Key) — Foreign key → Analysis.id — NOT NULL
  • analysis_id (Key2) — Foreign key → Analysis.image_id — NOT NULL
  • detail (Field)

Dicom_Image (CopyOfCopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → Member.id — NOT NULL
  • json_converted (Field) — NON-NULL

Invalid_Member (CopyOfUntitled23)

  • Key — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → Member.id — NOT NULL
  • reason (Field3)

Member (멤버)

  • id (Key) — Primary key — NOT NULL
  • name (Field) — NON-NULL
  • phone (Field2) — NON-NULL
  • email (Field3) — NON-NULL
  • address (Field4) — NON-NULL
  • login_id (Field5) — NON-NULL
  • password (Field6) — NON-NULL
  • role (Field7) — NON-NULL

Member_Status_History (멤버 상태 히스토리)

  • id (Key) — NON-NULL — Primary key — NOT NULL
  • member_id (Key2) — NON-NULL — Foreign key → Member.id — NOT NULL
  • status (Field) — NON-NULL

Subscription (CopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL
  • memberId (Key2) — Foreign key → Member.id — NOT NULL
  • analysisLimit (Field) — NON-NULL
  • analysisCompletedCount (Field2) — NON-NULL
  • startedAt (Field3) — NON-NULL
  • expiredAt (Field4) — NON-NULL
  • isActive (Field5) — NON-NULL