Upbrain
Tables (35)
activity
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- step — int
- activity_time — int
- time_duration_type — varchar(40)
- kalo — int
- update_time — datetime
- time_update — varchar(100)
- id_day — varchar(105)
- device_data — varchar(45)
admin_note
- id — varchar(45) — Primary key — NOT NULL
- admin — varchar(45)
- create_time — datetime(6)
- update_time — datetime(6)
- action — varchar(45)
avatar_default
- id — varchar(40) — Primary key — NOT NULL
- link_avatar — varchar(450)
- type_avatar — varchar(45)
- order_by — int
blood_press
- id — varchar(45) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- update_time — datetime(6)
- time_duration_type — varchar(45)
- systolic — int
- diastole — int
- avg_systolic — int
- avg_diastole — int
- max_systolic — int
- max_diastole — int
- time_update — varchar(45)
- id_day — varchar(105)
- send_notice_time — datetime
body_composition
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- weight — decimal(10,2)
- skeletal — decimal(10,2)
- body_fat — decimal(10,2)
- time_duration_type — varchar(45)
- fat_mas — decimal(10,2)
- BMI — decimal(10,2)
- update_time — datetime(6)
- time — varchar(45)
- id_day — varchar(105)
- send_notice_time — datetime
chat
- id — varchar(40) — Primary key — NOT NULL
- room_id — varchar(45) — Foreign key → room_chat.id — NOT NULL
- user_send — varchar(40) — Foreign key → user.id — NOT NULL
- user_receive — varchar(40)
- create_time — datetime(6)
- view — tinyint(1)
- update_time — datetime(6)
- content — varchar(1005)
- type_chat — varchar(45)
faq
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- title — varchar(400)
- content — varchar(2000)
- create_time — datetime(6)
- secret — tinyint(1)
- photo — varchar(45)
- update_time — datetime(6)
- type — varchar(45)
- status — tinyint(1)
- file — varchar(45)
- view — int
feature
- id — varchar(45) — Primary key — NOT NULL
- user_feature — varchar(40) — Foreign key → role_user.id — NOT NULL
- feature — varchar(255)
- hidden — tinyint(1)
- deleted — tinyint(1)
heart_rate
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- avgbpm — int
- maxbpm — int
- update_time — datetime(6)
- time_duration_type — varchar(45)
- time_update — varchar(45)
- id_day — varchar(105)
- send_notice_time — datetime
home_item
- id — varchar(40) — Primary key — NOT NULL
- user — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- activity_day — tinyint(1)
- number_step — tinyint(1)
- work_out — tinyint(1)
- heart_rate — tinyint(1)
- menstrual — tinyint(1)
- body_composion — tinyint(1)
- blood_press — tinyint(1)
- sleep — tinyint(1)
- update_time — datetime(6)
inquiry
- id — varchar(45) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- title — varchar(255)
- content — varchar(1000)
- answer_content — varchar(1005)
- create_time — datetime(6)
- update_time — datetime(6)
- class_inquiry — varchar(45)
- secret — tinyint(1)
- photo — varchar(255)
- admin_answer_date — datetime(6)
- number_view — int
- type — varchar(45)
- file — varchar(45)
inquiry_report
- id — varchar(45) — Primary key — NOT NULL
- user_report — varchar(40) — Foreign key → user.id — NOT NULL
- room_chat — varchar(45)
- inquiry_id — varchar(45)
- reason_report — varchar(255)
- create_time — datetime(6)
- update_time — datetime(6)
- type_report — varchar(45)
- admin_note — varchar(255)
job_detail
- id — varchar(45) — Primary key — NOT NULL
- created_time — datetime
manage_together_sharing
- id — varchar(45) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- update_time — datetime(6)
- number_step — tinyint(1)
- work_out — tinyint(1)
- heart_rate — tinyint(1)
- menstrual_cycle — tinyint(1)
- body_composition — tinyint(1)
- blood_press — tinyint(1)
- sleep — tinyint(1)
menstrual_cycle
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- menstrual_date — datetime(6)
- update_time — datetime(6)
- time_duration_type — varchar(45)
- menstrual_number — int
- menstrual_day — int
menstrual_cycle_record
- id — varchar(45) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- update_time — datetime(6)
- menstrual_start — datetime(6)
- menstrual_end — datetime(6)
- birth_start — datetime(6)
- birth_end — datetime(6)
- setting_menstrual — varchar(45)
notice
- id — varchar(40) — Primary key — NOT NULL
- user_receive — varchar(40) — Foreign key → user.id — NOT NULL
- title — varchar(255)
- content — varchar(255)
- user_send — varchar(45)
- create_by — varchar(45)
- create_time — datetime(6)
- update_time — datetime(6)
- view — tinyint(1)
- type_notice — varchar(45)
- report — tinyint(1)
- deleted — tinyint(1)
- is_warning — tinyint(1)
- health_category — varchar(45)
- start_time — datetime(6)
- end_time — datetime(6)
notice_general
- id — varchar(45) — Primary key — NOT NULL
- user_receive — varchar(40) — Foreign key → user.id — NOT NULL
- create_by — varchar(45)
- notice_generalcol — varchar(45)
- title — text
- content — text
- create_time — datetime(6)
- update_time — datetime(6)
- view — int
- fix_top — tinyint(1)
- type_notice — varchar(45)
- status — tinyint(1)
- date_send — datetime(6)
- deleted — tinyint(1)
- notice_parent — varchar(45)
notice_schedule
- id — varchar(45) — Primary key — NOT NULL
- schedule — varchar(40) — Foreign key → schedule.id — NOT NULL
- user — varchar(40) — Foreign key → user.id — NOT NULL
- time — int
- time_push — datetime
- time_push_ago — datetime
notice_setting
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- warning — tinyint(1)
- periodicity — tinyint(1)
- random — tinyint(1)
- together — tinyint(1)
- schedule — tinyint(1)
- radio_button — tinyint(1)
- number_step — tinyint(1)
- work_out — tinyint(1)
- heart_rate — tinyint(1)
- menstrual_cycle — tinyint(1)
- body_composition — tinyint(1)
- blood_press — tinyint(1)
- sleep — tinyint(1)
- create_time — datetime(6)
- update_time — datetime(6)
number_step
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- step — int
- total_working — double
- total_kalo — double
- speed — double
- create_time — datetime(6)
- slep_goal — int
- time_duration_type — varchar(45)
- update_time — datetime(6)
- time_update — varchar(45)
- id_day — varchar(105)
- device_data — varchar(45)
push_token_list
- id — varchar(45) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- push_token — varchar(255)
- created_date — datetime(6)
- deleted — tinyint(1)
refresh_token
- id — varchar(45) — Primary key — NOT NULL
- user — varchar(40) — Foreign key → user.id — NOT NULL
- create_date — datetime(6)
- token — varchar(455)
role_user
- id — varchar(40) — Primary key — NOT NULL
- role_name — varchar(45)
room_chat
- id — varchar(45) — Primary key — NOT NULL
- create_time — datetime(6)
- update_time — datetime(6)
- content — varchar(45)
room_chat_user
- id — varchar(45) — Primary key — NOT NULL
- room_id — varchar(45) — Foreign key → room_chat.id — NOT NULL
- user_create — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- update_time — datetime(6)
- user_out_time — datetime(6)
- content — varchar(255)
- user_report — varchar(45)
- user_join
schedule
- id — varchar(40) — Primary key — NOT NULL
- start_time — datetime(6)
- end_time — datetime(6)
- title — varchar(245)
- content — varchar(245)
- notice — tinyint
- create_time — datetime(6)
- update_time — datetime(6)
- user — varchar(45)
setting_together
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- number_step — tinyint(1)
- work_out — tinyint(1)
- heat_rate — tinyint(1)
- menstrual_cycle — tinyint(1)
- body_composition — tinyint(1)
- blood_press — tinyint(1)
- sleep — tinyint(1)
sleep_time
- id — varchar(45) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- create_time — datetime(6)
- time_duration_type — varchar(45)
- time_update — varchar(100)
- point — int
- hour — int
- type_sleep — varchar(45)
- minute — int
- update_time — datetime(6)
- id_day — varchar(105)
together
- id — varchar(40) — Primary key — NOT NULL
- user — varchar(40) — Foreign key → user.id — NOT NULL
- user_together — varchar(40)
- status — varchar(45)
- create_time — datetime(6)
- update_time — datetime(6)
unit_measure
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- height — tinyint(1)
- weight — tinyint(1)
- number_step — tinyint(1)
- foot_size — tinyint(1)
- step_speed — tinyint(1)
- moving — tinyint(1)
- height_rate — tinyint(1)
- body_composion — tinyint(1)
- blood_pressure — tinyint(1)
- update_time — datetime(6)
- create_time — datetime(6)
upload_file
- id — varchar(45) — Primary key — NOT NULL
- inquiry — varchar(45) — Foreign key → inquiry.id — NOT NULL
- url — varchar(405)
user
- id — varchar(40) — Primary key — NOT NULL
- nick_name — varchar(45)
- email — varchar(45)
- phone — varchar(45)
- user_name — varchar(45)
- role — varchar(45)
- gender — tinyint(1)
- weight — double
- foot_size — double
- key — double
- deleted — tinyint(1)
- avatar — varchar(245)
- date_birth — datetime(6)
- create_date — datetime(6)
- foreign_id — varchar(45)
- login_method — varchar(45)
- height — double
- status — varchar(45)
- use_content — varchar(405)
- admin_note — varchar(405)
- invite_code — varchar(45)
- password — varchar(100)
- name — varchar(255)
- member_number — varchar(45)
- login_date — datetime(6)
- password_p — varchar(45)
- reason_stop — varchar(255)
- age — int
- role_user — varchar(45)
- date_stop — datetime
- user_id_agora — varchar(200)
- id (id2) — varchar(40) — Foreign key → user.id — NOT NULL
user_stop
- id — varchar(45) — Primary key — NOT NULL
- create_time — datetime(6)
- user — varchar(45)
- reason — varchar(255)
- admin_stop — varchar(45)
work_out
- id — varchar(40) — Primary key — NOT NULL
- user_id — varchar(40) — Foreign key → user.id — NOT NULL
- time_duration_type — varchar(45)
- create_time — datetime(6)
- total_time — int
- total_kalo — int
- total_working — double
- update_time — datetime(6)
- time_update — varchar(45)
- type_work_out — varchar(45)
- avgbpm — int
- max_hg — int
- min_hg — int
- speed — double
- start_time — datetime
- end_time — datetime
- id_day — varchar(105)