SignLED

테이블 (11)

그룹 (t_group)

  • Key (groupid) — int — 기본 키 — NOT NULL
  • Key (terid) — int — 외래 키 → 단말기.Key — NOT NULL
  • Field (groupname) — varchar — NOT NULL

단말기 (t_terminal)

  • Key (terid) — int — 기본 키 — NOT NULL
  • Field (tername) — varchar
  • Field2 (terip) — varchar — NOT NULL
  • Field3 (terport) — int — NOT NULL
  • Field4 (terver) — varchar — NOT NULL
  • Field5 (ontime) — varchar
  • Field6 (offtime) — varchar
  • Field7 (brighttype) — int — NOT NULL
  • Field8 (temp) — int — NOT NULL
  • Field9 (humi) — int — NOT NULL
  • Field10 (regtime) — timestamp
  • Field11 (terxpos) — int
  • Field12 (terypos) — int

단말기_상태정보 (t_tersts)

  • Key (terid) — int — 외래 키 → 단말기.Key — NOT NULL
  • Field (disp) — int
  • Field2 (com) — int
  • Field3 (bright) — int
  • Field4 (temp) — int
  • Field5 (humi) — int
  • Field6 (fan) — int
  • Field7 (heater) — int
  • Field8 (regtime) — timestamp

레이아웃 (t_layout)

  • Key (layoutid) — int — 기본 키 — NOT NULL
  • Field (snrname) — varchar — NOT NULL
  • Field2 (regtime) — timestamp
  • Field3 (snrtask) — int
  • Field4 (snrtype) — int
  • Field5 (snrwidth) — int
  • Field6 (snrheight) — int
  • Field7 (snrxpos) — int
  • Field8 (snrypos) — int

사용자 (t_user)

  • Key (userid) — int — 기본 키 — NOT NULL
  • Field (username) — varchar
  • Field2 (userpw) — varchar
  • Field3 (usergrade) — int
  • Field4 (regtime) — timestamp

스케줄 (t_sch)

  • Key (schid) — int — 기본 키 — NOT NULL
  • Field (schname) — varchar — NOT NULL
  • Field2 (regtime) — timestamp
  • Field3 (schwidth) — int
  • Field4 (schheight) — int

스케줄_단말기 (t_schter)

  • Key (schid) — int — 외래 키 → 스케줄.Key — NOT NULL
  • Key (terid) — int — 외래 키 → 단말기.Key — NOT NULL

스케줄_레이아웃 (t_schlayout)

  • Key (schid) — int — 외래 키 → 스케줄.Key — NOT NULL
  • Key (layoutid) — int — 외래 키 → 레이아웃.Key — NOT NULL

시나리오 (t_senario)

  • Key (layoutid) — int — 외래 키 → 레이아웃.Key — NOT NULL
  • Key (conid) — int — 외래 키 → 컨텐츠.Key — NOT NULL

유저_로그 (t_userlog)

  • Key (userid) — int — 외래 키 → 사용자.Key — NOT NULL
  • Field (logtype) — int
  • Field2 (log) — varchar — NOT NULL
  • Field3 (recvtime) — timestamp

컨텐츠 (t_content)

  • Key (conid) — int — 기본 키 — NOT NULL
  • Field (conname) — varchar — NOT NULL
  • Field2 (regtime) — timestamp
  • Field3 (contask) — int
  • Field4 (playtime) — int
  • Field5 (starttime) — timestamp
  • Field6 (endtime) — timestamp
  • Field7 (week) — varchar
  • Field8 (effect) — int
  • Field (filename) — varchar
  • Field (filesize) — varchar