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