20250108

Tables (8)

comment

  • comment_no — NUMBER
  • post_no — NUMBER
  • member_no — NUMBER
  • content — VARCHAR2(4000)
  • created_date — DATE
  • status — CHAR(1)

daily_post

  • post_no — NUMBER
  • board_no — NUMBER
  • member_no — NUMBER
  • content — CLOB
  • view_count — NUMBER
  • created_date — DATE
  • expiry_date — DATE
  • post_status — CHAR(1)
  • category — VARCHAR2(50)

plan

  • plan_no — NUMBER
  • planner_no — NUMBER
  • subject_no — NUMBER
  • plan_date — DATE
  • target_study_time — NUMBER

planner

  • planner_no — NUMBER
  • member_no — NUMBER
  • created_date — DATE
  • total_study_time — NUMBER

product

  • product_no — NUMBER
  • product_name — VARCHAR2(100)
  • product_type — VARCHAR2(50)
  • price — NUMBER
  • description — VARCHAR2(4000)
  • product_image — VARCHAR2(200)
  • sales_status — CHAR(1)
  • reg_date — DATE
  • update_date — DATE

profile

  • profile_no — NUMBER
  • member_no — NUMBER
  • nickname — VARCHAR2(50)
  • introduction — VARCHAR2(1000)
  • image — VARCHAR2(200)
  • online_status — CHAR(1)
  • achievement_yn — CHAR(1)
  • achievement_condition — VARCHAR2(200)

purchase

  • order_no — NUMBER
  • product_no — NUMBER
  • member_no — NUMBER
  • purchase_date — DATE

reply

  • reply_no — NUMBER
  • post_no — NUMBER
  • member_no — NUMBER
  • title — VARCHAR2(200)
  • content — CLOB
  • created_date — DATE
  • modified_date — DATE
  • reply_status — CHAR(1)