Radi Classic
Tables (11)
device_device
- id — int8 — Primary key — NOT NULL
- mac_id — varchar(20) — NOT NULL
- name — varchar(10) — NOT NULL
- model_type — int4
- version_name — varchar(10)
- profile_id_id — int8 — NOT NULL
- create_at — timestamptz — NOT NULL
- l_se_mode — varchar(23) — NOT NULL
- r_se_mode — varchar(23) — NOT NULL
- s_se_mode — varchar(23) — NOT NULL
device_devicestatus
- device_id_id — int8 — Primary key — NOT NULL
- update_at — timestamptz — NOT NULL
- l_mode — int4
- l_timer — int4
- r_mode — int4
- r_timer — int4
- status — int4 — NOT NULL
- power — bool — NOT NULL
- s_mode — int4
- s_timer — int4
- error_code — int4 — NOT NULL
device_sleeppattern
- id — int8 — Primary key — NOT NULL
- active — bool — NOT NULL
- l_mode — int4
- r_mode — int4
- sleep_at — time — NOT NULL
- wake_at — time — NOT NULL
- weekday — varchar(7) — NOT NULL
- preheat — bool — NOT NULL
- postheat — bool — NOT NULL
- sound — bool — NOT NULL
- sound_name — varchar(20) — NOT NULL
- device_id_id — int8 — NOT NULL
- s_mode — int4
- l_se_mode — varchar(23) — NOT NULL
- r_se_mode — varchar(23) — NOT NULL
- s_se_mode — varchar(23) — NOT NULL
etc_log
- id — int8 — Primary key — NOT NULL
- timestamp — timestamptz — NOT NULL
- req_ip — text — NOT NULL
- req_user_agent — text — NOT NULL
- req_method — varchar(10) — NOT NULL
- req_path — text — NOT NULL
- req_data — jsonb
- res_status_code — int4 — NOT NULL
- res_data — jsonb
etc_loopcmd
- id — int8 — Primary key — NOT NULL
- weekday — int4 — NOT NULL
- hour — int4 — NOT NULL
- minute — int4 — NOT NULL
- topic — text
- cmd — jsonb
- sleep_pattern_id_id — int8 — NOT NULL
- is_wakeup — bool — NOT NULL
- send_fcm — bool — NOT NULL
etc_oneoffcmd
- id — int8 — Primary key — NOT NULL
- date — date — NOT NULL
- hour — int4 — NOT NULL
- minute — int4 — NOT NULL
- topic — text — NOT NULL
- cmd — jsonb — NOT NULL
firmware_firmware
- id — int8 — Primary key — NOT NULL
- version_name — varchar(10) — NOT NULL
- target_model_type — varchar(10) — NOT NULL
- s3_url — varchar(200) — NOT NULL
- push — bool — NOT NULL
- pre_approve_1 — bool — NOT NULL
- pre_approve_2 — bool — NOT NULL
- approve — bool — NOT NULL
- show — bool — NOT NULL
firmware_updatefirmware
- id — int8 — Primary key — NOT NULL
- update_at — timestamptz — NOT NULL
- device_id_id — int8 — NOT NULL
- firmware_id_id — int8 — NOT NULL
- one_off_cmd_id_id — int8 — NOT NULL
myAuth_verifycode
- id — int8 — Primary key — NOT NULL
- phone_num — varchar(20) — NOT NULL
- verify_code — varchar(10) — NOT NULL
- expired_at — timestamptz — NOT NULL
myProfile_profile
- id — int8 — Primary key — NOT NULL
- email — varchar(254) — NOT NULL — deprecated
- password — text — NOT NULL
- name — varchar(10) — NOT NULL
- phone_num — varchar(20) — NOT NULL
- gender — varchar(1) — NOT NULL
- birth — date — NOT NULL
- fcm_token — text
- app_version — varchar(10)
- app_build — int4
- os — varchar(10)
- create_at — timestamptz — NOT NULL
- last_login — timestamptz — NOT NULL
notice_notice
- id — int8 — Primary key — NOT NULL
- title — varchar(50) — NOT NULL
- body — text — NOT NULL
- active — bool — NOT NULL
- push — bool — NOT NULL
- create_at — timestamptz — NOT NULL
- update_at — timestamptz — NOT NULL