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