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