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