다빛LED
테이블 (5)
command
- id — INT — 기본 키 — NOT NULL
- cm_kind — VARCHAR(8) — NOT NULL
- cm_code — VARCHAR(255) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP — NOT NULL
- panel_id — INT — 외래 키 → panel.id — NOT NULL
panel
- id — INT — 기본 키 — NOT NULL
- panel_id — VARCHAR(20) — NOT NULL
- ip — VARCHAR(30) — NOT NULL
- port — VARCHAR(5) — NOT NULL
- log — VARCHAR(50) — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
- updatedAt — TIMESTAMP — NOT NULL
panelstatuslog
- id — INT — 기본 키 — NOT NULL
- status — INT — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- panel_id — INT — 외래 키 → panel.id — NOT NULL
user
- id — INT — 기본 키 — NOT NULL
- user_id — VARCHAR(20) — NOT NULL
- user_pw — VARCHAR(255) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
userpanelrelation
- panel_id — INT — 외래 키 → panel.id — NOT NULL
- user_id — INT — 외래 키 → user.id — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
- updatedAt — TIMESTAMP — NOT NULL