make-test

Tables (8)

make-test-user

  • id — int — Primary key — NOT NULL
  • username (Field) — varchar(20)
  • Field2

rank (Untitled2)

  • rank_id (Key) — Primary key — NOT NULL
  • Key (test-id) — Foreign key → test.test-id — NOT NULL
  • id (id2) — int — Foreign key → test.id — NOT NULL

solve-user (Untitled3)

  • rank_id (Key2) — Foreign key → rank.rank_id — NOT NULL
  • test-id (test-id2) — Foreign key → rank.Key — NOT NULL
  • id — int — Foreign key → rank.id — NOT NULL
  • username (Field)

test

  • test-id — int — Primary key — NOT NULL
  • id — int — Foreign key → make-test-user.id — NOT NULL

test_answer (Untitled)

  • answer_id (Key) — Primary key — NOT NULL
  • question_id (Key2) — Foreign key → test_question.question_id — NOT NULL
  • test-id — int — Foreign key → test_question.test-id — NOT NULL
  • id (id2) — int — Foreign key → test_question.id — NOT NULL
  • answer (Field)

test_example (Untitled5)

  • question_id (Key) — Foreign key → test_question.question_id — NOT NULL
  • test-id — int — Foreign key → test_question.test-id — NOT NULL
  • id (id2) — int — Foreign key → test_question.id — NOT NULL
  • answer_ex (Field)

test_link (test-link)

  • test-id — int — Foreign key → test.test-id — NOT NULL
  • id (id2) — int — Foreign key → test.id — NOT NULL

test_question (Untitled4)

  • question_id (Key) — Primary key — NOT NULL
  • test-id — int — Foreign key → test.test-id — NOT NULL
  • id (id2) — int — Foreign key → test.id — NOT NULL
  • questions (Field) — varchar(1000)