JJDEV

Tables (4)

ALGO_LEARN (설명 테이블)

  • GBCD (Key) — NUMBER — Primary key — NOT NULL
  • URL (Field) — VARCHAR2
  • CONT (Field2) — VARCHAR2

PROBLEM (문제테이블)

  • SEQ (Key) — NUMBER — Primary key — NOT NULL
  • GBCD (Key2) — NUMBER — Primary key — NOT NULL
  • TITLE (Field) — VARCHAR2
  • CONT (Field2) — VARCHAR2
  • LEVEL (Field3) — NUMBER
  • PROB_SCOR (Field4) — NUMBER

USER (유저테이블)

  • ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • P/W (Field) — VARCHAR2
  • NAME (Field2) — VARCHAR2
  • ADDRESS (Field4) — VARCHAR2
  • PHONE (Field5) — NUMBER
  • EMAIL (Field3) — VARCHAR2
  • ADMIN_YN (Field6) — VARCHAR2

USER_SCRE (점수테이블)

  • ID (Key) — VARCHAR2 — Foreign key → USER.ID — NOT NULL
  • SCRE1 (Field) — NUMBER
  • SCRE2 (Field2) — NUMBER
  • SCRE3 (Field3) — NUMBER
  • SCRE_TOT (Field4) — NUMBER