fineapple

Tables (7)

Untitled

    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)