tenex_db
Tables (19)
Course (course)
- Course ID (course_id) — INT — Primary key — NOT NULL
- Title (title) — VARCHAR(128)
- Price (price) — INT
- Detail Image (detail_img) — URL
- Preview Video (preview) — URL
- Update Datetime (update_datetime) — DATETIME
- Create Datetime (create_datetime) — DATETIME
Enrollment (enrollment)
- Key (enrollment_id) — INT — Primary key — NOT NULL
- Field (enrollment_datetime) — DATETIME
- Field (status) — ENUM
- Field (progress) — FLOAT
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
- Course ID (course_id) — INT — Foreign key → Course.Course ID — NOT NULL
- Section ID (section_id) — INT — Foreign key → Section.Section ID — NOT NULL
Section (section)
- Section ID (section_id) — INT — Primary key — NOT NULL
- Order (order) — INT
- Start DateTime (start_datetime) — DATETIME
- End DateTime (end_datetime) — DATETIME
- Capacity (capacity) — INT
- Course ID (course_id) — INT — Foreign key → Course.Course ID — NOT NULL
Untitled (review)
- Key (review_id) — INT — Primary key — NOT NULL
- Field (create_datetime) — DATETIME
- Field (update_datetime) — DATETIME
- Field (content) — VARCHAR(4096)
- Course ID (course_id) — INT — Foreign key → Course.Course ID — NOT NULL
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
- Key (enrollment_id) — INT — Foreign key → Enrollment.Key — NOT NULL
Untitled (comment_like)
- Key (comment_id) — INT — Foreign key → Untitled.Key — NOT NULL
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
Untitled (community_comment)
- Key (comment_id) — INT — Primary key — NOT NULL
- Field (create_datetime) — DATETIME
- Field (update_datetime) — DATETIME
- Field (content) — VARCHAR(4096)
- Field (like_count) — INT
- Key (post_id) — INT — Foreign key → Untitled.Key — NOT NULL
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
Untitled (post_content_block)
- Key (order) — INT — Primary key — NOT NULL
- Key (post_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (type) — ENUM
- Field (content) — VARCHAR(4096)
- Field (img) — URL
Untitled (post_view)
- Key (post_id) — INT — Foreign key → Untitled.Key — NOT NULL
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
Untitled (post_like)
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
- Key (post_id) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (community_post)
- Key (post_id) — INT — Primary key — NOT NULL
- Field (type) — VARCHAR(128)
- Field (title) — VARCHAR(256)
- Field (view_count) — INT
- Field (like_count) — INT
- Field (create_datetime) — DATETIME
- Field (update_datetime) — DATETIME
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
- Course ID (course_id) — INT — Foreign key → Course.Course ID — NOT NULL
Untitled (user_step_result)
- Key (step_result_id) — INT — Primary key — NOT NULL
- Field (approval_status) — ENUM
- Field (upload_datetime) — DATETIME
- Field (type) — ENUM
- Field (content) — VARCHAR(4096)
- Field (img) — URL
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
- Key (step_id) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (course_step_reply)
- Key (step_reply_id) — INT — Primary key — NOT NULL
- Field (is_mentor) — BOOLEAN
- Field (content) — VARCHAR(4096)
- Field (create_datetime) — DATETIME
- Field (update_datetime) — DATETIME
- Key (step_question_id) — INT — Foreign key → Untitled.Key — NOT NULL
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
Untitled (course_step_question)
- Key (step_question_id) — INT — Primary key — NOT NULL
- Field (title) — VARCHAR(64)
- Field (create_datetime) — DATETIME
- Field (update_datetime) — DATETIME
- Field (view_count) — INT
- Field (content) — VARCHAR(4096)
- Key (step_id) — INT — Foreign key → Untitled.Key — NOT NULL
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
Untitled (course_step_block)
- Key (order) — INT — Primary key — NOT NULL
- Key (step_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (type) — ENUM
- Field (content) — VARCHAR(1024)
- Field (img) — URL
Untitled (course_step)
- Key (step_id) — INT — Primary key — NOT NULL
- Field (order)
- Key (index_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Course ID (course_id) — INT — Foreign key → Course.Course ID — NOT NULL
Untitled (course_index)
- Key (index_id) — INT — Primary key — NOT NULL
- Field (title) — VARCHAR(64)
- Field (order) — INT
- Course ID (course_id) — INT — Foreign key → Course.Course ID — NOT NULL
Untitled (purchase)
- Key (purchase_id) — INT — Primary key — NOT NULL
- Field (purchase_datetime) — DATETIME
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
- Course ID (course_id) — INT — Foreign key → Course.Course ID — NOT NULL
Untitled (course_mentor)
- User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
- Course ID (course_id2) — INT — Foreign key → Course.Course ID — NOT NULL
User (user)
- User ID (user_id) — INT — Primary key — NOT NULL
- Name (name) — VARCHAR(10)
- Email (email) — VARCHAR(50)
- Password (password) — VARCHAR(50)
- Gender (gender) — ENUM
- User Type (user_type) — ENUM
- Phone Number (phone) — VARCHAR(11)
- Birthday (birthday) — DATE
- Profile Photo (profile_photo) — URL
- Self Introduction (intro) — VARCHAR(1024)
- User Rank (rank) — ENUM
- Register Datetime (register_datetime) — DATETIME
- Update Datetime (update_datetime) — DATETIME