mems_db

Tables (4)

CustomerEntity (Untitled4)

  • id (아이디) — int — Primary key — NOT NULL
  • name (이름)
  • code (고객사 코드)
  • address (주소)
  • addressDetail (상세 주소)
  • phoneNumber (전화번호)
  • createDate (생성일)
  • updateDate (수정일)

DisplayGroup (디스플레이 그룹 테이블)

  • id (Long) — Long — Primary key — NOT NULL
  • name (그룹명) — String
  • description (설명) — String
  • sort_order (화면 정렬 순서) — int
  • created_at (생성일) — LocalDateTime
  • updated_at (수정일) — LocalDateTime
  • customer_id (고객 id) — irt

DisplayGroupEmplacementMapping (M:N 맵핑 테이블)

  • id (Long) — Primary key — NOT NULL
  • created_at (Field) — LocalDateTime
  • emplacement_id (Key) — int — Foreign key → EmplacementEntity.id — NOT NULL
  • diplay_group_id (Long2) — Long — Foreign key → DisplayGroup.id — NOT NULL

EmplacementEntity (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • name (이름) — String
  • emplacementType (장치 타입) — ENUM
  • wiringType (Field) — ENUM
  • volt (Field2)
  • customer_id (아이디) — int — Foreign key → CustomerEntity.id — NOT NULL