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')