Mentok
Tables (8)
Class (수업)
- id (pk) — int — Primary key — NOT NULL
- lecture (강의) — int — Foreign key → Lecture.id — NOT NULL
- User (유저(수강자)) — varchar(15) — Foreign key → User.id — NOT NULL
- teacher (강의자) — varchar(15)
- date (신청일자) — datetime
- state (진행상태) — varchar(10)
Lecture (강의)
- id (pk) — int — Primary key — NOT NULL
- User (강의자) — int — Foreign key → User.id — NOT NULL
- title (제목) — varchar(15)
- category (강의구분) — varchar(15)
- spentime (소요시간) — varchar(10)
- week (요일) — int
- time (시간) — int
- explain (강의소개) — varchar(300)
- recommend (추천대상) — varchar(300)
- file (강의자료) — file
- close (휴/폐강여부)
Review (강의후기)
- id (pk) — int — Primary key — NOT NULL
- Lecture (강의) — int — Foreign key → Lecture.id — NOT NULL
- date (작성일시) — datetime
- contents (작성내용) — varchar(200)
Usepoint (포인트사용)
- id (pk) — int — Primary key — NOT NULL
- User (유저) — int — Foreign key → User.id — NOT NULL
- goods (신청상품) — varchar(30)
- link (구매링크) — varchar(30)
- price (제품가격) — int
- usepoint (사용한포인트) — int
User (유저)
- id (pk) — int — Primary key — NOT NULL
- name (이름) — varchar(15)
- team (직무) — varchar(10)
- joindate (입사일) — date
- phonenumber (전화번호) — int
- toktokid (똑개 계정)
- email (이메일) — varchar(30)
- github (깃허브) — varchar(30)
- birthday (생일) — date
- totalpoint (전체포인트) — int
- usepoint (사용한 포인트) — int
- point (잔여포인트) — int
mission (미션)
- id (pk) — int — Primary key — NOT NULL
- User (유저) — int — Foreign key → User.id — NOT NULL
- title (미션명) — varchar(20)
- contents (미션내용) — varchar(200)
- success (수행여부) — bool
- order (미션순서) — int
point (포인트)
- id (pk) — int — Primary key — NOT NULL
- User (유저) — int — Foreign key → User.id — NOT NULL
- createdate (적립일시) — datetime
- newpoint (적립포인트) — int
- reason (적립사유) — varchar
quiz (퀴즈)
- id (pk) — int — Primary key — NOT NULL
- User (유저) — int — Foreign key → User.id — NOT NULL
- question (퀴즈질문) — varchar(50)
- Answer (답변) — varchar(50)
- order (퀴즈순서) — int