hackytalky

테이블 (9)

Company

  • company_id — INT — 기본 키 — NOT NULL
  • company_name — NOT NULL

Lecture

  • lecture_id — INT — 기본 키 — NOT NULL
  • is_active — BOOL — NOT NULL
  • created_at — DATETIME — NOT NULL
  • 언어 (language) — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • thumbnail — VARCHAR(255)
  • 강의자 (lecturer) — VARCHAR(255) — NOT NULL
  • 수강 시간 (course_hours) — VARCHAR(255)
  • 난이도 (difficulty) — VARCHAR(255)
  • 교육 플랫폼 (company_id) — INT — 외래 키 → Company.company_id — NOT NULL
  • price — VARCHAR(255)
  • discount_price — VARCHAR(255)
  • introduction — TEXT
  • keyword — VARCHAR(255)
  • link — VARCHAR(255)
  • stacks

LectureStack

  • lecture_stack_id — INT — 기본 키 — NOT NULL
  • stack_category_id — INT — 외래 키 → StackCategory.stack_category_id — NOT NULL
  • lecture_id — INT — 외래 키 → Lecture.lecture_id — NOT NULL

Review

  • review_id — INT — 기본 키 — NOT NULL
  • lecture_id — INT — 외래 키 → Lecture.lecture_id — NOT NULL
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • star — INT — NOT NULL
  • good_review — TEXT — NOT NULL
  • bad_review — TEXT — NOT NULL
  • is_active — BOOL — NOT NULL
  • created_at — DATETIME — NOT NULL

StackCategory

  • stack_category_id — INT — 기본 키 — NOT NULL
  • parent_id — INT — 외래 키 → StackCategory.stack_category_id
  • stack_name — VARCHAR(255) — NOT NULL

User

  • user_id — INT — 기본 키 — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • password — VARCHAR(255) — NOT NULL
  • is_active — BOOL — NOT NULL
  • created_at — DATETIME — NOT NULL
  • github_id — VARCHAR(255)
  • blog_link — VARCHAR(255)

UserStack

  • user_stack_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • stack_category_id — INT — 외래 키 → StackCategory.stack_category_id — NOT NULL

게시판 (Board)

  • board_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_active — BOOL — NOT NULL

찜 목록 (Bookmark)

  • bookmark_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • lecture_id — INT — 외래 키 → Lecture.lecture_id — NOT NULL