JUNGLE_PROJECT2_CLONE
Tables (6)
categories
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
courses
- id — INT — Primary key — NOT NULL
- instructor_id — INT — Foreign key → users.id — NOT NULL
- category_id — INT — Foreign key → categories.id
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- price — INT — NOT NULL
- thumbnail_url — VARCHAR(500)
- created_at — DATETIME
enrollments
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- course_id — INT — Foreign key → courses.id — NOT NULL
- enrolled_at — DATETIME
reviews
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- course_id — INT — Foreign key → courses.id — NOT NULL
- rating — TINYINT — NOT NULL
- content — TEXT
- created_at — DATETIME
users
- id — INT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(100) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255)
- created_at — DATETIME
wishlists
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- course_id — INT — Foreign key → courses.id — NOT NULL
- created_at — DATETIME