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