test

Tables (4)

questions (문제)

  • year (년도) — Foreign key → years.year — NOT NULL
  • month (월) — Foreign key → years.month — NOT NULL
  • subject (과목) — Foreign key → subjects.subject — NOT NULL
  • no (번호)
  • passage (지문)
  • question (문제)
  • rate (정답률)
  • answer (정답)
  • point (점수)
  • mp3 (듣기파일)
  • type (문제타입)

ranks (등급컷)

  • year (년도) — Foreign key → years.year — NOT NULL
  • month (월) — Foreign key → years.month — NOT NULL
  • subject (과목) — Foreign key → subjects.subject — NOT NULL
  • grade (등급)
  • point (점수)

subjects (시험과목)

  • subject (과목) — Primary key — NOT NULL
  • kor (한글명)

years (년도)

  • year (년도) — Primary key — NOT NULL
  • month (월) — Primary key — NOT NULL