테스트
테이블 (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)