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