123
Tables (10)
calendar
- cal_code — number — Primary key — NOT NULL
- cal_mem_id — number
- cal_task_date — date
- cal_title — varchar2(255)
- cal_description — varchar2(1500)
- cal_completed — number(1)
- cal_mem_img — varchar2(255)
com_cate
- cate_code — number — Primary key — NOT NULL
- cate_name — varchar2(255)
coment
- cmt_code — number — Primary key — NOT NULL
- cmt_post_code — number
- cmt_mem_id — number
- cmt_content — varchar2(1500)
- cmt_create_at — date
diag
- diag_code — number — Primary key — NOT NULL
- diag_mem_id — number
- diag_date — date
- diag_model_id — number
- diag_img — varchar2(255)
- diag_score — number(5,2)
- diag_answer — varchar2(1500)
likes
- like_code — number — Primary key — NOT NULL
- like_post_code — number
- like_mem_id — number
- like_created_at — date
member
- mem_id — number — Primary key — NOT NULL
- mem_email — varchar2(255) — NOT NULL
- mem_pwd — varchar2(255) — NOT NULL
- mem_nickname — varchar2(100)
- mem_profile_img — varchar2(255)
- mem_created_at — date
- mem_bir — date
notice
- noti_code — number — Primary key — NOT NULL
- noti_receiver_id — number
- noti_write_id — number
- noti_like_code — number
- noti_cmt_code — number
- noti_post_code — number
- noti_read_code — number(1)
- noti_created_at — date
post
- post_code — number — Primary key — NOT NULL
- post_mem_id — number
- post_title — varchar2(255)
- post_content — varchar2(1500)
- post_view — number
- post_like — number
- post_scrap — number
- post_date — date
- post_cate_code — number
- post_read — number(1)
pred_model
- model_code — number — Primary key — NOT NULL
- model_name — varchar2(100)
scrap
- scrap_code — number — Primary key — NOT NULL
- scrap_post_code — number
- scrap_mem_id — number
- scrap_created_at — date