peanut

Tables (7)

alarm

  • alarm_code — SERIAL — NOT NULL
  • type — TEXT
  • datetime — TIMESTAMP
  • contents — TEXT
  • read_status — BOOLEAN

login

  • login_code — SERIAL — NOT NULL
  • user_id — INTEGER — NOT NULL
  • datetime — TIMESTAMP

schedule

  • sch_code — SERIAL — NOT NULL
  • system_code — INTEGER — NOT NULL
  • building — TEXT
  • level — INTEGER
  • area — TEXT
  • sch — TEXT
  • process — TEXT
  • start_date — DATE
  • end_date — DATE
  • expected — DATE
  • manager — TEXT
  • reason — TEXT

sensing

  • sensing_code — TIMESTAMP — NOT NULL
  • sensor_code — INTEGER — NOT NULL
  • data — NUMERIC
  • goal — INTEGER

sensor (센서)

  • sensor_code — SERIAL — NOT NULL
  • system_code — INTEGER — NOT NULL
  • building — TEXT
  • level — INTEGER
  • area — TEXT
  • mac — VARCHAR(17) — NOT NULL
  • type — TEXT
  • install_datetime — TIMESTAMP
  • use_status — BOOLEAN

site

  • system_code — SERIAL — NOT NULL
  • site_code — INTEGER
  • name — TEXT
  • company — TEXT
  • img — BYTEA
  • start_date — DATE
  • end_date — DATE

users

  • user_id — SERIAL — NOT NULL
  • phone — INTEGER
  • name — TEXT
  • passwd — TEXT
  • authority — BOOLEAN