123

Tables (4)

member

  • IDX (Key) — INT(11) — Primary key — NOT NULL
  • id (Field) — VARCHAR(100)
  • pw (Field2) — VARCHAR100
  • name (Field3) — VARCHAR100
  • adress (Field4) — VNARCHAR100
  • sex (Field5) — VARCHAR100
  • email (Field6) — VARCHAR100

oxnote (Untitled)

  • seq (Key) — int(11) — Primary key — NOT NULL
  • IDX (Key2) — INT(11) — Foreign key → member.IDX — NOT NULL
  • prom (Field) — VARCHAR(50)
  • check_answer (Field2) — VARCHAR(50)
  • Comment (Field3) — VARCHAR(50)

promb (promble(*))

  • seq (Key) — int(11) — Primary key — NOT NULL
  • IDX (Key2) — INT(11) — Foreign key → member.IDX — NOT NULL
  • prom (Field) — VARCHAR(50)
  • answer1 (Field2) — VARCHAR(50)
  • answer2 (Field3) — VARCHAR(50)
  • answer3 (Field4) — VARCHAR(50)
  • answer4 (Field5) — VARCHAR(50)
  • check_answer (Field6) — VARCHAR(50)

score

  • id (Key) — VARCHAR(100) — Primary key — NOT NULL
  • score (Field) — VARCHAR(100)
  • IDX (Key2) — INT(11) — Foreign key → member.IDX — NOT NULL