fooddata
Tables (11)
FoodData
- f_seq — int
- f_name — varchar(100)
- f_weight — int
- f_kcal — int
- f_carbohydrate_g — decimal(5,2)
- f_sugar_g — decimal(5,2)
- f_fat_g — decimal(5,2)
- f_protein_g — decimal(5,2)
- f_calcium_g — int
- f_phosphorus_mg — int
- f_sodium_mg — int
- f_potassium_mg — int
- f_magnesium_mg — int
- f_iron_mg — DECIMAL(5,2)
- f_zinc_mg — DECIMAL(5,2)
- f_cholesterol_mg — int
- f_trans_fat_g — DECIMAL(5,2)
Hdata
- h_seq — int
- m_seq — int — NOT NULL
- h_wdate — DATE
- body_fat — DECIMAL(5,2)
- h_muscle — DECIMAL(5,2)
- h_exerciseDuration — TIME
- h_kcal — INT
- h_heart_rate — INT
- h_sleep_duration — TIME
- h_step_count — INT
Member
- m_seq — int
- m_id — varchar(20)
- m_pw — varchar(100)
- m_name — varchar(20)
- m_gender — varchar(10)
- m_weight — decimal
- m_height — decimal
- m_mail — varchar(50)
- m_type — varchar(20)
- m_tel — varchar(20)
- m_filename — varchar(20)
- m_filesize — int
- m_target_calorie — INT
- m_target_weight — DECIMAL
- m_purpose — varchar(500)
NoticeBoard
- n_seq — int
- m_seq — int — NOT NULL
- n_subject — varchar(50)
- n_content — varchar(20)
- n_wdate — date
- n_hit — int
NoticeFile
- nf_seq — int
- n_seq — int — NOT NULL
- nf_filename — varchar(20)
- nf_filesize — int
UserBoard
- u_seq — int
- m_seq — int — NOT NULL
- u_subject — varchar(50)
- u_coment — varchar(2000)
- u_categori — varchar(20)
- u_hit — int
- u_cmt — int
UserCMT
- uc_seq — int
- u_seq — int — NOT NULL
- uc_wdate — date
- uc_content — varchar(20)
UserFile
- uf_seq — int
- u_seq — int — NOT NULL
- uf_filename — varchar(20)
- uf_filesize — int
m_FoodData
- f_seq — int
- m_seq — int — NOT NULL
- f_name — varchar(100)
- f_weight — int
- f_kcal — int
- f_carbohydrate_g — decimal(5,2)
- f_sugar_g — decimal(5,2)
- f_fat_g — decimal(5,2)
- f_protein_g — decimal(5,2)
- f_calcium_g — int
- f_phosphorus_mg — int
- f_sodium_mg — int
- f_potassium_mg — int
- f_magnesium_mg — int
- f_iron_mg — DECIMAL(5,2)
- f_zinc_mg — DECIMAL(5,2)
- f_cholesterol_mg — int
- f_trans_fat_g — DECIMAL(5,2)
m_mat
- exercise_id — INT
- m_seq — int — NOT NULL
- exercise_name — VARCHAR(100) — NOT NULL
- met_value — DECIMAL(5, 2
mat
- exercise_id — INT
- exercise_name — VARCHAR(100) — NOT NULL
- met_value — DECIMAL(5, 2) — NOT NULL