dp
Tables (7)
annotations
- id — int — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id
- image_id — int — Foreign key → images.id — NOT NULL
- shapes — text
coordinates
- id — int — Primary key — NOT NULL
- x 좌표 (location_x) — int
- y 좌표 (location_y) — int
- shape_id — int — Foreign key → shapes.id — NOT NULL
images
- id — int — Primary key — NOT NULL
- edited_by — bigint — Foreign key → users.id — NOT NULL
- layerout_id — int — Foreign key → layouts.id — NOT NULL
- image_url (mage_url) — varchar(255) — NOT NULL
- annotation_status — enum('COMPLETED','IN_PROGRESS','PENDING') — NOT NULL
- layer — int
- imageOrder — int
layouts (laysouts)
- id — int — Primary key — NOT NULL
- patent_id (patient_id) — int — Foreign key → patients.id — NOT NULL
- layout_type — enum('COMPLETED','IN_PROGRESS','PENDING')
patients
- id — int — Primary key — NOT NULL
- patient_number — int
shapes
- id — int — Primary key — NOT NULL
- annotation_id — int — Foreign key → annotations.id — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- password — varchar(255) — NOT NULL
- user_id — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL
- role — enum('ADMIN','EMPTY','USER')