project
Tables (6)
comment (댓글)
- id (인조키) — int — Primary key — NOT NULL
- user_id (댓글러) — int — Foreign key → user.id — NOT NULL
- community_id (게시글id) — int — Foreign key → community.id — NOT NULL
- content (댓글) — text
- createAt (생성일시) — datetime
community (커뮤니티 게시글)
- id (인조키) — int — Primary key — NOT NULL
- user_id (생성자) — int — Foreign key → user.id — NOT NULL
- title (제목) — varchar(32)
- content (내용) — text
- createAt (생성일시) — datetime
course (강의)
- id (강의id) — int — Primary key — NOT NULL
- user_id (유저id) — int — Foreign key → user.id — NOT NULL
- teacher_id (선생님 ID) — int
- category_id (카테고리ID) — int
- photo (강의 사진 URL) — varchar
- title (강의명) — varchar
- description (강의설명) — text
- reference (참고자료 링크) — varchar
- link (강의 링크) — varchar
course_category (강의 카테고리)
- id (인조키) — int — Primary key — NOT NULL
- name (카테고리명) — varchar
syllabus (강의 계획)
- id (인조키) — int — Primary key — NOT NULL
- course_id (강의id) — int — Foreign key → course.id — NOT NULL
- week (주차) — int
- content (강의 내용) — text
user (유저)
- id (인조키) — int — Primary key — NOT NULL
- login_id (아이디) — varchar(32)
- password (패스워드) — varchar(32)
- name (이름) — varchar(32)
- email (이메일) — varchar(32)
- usertype (권한) — varchar