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)