fineapple
Tables (7)
board
- Key (post_no) — NUMBER(8) — Primary key — NOT NULL
- Field (user_id) — VARCHAR2(30)
- Field (group_no) — NUMBER(8)
- Field (post_cate) — VARCHAR2(30)
- Field (update_stt) — NUMBER(1)
- Field (title) — VARCHAR2(300)
- Field (content) — VARCHAR2(4000)
- Field (post/-date) — DATE
- Field (view_count) — NUMBER(3)
comments
- Key (cmnt_no) — NUMBER(8) — Primary key — NOT NULL
- Field — NUMBER(8)
- Field (cmnt_user_id) — VARCHAR2(30)
- Field (update_stt) — NUMBER(1)
- Field (cmnt_content) — VARCHAR2(100)
- Field2 (cmnt_date) — DATE
exer
- Key (exer_no) — NUMBER(8) — Primary key — NOT NULL
- Field (exer_cate) — VARCHAR2(10)
- Field (exer_lv) — VARCHAR2(10)
- Field (exer_name) — VARCHAR2(30)
- Field (exer_kcal) — NUMBER(5,1)
- Field (exer_video_name) — VARCHAR2(100)
- Field (exer_video_time) — VARCHAR2(100)
- Field (exer_link) — VARCHAR2(1000)
food
- Key (food_no) — NUMBER(8) — Primary key — NOT NULL
- Field (food_name) — VARCHAR2(100)
- Field (food_kcal) — NUMBER(5,1)
- Field (serving_size) — NUMBER(5,1)
- Field (IS_API) — NUMBER(1)
- Field (food_cd) — VARCHAR2(10)
- Field (food_carb) — NUMBER(5,1)
- Field (food_protein) — NUMBER(5,1)
- Field8 (food_fat) — NUMBER(5,1)
- Field (food_sodium) — NUMBER(8,1)
- Field (food_sugar) — NUMBER(8,1)
intake_record
- Key (intake_record_no) — NUMBER(8) — Primary key — NOT NULL
- Field (user_service_no) — NUMBER(8)
- Field (user_id) — VARCHAR(100)
- Field (food_cd) — VARCHAR(8)
- Field (intake_record_date) — DATE
- Field5 (user_food_intake) — NUMBER(5,1)
- Field (meal) — VARCHAR(10)
- Field (food_kcal) — NUMBER(5,1)
- Field (food_carb) — NUMBER(5,1)
- Field (food_protein) — NUMBER(5,1)
- Field (food_fat) — NUMBER(5,1)
- Field (food_name) — VARCHAR2(500)
users
- Key (user_id) — VARCHAR(100) — Primary key — NOT NULL
- Field (diet_servic_no) — NUMBER(8)
- Field (exer_servuce_no) — NUMBER(8)
- Field (role) — VARCHAR(100)
- Field (gender) — VARCHAR(100)
- Field (blc_rgs_stt) — VARCHAR(100)
- Field (user_leave_stt) — VARCHAR(100)
- Field (cellphone) — VARCHAR(11)
- Field (user_name) — VARCHAR(100(
- Field (password) — VARCHAR(128)
- Field (age) — NUMBER(3)
- Field (reg_date) — DATE
- Field (strd_wtr_intake) — NUMBER(5,2)
- Field (service_trgt) — VARCHAR(20)
- Field (trgt_weight) — NUMBER(5,1)
- Field (trgt_body_fat) — NUMBER(5,1)
- Field (trgt_body_muscle) — NUMB(5,1)
- Field (blc_body_muscle) — NUMBER(5,1)
- Field (blc_add_date) — DATE
- Field (blc_add_why) — VARCHAR2(200)
- Field (user_stt_msg) — VARCHAR2(200)
- Field (kakao_stt) — NUMBER(1)