다빛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