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