테스트

테이블 (16)

admins

  • admin_id — NUMBER
  • username — VARCHAR2(100)
  • password — VARCHAR2(100)
  • email — VARCHAR2(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

bootcamps

  • bootcamp_id — NUMBER
  • name — VARCHAR2(200)
  • description — CLOB
  • location — VARCHAR2(200)
  • start_date — DATE
  • end_date — DATE
  • registration_deadline — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

comments

  • comment_id — NUMBER
  • user_id — NUMBER
  • post_id — NUMBER
  • parent_comment_id — NUMBER
  • content — CLOB
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

course_chapters

  • chapter_id — NUMBER
  • course_id — NUMBER
  • title — VARCHAR2(200)
  • description — CLOB
  • order — NUMBER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

course_lessons

  • lesson_id — NUMBER
  • chapter_id — NUMBER
  • title — VARCHAR2(200)
  • video_url — VARCHAR2(300)
  • duration — NUMBER
  • order — NUMBER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

course_reviews

  • review_id — NUMBER
  • user_id — NUMBER
  • course_id — NUMBER
  • rating — NUMBER
  • content — CLOB
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

invitations

  • invitation_id — NUMBER
  • sender_id — NUMBER
  • receiver_email — VARCHAR2(100)
  • invitation_code — VARCHAR2(50)
  • invitation_status — VARCHAR2(50)
  • created_at — TIMESTAMP
  • used_at — TIMESTAMP

likes

  • like_id — NUMBER
  • user_id — NUMBER
  • post_id — NUMBER
  • created_at — TIMESTAMP

notices

  • notice_id — NUMBER
  • admin_id — NUMBER
  • title — VARCHAR2(200)
  • content — CLOB
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

online_courses

  • course_id — NUMBER
  • title — VARCHAR2(200)
  • description — CLOB
  • duration — NUMBER
  • price — NUMBER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

payments

  • payment_id — NUMBER
  • user_id — NUMBER
  • content_id — NUMBER
  • payment_type — VARCHAR2(50)
  • payment_status — VARCHAR2(50)
  • payment_method — VARCHAR2(50)
  • payment_amount — NUMBER
  • payment_date — TIMESTAMP

posts

  • post_id — NUMBER
  • user_id — NUMBER
  • category — VARCHAR2(50)
  • title — VARCHAR2(200)
  • content — CLOB
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_reports

  • report_id — NUMBER
  • user_id — NUMBER
  • reported_user_id — NUMBER

users

  • user_id — NUMBER
  • username — VARCHAR2(100)
  • email — VARCHAR2(100)
  • password — VARCHAR2(100)
  • social_provider — VARCHAR2(50)
  • social_id — VARCHAR2(100)
  • profile_image — VARCHAR2(300)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

멤버 (Untitled)

  • id (long) — 기본 키 — NOT NULL
  • name (String)
  • age (int)
  • id (long2) — 외래 키 → 멤버이미지.id — NOT NULL

멤버이미지 (Untitled2)

  • id (long) — 기본 키 — NOT NULL
  • url (String)