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